…MySQL replication, but my main focus will be the logistics – how replication events are written on the master, how they are transferred to the replication slave and then how…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…to know about partial replication – you can do filtering on the Master or on the Slave. Filtering on the Slave is…MySQL Replication there are things to be careful with, so if you’re considering to…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…MySQL Replication. To explain what they are, how to identify them… and how to fix them. An infinite replication loop is one or more transactions that are replicating…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… If you want to maintain the consistency of your data is necessary to define the same Triggers in Master and Slave servers. Example: mysql… to take in account when we are working with statement based replication. Knowing in advances how MySQL works internally can help us to improve our replication…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
…Slave_received_heartbeats | 1476 | +—————————+——-+ Conclusion If you need to know when exactly the connection between your Master/Slaves breaks then replication‘s heartbeat is…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave… tool do and how it works ? Currently it is implemented based on …know if slave server reboots (say power goes down) you can’t be sure about data consistency because replication…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…replication? Can you use the system to set up new MySQL replication slaves? How? Does the system verify that the backup is…is unacceptable. MySQL backups are complex and difficult to get right. It is very application-dependent and technology-dependent. Unless I know exactly how it works…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…how can you tell when your slave is nearing its capacity to…If you have Cacti (and these Cacti templates for MySQL) you can see this in the graphs. If the graphs start to…replication threads on the slave) to see how much of the time the slave thread was actively processing statements. If the slave…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…is sometimes called drift. This is conceptually similar to a replication slave that is behind. Until it catches up, the view of the data on the slave is…to know right now is…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… your ability to measure the ad’s value? Is it enough to know how many times the ad was clicked each day? If so… to the slaves and it’ll be hard work there too, assuming you use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a slave, then…
