… this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs… on, the replication logic only replicates that “command” across the slaves, not the actual imported data. If the INFILE data file… any of the slaves when you run this on master LOAD DATA INFILE ‘/tmp/data.out’ INTO TABLE some_data_table; Using this…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… look at what the problem is. As of MySQL 5.5 FLUSH TABLES WITH READ LOCK does not work as optimally as… no MYISAM like table lock priority problem with pending WRITE query blocks any READ queries to execute on the table. mysql> show processlist… when backing up data from the slave with –safe-slave-backup option, as preventing writes to the slave can be done by simply…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…on slave. Real “parallel replication”. Automatic node provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL … Rolling Schema Update. Schema change does not block operations against table This is an General Availability release. We did our …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… clone new slaves from existing slaves using mylvmbackup or a method that is derived from that. Essentially, we are using FLUSH TABLES WITH…, and then it is being configured to become a new slave to the same master as the donor machine. Every once… experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ LOCK to get…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… if it is disable) and not print the position of slave thread in master logs at all. Here is some old…-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server. Also if you’re doing FLUSH TABLES WITH READ LOCK anyway you can consider doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
….txt’ INTO TABLE tbl; UNLOCK TABLES; This will dump master’s table content to the file clean the table on master and slave and refresh it on both of them. This obviously makes table… sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep_maint to rep_old, rep_new to rep; Query…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…(s) evict_outdated_slaves: A mandatory to set this to false otherwise Pacemaker will stop MySQL on a slave that lags behind. This… that table. op monitor: An entry is needed for each role, Master and Slave. Intervals must not be the same. Following the mysql… the MySQL configuration, Pacemaker will automatically add “skip-start-slave” for a saner behavior. One of the important setting is “log_slave_updates…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…: mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos: 207 slave1 > show status like ‘%temp%’; +————————+——-+ | Variable_name | Value | +————————+——-+ | Slave_open_temp_tables | 1 | +————————+——-+ The slave… see any way to use temporary tables with MySQL statement-based replication without some risk of breaking slaves. At some point I may…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, …_slave_hostsblogpercona.commanual Com_show_slave_statusblogpercona.commanual Com_show_statusblogpercona.commanual Com_show_storage_enginesblogpercona.commanual Com_show_table…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK… need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL Server to continue, which… the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to point slave to…
