Wes Modes HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Mar 29, 2012; 18:23
Wes Modes
HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
First, thank you in advance for good solid suggestions you can offer. I suppose someone has already asked this, but perhaps you will view it as a fun challenge to meet my many criteria with your suggested MySQL architecture.
I am working at a University on a high-profile database driven project that we expect to be slammed within the first few months. Since this is a new project and one that we expect to be popular, we don't know what kind of usage to expect, but we want to be prepared. Therefore, we are building in extra capacity.
Our top goals are scalability and high availability, provided we hope through multiple MySQL nodes and VMWare functionality. I've been surprised that there are not more MySQL architects trying to meet these high-level goals using virtualization and shared storage (or at least they do not seem to be writing about it).
I've looked at replication, multi-mastering, DRBD, clustering, partitioning, and sharding.
Here's what we got, and some of our constraints:
* We are concerned that One Big Database instance won't be enough to handle all of the queries, plus it is a single point of failure. Therefore, multiple nodes are desirable.
* With the primary application that will be using the database, writes and reads cannot be split off from each other. This limitation alone, rules out replication, MMM, and a few other solutions.
* We do not expect to be especially write-heavy.
* We have shared storage in the form of an iSCSI SAN. We'd like to leverage the shared storage, if possible.
* We have VMWare HA which already monitors hosts and brings them up within minutes elsewhere if we lose a host. So some of the suggested HA solutions are redundant.
* We expect to have another instance of our system running in the Amazon cloud for the first few months while the traffic is high, so we may take advantage of RDS, though an exact duplicate of our local system will save us development work.
Thanks for any advice you can give.
Wes Modes
-- Wes Modes Systems Designer, Developer, and Administrator University Library ITS University of California, Santa Cruz
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Mar 30
Rick James Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Mar 30, 2012; 11:16
Rick James
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Mar 30
Karen Abgarian Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Mar 30, 2012; 13:30
Karen Abgarian
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Mar 30
shawn green Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Mar 30, 2012; 18:56
shawn green
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 02
Wes Modes Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 02, 2012; 13:05
Wes Modes
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 02
Rick James Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 02, 2012; 14:14
Rick James
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 02
shawn green Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 02, 2012; 17:25
shawn green
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 02
Wes Modes Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 02, 2012; 16:47
Wes Modes
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03
Tim Dunphy Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03, 2012; 04:09
Tim Dunphy
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03
Ian Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03, 2012; 11:04
Ian
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03
Johan De Meersman Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03, 2012; 12:26
Johan De Meersman
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03
Wes Modes Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03, 2012; 11:03
Wes Modes
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03
Wes Modes Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 03, 2012; 17:11
Wes Modes
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 04
Wes Modes Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Apr 04, 2012; 13:08
Wes Modes
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!