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
8/22/2022 - Mon
David Favor
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.
David Favor
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.
2) Neither Aurora or any other scaling tech will allow MariaDB/MySQL to reach highest throughput.