… for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby server which is flipped into service… for replication. The buffer pool and adaptive hash index on the standby server will not have recently accessed pages. When it starts…_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log stream across log…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… be compared with this baseline to see how they are affected and how the system scales with … is going to happen — many batch jobs are written to be single-threaded. MySQL replication is single-thread…. When it comes to benchmarks I would love to see results published starting from concurrency of 1 …
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… be the logistics – how replication events are written on the master, how they are transferred to the replication slave and then how they are applied there…. When you start replication, two threads are started on the slave: 1. IO thread This process called IO thread connects to a master, reads…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… post tends to be more practical, we will see how to create/restore new slaves from a master using GTID. How to set up a… example of how to take a backup from the master and restore it on the slave to set up a new replication server. master… GTID_PURGED to the GTID_EXECUTED value from the master. So now, we just need to recover the dump and start the replication: slave1…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 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 15 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 lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
… will be replicated nearly instantly to all slave servers and just having a slave is not going to be helpful here. How can we… and it is very easy to use. It works stopping and starting the SQL Thread in order to archive the lag that you… using delayed replication slave. Is useful not only for disaster recovery but also to test how our application deal with lagged replication. With MySQL…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 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: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… the replication method between servers? A: If you would like to switch back and forth between galera and built-in mysql replication (asynchronous… can’t get a consistent binlog position in most causes to continue replication. Q: I hope that one point that is addressed… how to start up a cluster from scratch (i.e. a standalone XtraDB Cluster machine, convert it to a cluster type, and add nodes to…
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: …
