Percona cluster failed

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 […]

mariadb ibdata1 file huge

How to run mysqldump without slowing down your mysql server.

add –single-transaction –quick to mysqldump line mysqldump -u USER -p –single-transaction –quick –lock-tables=false DATABASE | gzip > OUTPUT.gz

Converting table from MyISAM to InnoDB engine headache error: “The used table type doesn’t 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 […]

cacti database headache

Kept getting database errors in my log. kept running myisamchk –extended-test *.MYI, then ‘myisamchk -r’ didn’t fix shit look for repair_database.php in /var/www/cacti/cli run php repair_database.php it will get rid of your headache