… a consistent Statement based replication. To accomplish that, row level locking databases also acquire … locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1….mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…has grown to a level where we started looking at other ways of achieving higher availability using MySQL replication. One of the …policy=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults $id=”rsc-options” \ …
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… failure, the level of availability of this solution is affected by the availability of the MySQL replication link between the servers. Replication often break…. A high availability solution based on MMM requires at the 2 MySQL servers configured in a Master to Master topology. Additional slaves…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…subject to debate. These are the usually accepted level of availability for these technologies. 2. Can you afford to lose data? …have the required level of expertise. The required expertise level is summarized in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… easy for MySQL replication to become bottleneck when Master server is not seriously… 5 minutes or other interval of your choice. 2) Use full slow query log and mk-query-digest…list of queries which load replication the most. It however works only with statement level replication. You need to set …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… was born same as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in… is patch out where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like to see… have the problems because they target at least MySQL 5.1 with row level replication readily available. Speaking about community items the following…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
…native API) it is handled on driver level. When you connect to replication set you connect to set of … for large number of applications. In fact using MySQL Replication for failover we’re operating with kind of … develop tools around them. How to check if 2 MongoDB nodes are indeed in sync ? How to …
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an idle…t think it’s general-purpose enough. Solution 2) has potentially complex behavior that might not … level, at a minimum. This behavior is going to have to default to single-threaded as replication…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… consider DRBD which can do storage level replication between directly attached volumes. Now with… double the storage but you get 2 copies of data too and using…MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…plugins instead of patches. 2. Be Scalable I’d like to see MySQL Scaling to large amount of…amount of issues with MyISAM and generally on MySQL level which needs to be taken care of. Many… MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication…
