mikha
asked on
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?
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
2) Neither Aurora or any other scaling tech will allow MariaDB/MySQL to reach highest throughput.