homepage Welcome to WebmasterWorld Guest from 54.226.136.179
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Mysql server on Amazon S3 or AWS
dertyfern

10+ Year Member



 
Msg#: 4235517 posted 4:22 am on Nov 27, 2010 (gmt 0)

I've got a dedicated server running about 20 websites that use a single mysql database.

I'd like ax the dedicated server, locate each individual website on to web servers in distinct countries and use Amazon S3 or AWS to host mysql server for query requests by each website.

Is this possible with Amazon?

Thanks in advance.

 

lammert

WebmasterWorld Senior Member lammert us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 4235517 posted 9:44 am on Nov 29, 2010 (gmt 0)

It is possible to rent an Amazon EC2 instance and put a MySQL database on it. But practically that solution is nothing different from a dedicated server you have now already.

The other option is to use the Amazon Relational Database Service which runs MySQL 5.1. This service is still in beta though.

The main problem you will run into are security, because your database now has to be open for requests over the Internet which adds additional vectors for hackers, and latency. Especially with web pages which are built using multiple SQL queries you may see a noticeable slowdown of page generation speed due to the time needed to transfer the SQL requests to the Amazon server and sending the responses back to the web server front-end.

dertyfern

10+ Year Member



 
Msg#: 4235517 posted 1:14 am on Dec 1, 2010 (gmt 0)

Thanks for that lammert. I suppose the best and quickest solution would be to split up the current database tables and host separate instances of mysql for each website.

lammert

WebmasterWorld Senior Member lammert us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 4235517 posted 3:32 am on Dec 1, 2010 (gmt 0)

Amazon EC2 instances are paid per instance per runtime. Having more instances each running one database will cost you more money than having all databases in one instance. You can have multiple databases on one EC2 instance, so from a financial point of view it would be wise to run all databases from one EC2 instance.

I am not sure about the functionality and pricing of Amazon RDS instances. Because it is fully compatible with MySQL 5.1, you should be able to create more than one database in one instance, which is also more cost-effective than having one instance per database.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved