Search found 4 matches
- Tue Jan 12, 2016 6:27 pm
- Forum: MySQL / MariaDB Database Help and Discussion
- Topic: MariaDB galera cluster fail during dump or optimize
- Replies: 5
- Views: 12114
Re: MariaDB galera cluster fail during dump or optimize
I've noticed that the cluster still go's down after completing the backup with the new flow control settings..
- Tue Jan 12, 2016 9:29 am
- Forum: MySQL / MariaDB Database Help and Discussion
- Topic: MariaDB galera cluster fail during dump or optimize
- Replies: 5
- Views: 12114
Re: MariaDB galera cluster fail during dump or optimize
wsrep_replicate_myisam=1 Are you sure? :shock: Yup, most of my database is xtradb/innodb. I have a few tables that are myisam which aren't edited very often. As soon as I turn wsrep_on=ON into wsrep_on=OFF and restart the server the optimize and dump job run fine. That's most likely because OPTIMIZ...
- Mon Jan 11, 2016 6:00 pm
- Forum: MySQL / MariaDB Database Help and Discussion
- Topic: MariaDB galera cluster fail during dump or optimize
- Replies: 5
- Views: 12114
Re: MariaDB galera cluster fail during dump or optimize
Thank you for the quick reply. The node is working fine in production simulations up till I run the dump or optimize. (so I don't think there are any crashed tables, otherwise it would be in the log files. and the server wouldn't be working correctly for normal requests.) There aren't any running ap...
- Mon Jan 11, 2016 9:03 am
- Forum: MySQL / MariaDB Database Help and Discussion
- Topic: MariaDB galera cluster fail during dump or optimize
- Replies: 5
- Views: 12114
MariaDB galera cluster fail during dump or optimize
I'm experiencing an issue with a MariaDB cluster when dumping or optimizing databases. When I run a a "mysqlcheck" or a "mysqldump" on my MariaDB 10.1 database server (which runs in a Galera cluster with two other servers) then the tasks stop after a short time and don't show any...