Results 1 to 5 of 5
Thread: Cloud databases
-
06-22-2012, 10:19 AM #1Web Hosting Master
- Join Date
- Mar 2009
- Location
- Austin, TX
- Posts
- 935
Cloud databases
Anyone got good experience with providers? Looking at like Amazon RDS type level stuff.
Performance is primary concern. Right now standalone relational DB performance is constrained by joint statements.
Looking for suggestions. Thanks!SysAdmin.xyz
Having severs with customer data on it without proper monitoring is like having one night stand without using protections - eventually, there will be an 'oh s**t!' moment.
-
07-09-2012, 05:44 AM #2Newbie
- Join Date
- Jul 2012
- Posts
- 27
The performance of a cloud database will depend on a few things. A big factor is whether you use synchronous replication or not - in Amazon RDS and EnterpriseDB (PostgreSQL) this is optional, Xeround which is another MySQL service has sync-replication turned on by default. But keep in mind that sync-replication is the best way to ensure high availability. Beyond that it will depend on the type of queries and use case, type of data, size of blobs. Basically you need to try it out and see, some of the vendors provide a free package or a limited time trial so you can upload a database and give it a try.
-
07-19-2012, 12:39 PM #3New Member
- Join Date
- Jul 2012
- Posts
- 3
XCLOUD i don't recommend!
-
07-20-2012, 11:50 PM #4Web Hosting Guru
- Join Date
- Jan 2011
- Posts
- 296
-
08-01-2012, 06:41 PM #5Newbie
- Join Date
- Aug 2012
- Posts
- 6
I would also add that taking replication aside, main performance limitation is speed of disk/storage in terms of avaible IOPS.
If database is small enough to be in RAM, then you still have problem with WRITE IOPS, but reads are then dependend only on processor speed.
Of course, SQL optimization can help more then changing infrastructure....
Similar Threads
-
HIVELOCITY- ICE Cloud (Independent Cloud Environment) @ $459! Cloud VMs @ $59!
By hivelocitygm in forum Cloud Hosting OffersReplies: 0Last Post: 04-17-2012, 11:04 AM -
HIVELOCITY SIMPLY SCALABLE CLOUD- Public Cloud @ $59. Managed Private Cloud @ $599
By hivelocitygm in forum Cloud Hosting OffersReplies: 0Last Post: 06-01-2011, 10:20 AM -
Cloud Web - CLOUD cPanel Reseller Hosting, 99.99% Uptime Guarantee, WHMCS | 25% OFF!
By JasonD10 in forum Reseller Hosting OffersReplies: 0Last Post: 10-19-2010, 01:47 PM -
Database by Design, LLC - Private Cloud Configurator - Build Your Own Cloud Today
By DatabaseByDesignLLC in forum Cloud Hosting OffersReplies: 0Last Post: 08-10-2010, 02:35 PM -
Databases Integration over the Cloud
By pnorilsk in forum Cloud Hosting OffersReplies: 0Last Post: 03-07-2010, 01:38 PM