Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.3, 10.6.12, 10.6.13
-
None
-
Oracle Linux 8.8 x86_64
Description
Mroonga in wrapper mode over InnoDB works nice under MariaDB Galera cluster except SST transfer where result depend on method:
mariabackup -> corrupted
rsync -> corrupted
mysqldump -> works but just as regular InnoDB tables
Corrupted tables could be repaired with innodb_force_recovery=1 and will be just regular InnoDB tables, also with mysqldump method mroonga FUNCTIONS and INSTALL PLUGIN mroonga SONAME 'ha_mroonga.so' it`s not replicated to joining node.
Using mariabackup/rsync looks like only missing is <db_name>.mrn files from datadir, when you try manual SST of Galera Cluster Node With Mariabackup and just copy this files everything is working aka Mariabackup is not backuping this mroonga related files.
With mysqldump method i try to install mroonga engine before joining but this going end up overwritten.
This is more feature request than bug i presume should not be hard to implement support for mroonga in wrapper mode in Mariabackup and also MariaDB Galera Cluster.
Attachments
Activity
I was actually capable reach working galera cluster with mroonga(wrapper mode) tables using modified rsync SST, only added one rsync block to copy mroonga files.
I think that Mroonga's wrapper mode isn't suitable for Galera Cluster because Galera Cluster highly depends on InnoDB.
I have an idea for new approach that replaces Mroonga's wrapper mode. It's a replication mode. It replicates data in an existing local table to another local table. For the wrapper mode's use case, InnoDB is used for the existing local table and Mroonga's storage mode is used for the another local table. If an user changes InnoDB table, Mroonga's storage mode table is synchronized automatically. It'll be able to implement by reading local binlog periodically.
But it's still an idea. I haven't implemented this yet. (I need to time to implement this or money to work on this in work time.)
So I want to close this feature request as "WONT FIX".
> With mysqldump method i try to install mroonga engine before joining but this going end up overwritten.
Hmm. It's strange. Who did disable the manual installed Mroonga?