3 ms·
EC2 instance + db instance per customer alone made my jaw drop No, they mention in the article that they were using 30 databases per DB instance. Not sure why
by poxrud 7y ago
EC2 instance + db instance per customer alone made my jaw drop
No, they mention in the article that they were using 30 databases per DB instance. Not sure why they used 30 when the RDS FAQ mentions[1] that for SQL Server you can have up to 100 databases per instance.
However if they would have used another database engine such as MySQL or PostgreSQL, they would not have had any limits to DB's/Schama's per instance and could have had an order of magnitude of cost savings. Using something like AWS Schema Conversion Tool[2] makes it easy to convert between different DB engines, and at a spend of $100K /month they could have easily afforded to pay a consultant to do the migration for them.
[1]https://aws.amazon.com/rds/faqs/ https://aws.amazon.com/rds/faqs/
[2]https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html https://docs.aws.amazon.com/SchemaConversionTool/latest/user...