Tuesday, 29 September 2015

Change master to example for mysql slave

›
mysql>CHANGE MASTER TO MASTER_HOST='x.x.x.x',MASTER_USER='replication_user', MASTER_PASSWORD='password', MASTER_...
Wednesday, 9 September 2015

skip just one query hanging the slave using

›
mysql>SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; mysql>START SLAVE;
Monday, 7 September 2015

Set mysql delayed replication for mysql old backup

›
MySQL 5.6 is  adding slave replication delay: mysql> stop slave; mysql> CHANGE MASTER TO MASTER_DELAY = 604800; 604800=7days in...

Enable Mysql Archive engine

›
How to enable archive engine mysql> show engines; +------------+---------+-----------------------------------------------------------...
Tuesday, 1 September 2015

How to Check MySQL engine type of tables?

›
My MySQL database contains tables using different storage engines (specifically myisam,innodb and others...). mysql>SELECT TABLE_NAME,...
Monday, 31 August 2015

Run a query in MYSQL disable writing it to the binary log

›
The sql-log-bin session variable to turn off mysql>SET sql_log_bin = 0; all queries on your current session will not be sent to the ...
Wednesday, 26 August 2015

Mysql Multi or how to run multiple mysql instance on the same server master with multiple slave

›
Mysql Multi or how to run multiple mysql instance on the same server master with multiple slave Here is a  sample (highly customized) fil...
Sunday, 23 August 2015

How to create federated table in mysql Example

›
Federated engine enables data to be accessed from a remote MySQL database on a local server without using replication or cluster technology...
Friday, 21 August 2015

MySQL UDF on CENTOS 6 64-bit Example

›
You can add functions through the user-defined function (UDF) interface. User-defined functions are compiled as object files and then added...

Tune Master/Slave Replication

›
The option "slave_compressed_protocol", if it is set to 1, MySQL uses compression for the slave/master protocol if both the slav...