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

http://pc-freak.net/blog/fix-mysql-ibdata-file-size-ibdata1-file-growing-large-preventing-ibdata1-eating-disk-space/ http://vdachev.net/2007/02/22/mysql-reducing-ibdata1/

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 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

Converting table from MyISAM to InnoDB engine headache error: “The used table type doesn’t support FULLTEXT indexes”

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

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