…slave read traffic from non warmed up slave will often cause warmup to be longer, because it has to happen in the single thread. In…replication lag. Same may happen with operating system and other system software involved. In could be even system which queries mysql…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…in MySQL history when issues would only happen at high load. You can do this in…Slave(s) If you want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…to the point what we’re comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL…to have lost transactions which may happen with async replication. Another similar case is when you’re looking to ensured consistency – MySQL Replication…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…to a level where we started looking at other ways of achieving higher availability using MySQL replication…to MMM If the master fails, a new master is promoted from the slaves, no master to…to the main Pacemaker resource agents branch. More testing and cleaning will be needed before that happen…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 4 Comments
…MySQL Replication when your master goes down it is possible for some writes to be executed on the master, but not on the slave…What is really interesting – it should be possible to apply the same concept to MySQL Replication…to Slave happened and they can be dumped to local file (in case one wants to…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL…. If Active server fails in the pair both …to prevent application mistakes. What will happen if you will write to the slave because of application error ? Well you’ll break replication…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…replication, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL…what‘s happening that I’m still investigating and may write more about later, in this particular case. So what…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…to disk, but it also comes at great danger if MySQL Server crashes or power goes down. In case crash happens…failing to run, wrong result sets or crashes. Here is my list what I think MyISAM tables are good to…to have at least one proper master to fall back to. Also be worried about replication…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
…MySQL Replication Clusters”. It was impressed as I personally always wanted it for InnoDB, but we had it in…happens with whole cluster. – Heterogeneous-database replication. It is not here yet, and I do not know what‘s in…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…slaves people run and how complex replication topologies with multiple tiers filtering and writes to some intermediary slaves…to fail. Unless you’re Google scale with failures happening…MySQL industry practices (which we also covered in a great depth in…
