…Master/Slave Set: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql...[ OK ] Joining fence domain… [ OK ] Starting Pacemaker Cluster Manager: [ OK ] [root@percona2 ~]# /etc/init.d/…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… replication topology. On the top-level master, you leave all filters disabled; on the relay master you add binary log filters; this… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… flipped into service if the active master server has an issue. At Groupon, our standard MySQL database configuration follows this active/passive… virtual IP. In practice, it’s slightly more complicated. To manage this process, we use a tool co-developed with Percona… -q -O – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… instance installed by the package manager, with the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who attended the MySQL webinar!
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… setting up, managing and monitoring PXC. MariaDB Galera Cluster users should fit right in: http://www.percona.com/live/mysql-conference-2013….percona.com/live/mysql-conference-2013/sessions/hazards-multi-writing-dual-master-setup BOF: Galera / Percona XtraDB Cluster for MySQL I also submitted…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
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 102 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: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… a single-mastered data store and why it’s a hard problem to solve. State of the Art for MySQL Multi-Master Replication - (Robert Hodges, Continuent) – Robert is the master in discussing the pros and cons… native language to me, this seems compelling. Managing data and data archiving using MySQL 5.6 new features of Portable Tablespace and…
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: Webinar: The Hazards of Multi-writing in a Dual-Master Setup
November 5, 2012 By Leave a Comment
…-writing in a Dual-Master Setup”. In my experience many people do not understand the difficulty of managing writes to RDBMS datastores… an overview and concrete examples of how writing across dual-masters can and will break your assumptions about ACID compliance, how…
