…’.I agree that matching logs is very tedious but how about ‘row based replication‘ ? i think it can help.Or may be…_master_log_pos: 2399 ) was replicating from these positions before crashing then we can tell C to start replicating from A with “relay_master… for some time untill replication catches up.This should work fine in ‘row based replication‘ correct ? because even pointing to previous position and…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling New SST wsrep_sst_method=skip, useful when you start all….04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster, we will be giving a free webinar…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…precautions to avoid phantom reads and to get a consistent Statement based replication. To … age | +——+ | 21 | | 25 | | 30 | +——+ Start a transaction and delete the record 25: transaction1 > START TRANSACTION; …of data to other sessions. How to troubleshoot gap locks? Is possible to detect…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
March 7, 2012 By 94 Comments
… on the cluster. What I wanted to do is add another server to the cluster. The “replication_info” config setting is only changed when a new master is elected. So how to add a… replication_info -s mysql_replication -v “||” Now start corosync on your slave and let it join the cluster, it will now correctly start slaving…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… explain what Percona XtraDB Cluster is and how does it work, you still have time to register today. I expect XtraDB Cluster… or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel replication”. Automatic node provisioning. Data… required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…hours for this statement to complete. Here is example how it can look: mysql> show processlist; …to complete. What is worse as the statement started execution all writes will be blocked to …option, as preventing writes to the slave can be done by simply pausing replication…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…credit card debt: easy to start, impossible to dig out afterwards. Another…replication-running checks that replication is functioning correctly. Replicas have different data than their master. In addition to delay or failure, replication… recently. It is surprising how often a server crashes, …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… how far MySQL may fall behind and how to keep replication from lagging. The lag you will see will vary a lot from application to the application and from load to… run ALTER TABLE query. Replication Overload Many tutorials out where will give you impression problem with replication starts only when write load is…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
… To name a few: the big LOAD DATA INFILE clogs the binary log and slows replication …starts swapping between its buffer pool and the tablespace on disk. Most seriously, if something should happen and the load needs to… 1M because the rows were small). But how to do this without splitting the file? The…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… while ago I wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is … kill -9, and see what happens. $ ./node1/stop $ ./node1/start $ ./s1 slave1 > show slave status\G *************************** 1. row *************************** Last_Errno: …
