Hosting-new.com

Hébergement web, cloud et solutions personnalisées

O'Reilly

O’Reilly Webcast: MySQL Replication – Audit, Test & Verify

by 3 Comments

MySQL replication is fairly easy to set up, but in the real world many obstacles can get in the way of keeping it up and running smoothly. One problem is the slaves getting out of sync with the master. If you’re lucky you’d be alerted with an error in your slave log file, and can then track down that problem. But sometimes it drifts out of sync silently. Both are situations you want to avoid. Sean Hull talks about why this happens, both in terms of things that happen in the application and in MySQL’s implementation of statement-based replication. Then he shares a method to eliminate the problem by testing and verifying your current setup.
Video Rating: 3 / 5

O’Reilly Webcast: MySQL Upgrades With No Downtime

by Leave a Comment

In this webcast we discuss a two-node MySQL multi-master replication setup. We go step-by-step through the process, and then use MMM (MySQL Multi-master Manager) to manage & automate the process exposing a virtual IP address for our application to use. We then show how this architecture supports upgrading MySQL with no downtime for the application.

O’Reilly Webcast: DRBD and MySQL – An HA Match Made In Heaven

by 2 Comments

DRBD has grown in popularity as an excellent low-cost high availability solution for MySQL. It provides synchronous replication of your data without MySQL having to worry too much about the details. Combined with Linux Heartbeat, and you have automatic failover as well. By using this Operating System level replication, you avoid some of the problems of MySQL’s statement based replication, data discrepencies between your nodes, and configuration file complexity. No more failing slave nodes!