June 19, 2013

Post: How does MySQL Replication really work?

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

to know about partial replication – you can do filtering on the Master or on the Slave. Filtering on the Slave isMySQL Replication there are things to be careful with, so if you’re considering to

Post: Infinite Replication Loop

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

If you want to maintain the consistency of your data is necessary to define the same Triggers in Master and Slave servers. Example: mysqlto 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

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

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

replication? Can you use the system to set up new MySQL replication slaves? How? Does the system verify that the backup isis 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

how can you tell when your slave is nearing its capacity toIf you have Cacti (and these Cacti templates for MySQL) you can see this in the graphs. If the graphs start toreplication 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

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 isto know right now is

Post: High-Performance Click Analysis with MySQL

… 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…