We help IT Professionals succeed at work.
Get Started

Amazon EC2 MySQL Databse server scalability

Last Modified: 2013-11-11

We are looking for a solution to accomplish rapid (and, if possible, automatic) scalability for a remotely hosted custom forum software solution. Users will come to us and register their forums, which we will host for a fee, as well as lighter free version. We need to be able to scale to allow for large growth potential as forums grow on their own while we continue to recruit new forum startups.

I was instructed to look at Amazons EC2 services as they have scalability options through an API, making them apparently automatic.

My question is how can we setup with Amazon EC2 (assuming this is our best solution) to allow for an ever growing database requirement to be split among various servers and (as seamlessly as possible) scale to fit future growth either automatically or manually.

One proposed solution was to custom code the application around Amazon EC2 to communicate with its API to know when a server is/isn't needed and move forums from one to another as loads change. My concern with this is moving forums too frequently and having issues with write locks, database integrity, and overall chaos of rapidly changing database structures.

What is our best solution to launch this new service fairly small and have the ability to scale our databases?
Watch Question
Database Developer & Administrator
Most Valuable Expert 2011
Top Expert 2012
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE