Question

Anyone make use of ClearDB or other cloud based mysql?

Posted February 19, 2013 5.5k views
I'm interested in leveraging cleardb for back-end mysql service together with DigitalOcean droplets (webservers) - anyone have experience with this or other PAAS provider of mysql?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
3 answers
Haven't heard of anyone outsourcing the DB layer the first question would be why, is it for convenience, performance etc.?

Also you would want to make sure that the latency between where your DB is hosted and your webservers is relatively low otherwise every request you make is going to traverse the latency and cause slower page loads for your end users.
I've heard of, but not used ClearDB. The benefits are management, redundancy, and replication. If you can manage your own cluster, you won't benefit as much as someone who would prefer or needs someone else to do it for them. The cost is pretty hefty if you have a sizeable database, but then again, if your database is 5-50GB in size, you may prefer to have someone manage it for you as you'd be spending a little time tweaking and tuning MySQL for that type of growth.
Aside from managing backups you would gain significat cost savings and performance advantages from running your DB from a separate virtual server.

A 4GB virtual server which costs $40/mo will easily handle 200+ queries per second and 100 connections and overall performance will depend on your specific queries and optimization.

Running your own server you can also dig into any performance issues or install analytics monitoring like NewRelic which can dig into your application and show you which queries are running slow.
Submit an Answer