The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of… added in the future. It can manage master-master pair as well as other configurations such as master-master and bunch of slaves. Typically you… misconfigured and things the server is master when it is not ? To take care of this Master Master Manager makes sure only one of…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… MHA for master promotion. The solution is basically made of 3 pieces: The Pacemaker cluster manager A Pacemaker configuration A MySQL resource agent…” nic=”eth0″ \ meta target-role=”Started” ms ms_MySQL p_mysql \ meta master-max=”1″ master-node-max=”1″ clone-max=”3″ clone-node-max=”1″ notify=”true” globally-unique=”false” target-role=”Master…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…’m not sure Florian understood what was meant here. With MySQL Master-Master replication I can add and index on passive node, wait… use to SAN based high availability solutions with active-passive management software. Quite often these guys would have be familiar with… very nice mixed environments with MySQL – for example you can replicate binary logs using DRBD so if master node fails you have…
Post: MySQL Support or Support for MySQL ? MySQL Trademark Policies
October 26, 2007 By 11 Comments
… named “MySQL Support” or “MySQL Consulting” The most well case known with MySQL Trademark enforcement so far is perhaps MySQL Front which MySQL asked to… MySQL in the name – there is MySQL Toolkit, MySQL Master Master Manager, MySQL Slow Log Analyzer and a lot of others. Unless developers have secured permission from MySQL…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… “MySQL replication” and “Master-Master with MMM manager” otherwise, you can only consider the other three solutions. Data 100% safe MySQL replication no Master-Master with MMM manager… the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL DBA + good Sysadmin skills…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication between a master and one or more slaves. Upon failure of the master, one…, manages the availability of the MySQL service. A high availability solution based on MMM requires at the 2 MySQL servers configured in a Master…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… is high enough so Master is almost fully busy handling the writes. This is not the case – because MySQL Replication runs in… to see when you’re close to the limit. To manage replication lag and to understand what is loading your replication… measure replication lag – MySQL Toolkit has a great tool for real latency measurement. Do not trust Seconds_Behind_Master too much, even…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you need. Because I’ve built two such systems to manage online ads through Google Adwords, Yahoo, MSN and others, it… caused by ALTER TABLE — a typical reason to think about master-master with failover and failback for maintenance. As with anything, it… in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master with…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent… time? PZ: Indeed using master-master setup and switching roles is a good way to get large data manageable. MySQL Master Master Manager can help you to…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… indexes, changing data type, converting data to different character set – MySQL master-master replication especially accompanied by MMM can be very handy to… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication manager (MMM) ever…
