Web Hosting Talk : Web Hosting Main Forums : Cloud Hosting : mysql on Rackspace cloud

[crazylane]

I've been looking at off-loading mysql to Rackspace's Cloud Servers for a couple of servers. Anyone doing the same?

[cristibighea]

This begs the question: why?

[plumsauce]

Even more so, how?

Putting a db on a cloud would be a truly scary undertaking.

[EngineNetworks]

It could be a little bit tricky...
I suppose you have a remote webserver that need to quering this DB server. So it will connect through public internet and it could be better to encrypt this traffic.
Another problems you could be the latency from the web servers and the DB servers.

But all this possible problems is not about Cloud but every solution (Dedicated, VPS, Cloud, etc) where you have web server and db server away each others.

[crazylane]

Rackspace Cloud servers you run just about whatever you want. I want to some relief for some very busy servers, mostly e-commerce sites. I would be able add or remove resources as needed and replication would be a snap.

[crazylane]

We are using Amazon's RDS right now and it works great, however I would like more control of MySQL.

[ckeck]

We actually have many customers who do this on the Cloud Servers platform and it works very well. It gives you a flexible location to run your database servers that can scale up/down as necessary and setting up replication in a cinch or even fail-over.

One thing to keep in mind as someone else already mentioned is latency that will be introduced if your web/app servers are not on the Rackspace network. This is still fine for many use cases, but others where you need high performance between your web/app servers and the database it may not be a replacement for your existing DB server, but maybe a good DR solution. However, if you have dedicated servers at Rackspace or an app on Cloud Sites and you need more control over MySQL, this is an excellent option that hundreds if not thousands of customers already take advantage of.

-Chad

[coolvserver]

If you do it for DR, it is a great idea. You will be happy with the results. However, if you use it as the live database serving, you will feel slowness due to the network latency.