Max transaction size limitation with Galera Cluster

[RepallePrabhakar]

Hi,

We were doing incremental replication from Oracle to the MariaDB Galera cluster. Everything is working fine with small tables, but we are facing an issue with large tables since the MariaDB Galera cluster should not allow a single transaction of more than 2GB. It fails in the last step, where the staging table is inserted into the actual table as a single insert. Is there any way to do frequent commits so that the transaction size will not reach the maximum size?

[MichalisDBA]

Hey @RepallePrabhakar

Have you tried to increase the wsrep_max_ws_rows and wsrep_max_ws_size?

https://mariadb.com/kb/en/galera-cluster-system-variables/#wsrep_max_ws_rows

https://mariadb.com/kb/en/galera-cluster-system-variables/#wsrep_max_ws_size