Jul 20
Posted by Sean Hull in databasejournal, high availability, mysql | No Comments
Multi-master MySQL, with the MMM management software brings a whole host of new features, and manageability to your MySQL deployments. Run backups, alter tables, perform upgrades all without slowing down your production users.
Read more at Database Journal – Using Multi-master MySQL To Get A Leg Up On Database Performance
Tags: deployments, high availability, manageability, multi-master mysql, mysql, performance, uptime
Jul 9
Posted by Sean Hull in databasejournal, high availability, mysql | No Comments
This month on Database Journal we talk about multi-master MySQL using circular replication to achieve high availability.
Read more at DatabaseJournal – Intro to Multi-Master MySQL
Tags: high availability, MMM, multi-master mysql
May 18
Posted by Sean Hull in databasejournal, mysql | No Comments
Apr 8
Posted by Sean Hull in databasejournal, mysql | No Comments
In our March DBJ article we talked about some of the storage engines to choose from with MySQL. With it’s plugin storage engine architecture, you have a range of options. In our April article we continue to discuss a further selection of storage engines, and what features they offer to the DBA and database architect.
Database Journal – Exotic Storage Engines
Tags: blackhole, mariadb, pbxt, storage engines, xtradb
Mar 11
Posted by Sean Hull in databasejournal, mysql | No Comments
In this month’s Database Journal piece we look at the spectrum of MySQL storage engines available, and examine what some of their strengths and weaknesses are.
View the article here: Survey of MySQL Storage Engines
Tags: storage engines
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.
Tags: drbd, high availability, mysql, oreilly, virtualbox, webcast
Feb 12
Posted by Sean Hull in databasejournal, high availability, mysql | No Comments
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
Jan 4
Posted by Sean Hull in databasejournal, high availability, mysql, open-source | 2 Comments
In part two of our article on DRBD and High Availability, we take you step-by-step through setting up Sun’s Virtualbox software, creating a couple of VMs, and then installing CentOS on those. These two virtual Linux boxes then serve as two nodes in our DRBD mirrored disk setup which we use as a platform to install MySQL.
DRBD, MySQL and the Virtualbox Setup – Database Journal
Keep on the lookout for our third part in the series next month. In that issue we’ll explain how the Linux Heartbeat project can be used to control the whole setup, and provide automatic failover in the event that one node goes down.
Dec 11
Posted by Sean Hull in databasejournal, high availability, mysql | No Comments
With all the trouble keeping MySQLs built-in replication running, some folks are looking for alternatives. DRBD provides a distributed block level device, which can provide the sort of database mirroring we need, below the filesystem. That makes it transparent to MySQL, but nevertheless a great complimentary solution. In this article we’ll discuss the pros and cons, and then part two will take you step by step through a basic setup.
Read the article on Database Journal – DRBD and MySQL – Excellent Low-cost HA Solution
I’ve teamed up with O’Reilly once again to do another webcast this coming January. In it, I’ll provide a step-by-step live tutorial of setting up DRBD with MySQL on a couple of virtual servers. After the live demo there will be time for Q&A as well, so hope you all can tune in.
You are currently browsing the archives for the mysql category.
Arclite theme by digitalnature | powered by WordPress