…Mysqldump works well for this, but can quite slow on larger schemas. One of the downsides…that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table,…=”^orig[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…! There are numerous solutions for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby server … http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines everything… nice to analyze your replication traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it… taken at the wrong time may be responsible for unexpected MySQL replication lag.
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication …time of queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging …
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node which handles… in case of MySQL Replication is handled by cluster internally – for example if timeouts are reconfigured the transient network slowness can be seen…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means… out and slow down your batch job (such as adding sleep calls) to ensure there is enough breathing room for replication thread…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with slow query…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded …-digest with filter to only check queries from replication thread: mk-query-digest slow-log –filter ‘($event->{user} || “”) =~ m/[SLAVE_THREAD]/’ > /tmp… same as replication load. This gives us replication capacity of 1/0.37 = 2.70 This method should work with original MySQL Server…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
… just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not… to analyze slow query log to find what queries take up the most resources on your server – in certain configurations replication load… consider – slow replication queries also identify replication lag, ie if you have query which ran 10 seconds on the slave and your replication is…
