Lenz Grimmer presents at the 2009 OpenSQLCamp Europe, in conjunction with FrOSCon 2009. From the official conference description at programm.froscon.org Best practices and commonly used HA setups for MySQL There are many ways to ensure the availability of a MySQL Server and how to provide redundancy and fault-tolerance. In this talk, Lenz will give an overview over some best practices and commonly used HA setups for MySQL. The talk will cover the commonly used Open Source components and tools, with a focus on Linux and OpenSolaris. The session will also cover MySQL Cluster, the architecture and relationship to the MySQL Server. MySQL is a popular open source relational database system (RDBMS) and widely used as the storage backend for dynamic web sites and applications. In many areas it has become a mission-critical component of the software stack, where downtime is not an option. This talk will give an overview about different solutions and technologies available to make a MySQL Server system highly available. The session will start with a brief introduction to High Availability (HA), the terminology and general concepts involved. Afterwards, several MySQL HA solutions will be introduced and explained, eg replication (and possible topologies), Linux-Heartbeat, block device replication (DRBD), Shared storage/SAN, MySQL Cluster, MySQL Proxy, Sun Open HA Cluster and Red Hat Cluster Suite.

Popularity: 4% [?]

You may also be interested in...
FOSDEM 2009 mysql High Availability Solutions
High Performance MySQL: Optimization, Backups, Replication, and More
Building Bioinformatics Solutions: with Perl, R and MySQL
PHP Solutions: Dynamic Web Design Made Easy
MySQL Administrator's Bible
PHP & MySQL For Dummies 3rd edition

This entry was posted on Saturday, July 24th, 2010 at 7:11 am and is filed under Videos. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.