…to-scale component in your system — don’t waste resources. Another benefit of this is the chance to parallelize. As you know, MySQL…to think about master-master…Replication Building aggregated tables is hard work for the database server. If you do it on the master…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQL…mysql-replication-running checks that replication is functioning correctly. Replicas have different data than their master. In addition to delay or failure, replication…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…to add a separate server, the Manager that, like the name imply, manages the availability of the MySQL…Master-Master replication is presented on the figure below. Apart from the minimum requirement of two MySQL servers replicating…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…how to…to identify rows that have changed Triggers to capture changes synchronously Database log reading to…to process SBR changes from a MySQL master. I’ll talk more about that in another…to add the table to the list of tables to changelog. There is a utility included with FlexCDC called ‘add…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…MySQL Master-Master replication I can add and index on passive node, wait it to catch up and switch the roles (see another…to learn about MySQL Replication or just looking to keep MySQL infrastructure to be as close to one for other databases…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…another “liability” of compex replication tree setup. On the contrary sharded master-master pairs (or master with few slaves) are much easier to…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…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…database so you can ensure your application and staff members really follow these rules. Another option to filter writes on the Master…to add more tables to be replicated to the slaves. Another…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…to a replication…the master….to the database may have happened since the backup was taken. Replaying the binary logs brings the database up-to… CALL flexviews.add…actually another … to refresh: mysql> call flexviews…how you can combine both types of views together. The complete method examples show how to…
