…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: The Math of Automated Failover
September 18, 2012 By 9 Comments
…at systems providing high availability we can identify 2 cases of system breaking down. First is … are very good. When we apply them to MySQL replication we can use these simplified principles – we only…be better choice in a lot of entry level systems and “battle testing” solution before putting it…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
…release comes about 2 years after MySQL 5.5 was released, but MySQL 5.6 contains …with many optimizer and replication features. We’re happy to congratulate MySQL development team at …level issues such as compatibility, porting plugins and other code you might have from previous MySQL versions to MySQL…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… need to do this before April!) Day 2 The Hazards of Multi-writing in …solve. State of the Art for MySQL Multi-Master Replication - (Robert Hodges, Continuent) – Robert is …level overview of PXC/Galera and give some helpful instruction about what some migration strategies might look like. Using MySQL…
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…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…_S1, IP: 192.168.163.206 I also set up MySQL Replication, It’s working fine. This is file Resource Agent which…_mysql ocf:heartbeat:mysql \ params config=”/usr/local/mysql/etc/my.cnf” pid=”/usr/local/mysql/mysqld.pid” socket=”/tmp/mysqld.sock” replication_user=”root” replication…_CHECK_LEVEL=”1″ primitive reader_vip_1 ocf:heartbeat:IPaddr2 \ params ip=”192.168.163.171″ nic=”eth0″ primitive reader_vip_2…
Post: Using MySQL Sandbox with Percona Server
February 16, 2013 By 3 Comments
…# low_level_make_…Replication Sandbox you might need to change –sandbox_base_port option to avoid conflicts if you’re having multiple sandboxes for MySQL…2 starting slave 1 … sandbox server started starting slave 2 … sandbox server started initializing slave 1 initializing slave 2 replication…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… 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…
