MySQL Architecture Options

Comparing Redundancy, Speed, Reliability, and More

MySQL Architecture OptionsHow do I select which MySQL Architecture option is right for me?

There are several common architecture configurations for MySQL that need to be evaluated when determining which one is right for you and your business. In this presentation, presenter Charleste King will discuss what the concerns and pain points are for databases, and MySQL in particular. Comparing and contrasting the most common architectures for redundancy, speed, reliability, and problem areas allows us to make a more educated choice. Replication with Master/Slave and Master/Master will be compared to stand-alone and two types of cluster environment. Pros and cons of each will be discussed as well, providing a great starting point to assist in selecting the best option for you.

Featured Speaker: Charleste King, Lead MySQL DBA, Datavail

Show Transcript

Below is a preview of the webinar transcript.

There’s a number of different storage types in MySQL, specifically. We have MyISAM, InnoDB, memory, NDB, CSV and XtraDB are the most common. There’s a few others that I’m not going to talk about today including things like Blackhole, which are really handy to use during certain types of usages that you might have. For example, a Blackhole engine is useful like if you’re going to, say, upgrade from an old MySQL 5.0 instance to 5.6. And you want to use replication because you want to have minimal downtime then you can use Blackhole engine just to be able to write the binary logs and to do your data chain replication so that you’re not having to pay for all that storage for the 5.1 or 5.5 instances and then you can have your replication and be able to use it without too much cost. But we’re not going to discuss that today because these are the most common. XtraDB is actually used with Percona as with Galera specifically. But the others — MyISAM, InnoDB, Memory, NDB, CSV — come from the MySQL, which is now by Oracle from that camp.

Fill out the form to the right to watch the webinar in its entirety. >>