… are overloading the system causing user experience to degrade. The first thing you need to know it is not MySQL problem, might… your MySQL configuration, queries and hardware, even though fixing these does help in many cases. Whatever powerful and well tuned system you… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… MySQL Restart – the traffic on different boxes might be different and hence cache content. Replication Traffic Changes Changing in the replication traffic… causes replication lag. Same may happen with operating system and other system software involved. In could be even system which queries mysql. …
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… posted very nice post about MySQL Replication Performance. There are however few points I should …the same terms, in fact they are quite different for Replication. As you probably know MyISAM uses …days. Other two probably just create conditions for Operation System to fake fsync. You need to get …
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… is ability of MySQL to use powerful system (including powerful storage) – Is quite limited with single thread replication as well as…difference between MySQL and Oracle deployments, yet as MySQL is getting better and better handling large scale systems (both in terms of performance and operationally…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as these are a bit from different…MySQL Replication to DRBD in this case – in both cases due to some reasons you can have systems…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘…mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. Replicas have different… an incremental mode of operation, so you can (for …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…MySQL replication to become bottleneck when Master server …difference becomes, as long as replication remains single thread process. At the same time it is a lot easier to optimize your system… the loaded replication capacity matters during normal operation. So we defined what replication capacity is….
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…difference for most enterprises vs most of web applications in insane. Not only that but many of these systems… lag in MySQL Replication is another …operate with concepts which are not very efficiently handled with SQL and relational operations (think social graph or permissions). I would expect MySQL…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…different…MySQL if you’re looking for durable transactions the log write latency is triple important compared to other database systems. MySQL…MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…MySQL version upgrade involves new Operating System and hardware and any of them could be potential cause of rollback. MySQL…different depending on the upgrade version – upgrade from MySQL 4.1 to 5.0 had a lot of different issues than upgrade from MySQL…
