Cloud Database: MySQL vs Amazon SimpleDB
A database in the cloud for your webapp. I see 2 choices:
Pros: Cheaper + full RDBMS
Cons: Not scalable at firstSimpleDB
Pros: Instant scalability
Cons: Not open source (have to stick with amazon web services) + more coding for advanced queries (simpleDB = key-value store) + possible inconsistency ?After this simple analysis sticking with MySQL as the main DB seems a better choice, and maybe later use SimpleDB for certain tasks. Any thoughts ?
- Using Amazon SimpleDB,
- Using MySQL on an Amazon Elastic Block Store (EBS).
Pros: Cheaper + full RDBMS
Cons: Not scalable at firstSimpleDB
Pros: Instant scalability
Cons: Not open source (have to stick with amazon web services) + more coding for advanced queries (simpleDB = key-value store) + possible inconsistency ?After this simple analysis sticking with MySQL as the main DB seems a better choice, and maybe later use SimpleDB for certain tasks. Any thoughts ?
