[MDEV-31383] Mroonga wrapped InnoDB tables ending up corrupted Created: 2023-06-01  Updated: 2023-07-30

Status: Open
Project: MariaDB Server
Component/s: Galera SST, mariabackup
Affects Version/s: 10.11.3, 10.6.12, 10.6.13
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: Jozef Kováč Assignee: Kouhei Sutou
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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.

 Comments   
Comment by Kouhei Sutou [ 2023-06-21 ]

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?

Comment by Jozef Kováč [ 2023-06-30 ]

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.

Comment by Kouhei Sutou [ 2023-06-30 ]

Do you want to provide a patch that you used to MariaDB?

Generated at Thu Feb 08 10:23:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.