…’m not sure Florian understood what was meant here. With MySQL Master-Master replication I can add and index on passive node, wait it… 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 not…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… when MySQL appeared on the market many web applications were simple and often not using database at all. MySQL did not have replication… to scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or… and more relay on alternative systems for data storage and management (well Google does it already). I also think the piece…
Post: Webinar: The Hazards of Multi-writing in a Dual-Master Setup
November 5, 2012 By Leave a Comment
…understand the difficulty of managing writes to RDBMS datastores in a high availability environment, especially where asynchronous replication is used (which is almost everywhere). This talk gives an overview and concrete examples of how writing across dual-masters…
Post: Percona is looking for a Perl and Python expert
June 24, 2008 By 6 Comments
… for some open-source tools for MySQL, including but not limited to Maatkit and the Master-Master Replication Manager. This could be full-time or…. You can expect expert guidance and help (especially with the MySQL-specific parts), but a significant amount of freedom and autonomy…
Post: Community Events February-March
January 22, 2010 By 4 Comments
… busy months for Community events. There’s MySQL University, Fosdem, the Seattle MySQL Meetup & Confoo.ca. Here are the details: February… on Multi-Master Replication Manager for MySQL at the MySQL & Friends Dev Room. Besides Piotr’s talk, there will be a number of MySQL enthusiasts…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… consider “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 no… 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 Heartbeat…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…manage replication lag and to understand what is loading your replication it is also helpful to examine execution time of queries being replicated. Unfortunately MySQL…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… (which is hard to manage) or you need to ensure you understand the position on the master to which backup corresponds to… have master or relay binary log corruption. Master or Slave running out of space, Slave crashing (and loosing its position on master), Replication breakage (or running out of sync) due to MySQL bugs or wrong use. Interesting enough…
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… replication, or in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master with LOAD DATA INFILE, which kind of emulates row-based replication in a way. When you…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…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…
