MySQL Cloud Database

MySQL Cloud Database

Our Xeround test… failure and old fashioned solution

With the growth of the amount of beta users and the size of each one, we realized our database infrastructure was not scalable enough. With a growth addition of nearly 3 million extra interactions on the platform, we hit the top. Our servers went out for 10 minutes in January and we had to act fast.

Scaling a  database on the Amazon EC2 platform is a challenge, it’s not like all other cloud services: just pump it online and ‘they will store it’ looking at how we could store billions of new database records every month in a more scalable solutions we found Xeround. This new startup wants to be the database cloud storage in MySQL format. Seems a dream came true: just pump a database over to Xeround and it will automatically scale over multiple EC2 instances.

Our try with the very helpful team of Xeround we got a little more than the normal 500MB beta space and we pumped a 5GB database over to give it a serious try. Growing it with 1GB each week using test-scripts we found it did not yet have the stability we require.

So back to the traditional ‘split them up’ solution and we now implemented a more standard solution of spreading the clients over instances and moving them around based on the volume they need. It seems to be a bit low-tech, but besides Xeround there does not seem any other economically interesting cloud database solution out there.

Our guess is that this infrastructure should get us well underway in 2011 and by the time Xeround irons out the issues we can give that a try again. But if you are looking for a database in the cloud, try them out, it might work for you. Every cloud application is different.

For our beta users… you will not notice anything, and no need to change any scripts or code. The only thing you hopefully have seen is… a faster responding application.

Originally published March 16, 2011 - Updated January 04, 2018
Dennis van der Heijden
Co-founder and CEO of Convert.com, Dennis is a passionate community builder and out of the box thinker. He spends his time innovating to make Convert Experiences better. Learn about his journey as an entrepreneur and leader on the SaaS Club podcast.
Guest Post Form

We have brought thought leaders, influencers, visionaries and veterans to our tribe. Now it’s your turn. If you have something worthwhile to share with a large community of savvy testers, go ahead and pitch your post idea. We’re listening.

EXPLORE OUR POST GUIDELINES

CATEGORIES Blog

[hclightbox id='5' text='Anchor text']