Avatar of mikha
mikha
Flag 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?
InstallationAWS

Avatar of undefined
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.

InnoDB - read heavy or read/write balanced.

MyRocks - write heavy.
ASKER CERTIFIED SOLUTION
Phil Phillips

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes