developing with amazon aurora serverless
I plan to use Amazon Aurora Serverless (MySQL-compatible ) , but to build locally can I install mysql locally or we have to connect to the aws right from the start?
1) Build your site/app using the tech you'll be using, so in this case Aurora.
2) Neither Aurora or any other scaling tech will allow MariaDB/MySQL to reach highest throughput.
2) Neither Aurora or any other scaling tech will allow MariaDB/MySQL to reach highest throughput.
To have MariaDB/MySQL reach it's highest throughput...
1) Start with a dedicated server, to avoid performance drain of VM based systems like AWS.
2) To be safe start with 64G-128G of memory.
3) Run site/application.
4) Run mysqltuner every day, adding in suggested tunings, will no suggestions emit.
5) Repeat #4 every week, then every month, continually adding any tunings required.
6) Choose a storage engine based on your data access pattern.
InnoDB - read heavy or read/write balanced.
MyRocks - write heavy.
1) Start with a dedicated server, to avoid performance drain of VM based systems like AWS.
2) To be safe start with 64G-128G of memory.
3) Run site/application.
4) Run mysqltuner every day, adding in suggested tunings, will no suggestions emit.
5) Repeat #4 every week, then every month, continually adding any tunings required.
6) Choose a storage engine based on your data access pattern.
InnoDB - read heavy or read/write balanced.
MyRocks - write heavy.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial