June 19, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

to anotherto replicate only some tables from master to slave, and if so, how? A: Yes. There are a few of ways toreplication 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

to-scale component in your system — don’t waste resources. Another benefit of this is the chance to parallelize.  As you know, MySQLto think about master-masterReplication 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

to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQLmysql-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

to add a separate server, the Manager that, like the name imply, manages the availability of the MySQLMaster-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

how toto identify rows that have changed Triggers to capture changes synchronously Database log reading toto process SBR changes from a MySQL master. I’ll talk more about that in anotherto 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

MySQL Master-Master replication I can add and index on passive node, wait it to catch up and switch the roles (see anotherto 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

another “liability” of compex replication tree setup. On the contrary sharded master-master pairs (or master with few slaves) are much easier toMaster 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

how we dump schemas: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET toto another server using “mysqlbinlog … –read-from-remote-server –raw –stop-never” Useful to mirror the binlogs on the master to

Post: Filtered MySQL Replication

database so you can ensure your application and staff members really follow these rules. Another option to filter writes on the Masterto add more tables to be replicated to the slaves. Another

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

master or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster databasehow to start up a cluster from scratch (i.e. a standalone XtraDB Cluster machine, convert it to a cluster type, and add nodes to