Search found 4 matches

by gijs007
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..
by gijs007
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...
by gijs007
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...
by gijs007
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...