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?
InstallationAWS
Last Comment
Phil Phillips
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
2) Neither Aurora or any other scaling tech will allow MariaDB/MySQL to reach highest throughput.