…. In the large databases I run in production relaying on MySQL Replication for HA I often have 15+ minutes reply… in this case DRBD slave node can’t be called hot because write load often does not… consistency – MySQL Replication can out of sync – and there is bunch of tips in documentation of how to …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…often get is how far MySQL may fall behind and how to keep replication…MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication…minute on the Master it will likely run 1 Minute…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… road. So how do people approach … plan, taking minutes or hours even…MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL…best to use MySQL Replication for upgrade. …often stage upgrades in time a bit so if something happens (like MySQL…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…MySQL replication…does not work in Oracle MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql…how long it takes to catch up. If you paused replication for 10 minutes and it took 5 minutes to catch up your replication…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…often…in 15 minutes…does MySQL Related work – it is very hard to find people with good enough MySQL knowledge. MySQL…MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…replication, and remember that the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy …problems every so often. Q16: How Innodb decided how many pages… to disk) once every minute or two. This way…
