adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-11-03 07:22:22 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

Would like option to specify MySQL storage engine #733

New Issue
Open
opened 2026-10-05 00:14:31 +02:00 by adam · 3 comments
adam commented 2026-10-05 00:14:31 +02:00
Owner
Copy link
Copy source

My use case is that I'm installing to a Galera cluster, which doesn't have replication support for MyISAM tables. In lieu of changing the storage engine across the board (I saw #539), an option to specify would be helpful.

My use case is that I'm installing to a Galera cluster, which doesn't have replication support for MyISAM tables. In lieu of changing the storage engine across the board (I saw #539), an option to specify would be helpful. <!-- github-sync-id:279009501 -->
adam commented 2026-10-05 00:14:32 +02:00
Author
Owner
Copy link
Copy source

Any update on this? InnoDB is plenty quick these days and I too would like to use my Galera cluster for Piwigo

Any update on this? InnoDB is plenty quick these days and I too would like to use my Galera cluster for Piwigo <!-- github-comment-id:419943563 -->
adam commented 2026-10-05 00:14:33 +02:00
Author
Owner
Copy link
Copy source

I converted my Piwigo installation to use InnoDB instead. Here's a structure file that seems to be working with all search and various plugins.

Tested on both a 3-node Percona MySQL Cluster 5.6, and single node MariaDB 10.2

https://github.com/Piwigo/Piwigo/commit/bb5f4250c41601fd4b4a63555fef9f91f9fbd703#diff-8926b7c695b9c5d7c571b8e83045a335

I converted my Piwigo installation to use InnoDB instead. Here's a structure file that seems to be working with all search and various plugins. Tested on both a 3-node Percona MySQL Cluster 5.6, and single node MariaDB 10.2 https://github.com/Piwigo/Piwigo/commit/bb5f4250c41601fd4b4a63555fef9f91f9fbd703#diff-8926b7c695b9c5d7c571b8e83045a335 <!-- github-comment-id:425193017 -->
adam commented 2026-10-05 00:14:33 +02:00
Author
Owner
Copy link
Copy source

Seconding this. We currently have a deployment of piwigo blocked on GCP since GCP disables MyISAM support on their managed instances of MySQL

Seconding this. We currently have a deployment of piwigo blocked on GCP since GCP disables MyISAM support on their managed instances of MySQL <!-- github-comment-id:4040651198 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#733