Results 1 to 5 of 5

Thread: Cloud databases

  1. #1
    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.

  2. #2
    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.

  3. #3
    XCLOUD i don't recommend!

  4. #4
    Join Date
    Jan 2011
    Posts
    296
    Quote Originally Posted by Micky Birger View Post
    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.
    This is good point of view. It will be good to remember this.

  5. #5
    Quote Originally Posted by Micky Birger View Post
    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.
    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

  1. Replies: 0
    Last Post: 04-17-2012, 11:04 AM
  2. Replies: 0
    Last Post: 06-01-2011, 10:20 AM
  3. Replies: 0
    Last Post: 10-19-2010, 01:47 PM
  4. Database by Design, LLC - Private Cloud Configurator - Build Your Own Cloud Today
    By DatabaseByDesignLLC in forum Cloud Hosting Offers
    Replies: 0
    Last Post: 08-10-2010, 02:35 PM
  5. Databases Integration over the Cloud
    By pnorilsk in forum Cloud Hosting Offers
    Replies: 0
    Last Post: 03-07-2010, 01:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •