Link to home
Start Free TrialLog in
Avatar of mikha
mikhaFlag for United States of America

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?
Avatar of David Favor
David Favor
Flag of United States of America image

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.
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.
Avatar of Phil Phillips
Phil Phillips
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial