Home > Programming, Servers & Scripts >

Hosting small Mysql Database in the cloud. Advice please. (8)

02-03-2015 03:58 AM #1 weebay (Member)
Hosting small Mysql Database in the cloud. Advice please.

HI,

I have 3 small MYSQL databases (the biggest is currently 15MB) which I need lightening fast access to from Thailand.

I currently host them on a server in Bangkok but we get a lot of connection issues. I am thinking it is probably just a crappy hosting company. There don't seem to be any obviously better ones however.

So I am looking to host these DB somewhere else and hosting in the cloud seemed the obvious choice.

I thought only static pages could be hosted in the cloud but when I searched, the likes of rackspace are offering Mysql hosting but it seems to be aimed at mega-corporations. I am a total dunce at this type of thing and dont really know where to start or what questions I should be asking.

So basically my question.

Is there affordable ($100 or less per month) hosting options for small MySQl databases in the cloud? And if yes is this the best option for me to host my 3 Mysql databases?

02-03-2015 04:12 AM #2 weebay (Member)

UPDATE

Ive just been offered (not on here) space on a rock solid server based in Bangkok.

Is this a better option that Cloud? We only need access from Thailand so I am thinking YES/

02-03-2015 04:33 AM #3 angry old lady (Member)

hmm not too sure.

but I decided to see who HMA uses for their server in Bangkok

http://www.servenet.co.th/vps.php

02-03-2015 12:18 PM #4 caurmen (Administrator)

Cloud-based MySQL hosting (by which I mean the enterprise-level solutions from the big guys - Amazon, Google, et al) is a pretty complex area, or was the last time I looked into it. Very powerful if you can master it, but running MySQL on a single server is likely to be easy to optimise.

From what you say, I'd go for the rock-solid server in Thailand like a shot.

02-03-2015 04:12 PM #5 Mr Baffoe (Veteran Member)

Amazons RDS is very, very easy to setup and use. IMHO: It's easier to manage an RDS mysql database than a mysql db on a stand alone server.

They take care of backups, async replication, automatic failover, software upgrades and scaling when you need more space.

They have a location in Singapore, which is not as close as having it right in Bangkok so that may be a deal breaker.

02-04-2015 07:16 AM #6 weebay (Member)

I am trying a new server in BKK now. Thanks for the replys..

02-04-2015 08:25 AM #7 natedl98 (Member)

Originally Posted by Mr Baffoe

My experience with Amazon RDS was not good. I'm a developer on a project right now and we're partnering with a very large US university system, so we got access to their personal Amazon consultants (Amazon gives personal tech support staff to big accounts). Even with these experts, we still ran into very basic latency issues, and they could never figure out the issue. The backups did work great, but their platform is just so unlike anything else that the learning curve won't be worth it for most people. They seem to have a bunch of common errors that go unsolved on their message boards, and in the end we had to switch to an in-house server because there were simply too many issues with Amazon that, despite personal tech support, we couldn't solve in a timely enough manner to continue. My advice is stay away from them.

So I would say go with the Bangkok server

02-04-2015 03:02 PM #8 caurmen (Administrator)

@MrBaffoe - interesting! Have the latency issues that natedl98 mentions been a problem for you with RDS, or did it Just Work?

I must admit, I haven't messed with cloud-based databases for a little while - must check out the latest improvements at some point soon.

Home > Programming, Servers & Scripts >