… has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse…go through, and possibly some poor user experience. batch writes Instead of updating global counters one at a time (from Example 1…
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… overly eager batch job doing updates from 20 threads on the master will create enough updates for a few hours, to make replication lag… taken at the wrong time may be responsible for unexpected MySQL replication lag.
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… you have transaction containing millions of simple updates instead of one large update to help MySQL replication lag it is not going to work… functionality. Finally you should not overload your replication – Quite typically I see replication lagging when batch jobs are running. These can load master…
Post: How expensive is MySQL Replication for the Master
January 16, 2010 By 13 Comments
…generally thought about MySQL replication as being quite low overhead on Master, depending on … was Master was having a lot of very small updates going on – over 15.000 transactions a second. Each… at the time we could make replication threads to be woken up in the batches. For example we could tune…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option …batch_sizeblogpercona.commanual innodb_purge_threadsblogpercona.commanual innodb_read_ahead_thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_replication… unique_checksblogpercona.commanual updatable_views_with_limitblogpercona….
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-… INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also …batch insert is not known as we do not have to allocate sequential auto increment values if row level replication…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… applications which is very update intensive with updates being pretty much random single row updates which are hard to batch. With MySQL/Innodb I got server being able to handle some 30.000 updates/sec on 16 core server with replication being… 4 MySQL instances on this server and get up to 100K updates/sec with up to 40K updates/sec being able to replicate. With…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… like to see semi-realtime update for them so we can’t simply update them nightly using batch job. What to do in… MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive table…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… back to our question of space requirements for MySQL Backups using LVM. As you can see from… IO pattern, say most of traffic comes from batch updates updating pretty much every page in 10GB table you… free space and you would like to setup replication for large database with little no – connect USB…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
So you need to design highly available MySQL powered system… how do you approach that ? Too often I … if you use MySQL Replication for HA) the switch to the new server may not be 100% clean with few updates lost. RAID… 4 core with MySQL). It is best if you just put couple of spare servers in each purchase batch so they are…
