I recently presented a webcast hosted by O’Reilly and Webex. In it I take you on a step-by-step installation of DRBD and MySQL. I start by using Sun’s Virtualbox to create to virtual machines running CentOS. I then explain how to configure them with virtual external drives to use for DRBD. I next configure the network interfaces to support routed packets into and out of the boxes. Then I install various packages with yum, configure drbd and finally install MySQL as the last step. You can follow along at the command line and do it yourself on a Windows, Mac or Linux box.
Archive for February, 2010
DBJ – Heartbeat Setup
Feb 12
In the last of our three part series on MySQL high availability we discuss the Linux Heartbeat project, and how it can be used to automate failover between two MySQL databases.
Heartbeat exposes a virtual IP address for use by the database, and manages it as well. In the event that one server becomes unavailable, Heartbeat will revoke primary control of DRBD from that node, hand over the IP address to the alternate node, mount the DRBD device, and start MySQL. MySQL’s InnoDB engine will then perform crash recovery, rollback uncommitted transactions, and startup.
Read the full article at Database Journal – DRBD & MySQL, Heartbeat Setup
Our 64th newsletter issue is just out. In it we discuss different perspectives, and how they shape what we value as important. Understanding how each person, each client, each party at the table sees things, and values things differently is the first step in being able to deliver and speak directly to their needs.