codership / galera

Synchronous multi-master replication library
GNU General Public License v2.0
447 stars 177 forks source link

Schema Upgrades: Can NBO Failback to TOI if not yet supported statement? #615

Open joffrey92 opened 2 years ago

joffrey92 commented 2 years ago

Hello,

Configured a Galera Cluster with wsrep_OSU_method=NBO

Confirming with application queries and documentation, we observed that not all commands are supported in NBO.

One example command is related to Stored Procedures:

ERROR 1235: This version of MySQL doesn't yet support 'Can't execute yet in NBO mode'
SQL Statement:
DROP procedure IF EXISTS `sp_mySuperSP` 

Would it be possible to fallback to TOI for non supported operations, instead of throwing the error ?

Thank you, Joffrey