one of the nodes failed then the whole cluster went down. shutdown mysql on all nodes cat /var/lib/mysql/grastate.dat check which node has the highest seq number boot strap that node service mysql bootstrap-pxc then start the next node but before that mv /var/lib/mysql/grastate.dat ~ service mysql start this will start a full resync wait till it […]

-rw-rw—- 1 kolbe kolbe 8.4K Mar 26 17:57 #sql-f3be_1.frm -rw-rw—- 1 kolbe kolbe 24M Mar 26 17:57 #sql-f3be_1.ibd https://mariadb.com/blog/get-rid-orphaned-innodb-temporary-tables-right-way

You can add –max_allowed_packet=512M to your mysqldump command. Or add max_allowed_packet=512M to [mysqldump] section of your my.cnf http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

add –single-transaction –quick to mysqldump line mysqldump -u USER -p –single-transaction –quick –lock-tables=false DATABASE | gzip > OUTPUT.gz http://stackoverflow.com/questions/5666784/how-can-i-slow-down-a-mysql-dump-as-to-not-affect-current-load-on-the-server http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html

CREATE TABLE new_foo LIKE foo; RENAME TABLE foo TO old_foo, new_foo TO foo; DROP TABLE old_foo; http://stackoverflow.com/questions/879327/quickest-way-to-delete-enormous-mysql-table

http://linuxhostingsupport.net/blog/converting-table-to-innodb-the-used-table-type-doesnt-support-fulltext-indexes   mysql> ALTER TABLE test ENGINE=InnoDB; ERROR 1214: The used table type doesn’t support FULLTEXT indexes mysql> show create table test; ———————— | Table | Create Table ———————— | test | CREATE TABLE `test` ( `col_name` varchar(10) DEFAULT NULL, FULLTEXT KEY `keyname` (`col_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | mysql> ALTER TABLE test DROP INDEX […]

http://www.softwareprojects.com/resources/programming/t-how-to-check-mysql-replication-databases-are-in-syn-1832.html