…to another…to replicate only some tables from master to slave, and if so, how? A: Yes. There are a few of ways to…replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…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 11 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 26 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: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…how we dump schemas: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: Filtered MySQL Replication
November 7, 2007 By 8 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: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…master or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster database…how to start up a cluster from scratch (i.e. a standalone XtraDB Cluster machine, convert it to a cluster type, and add nodes to…
