We help IT Professionals succeed at work.

developing with amazon aurora serverless

mikha
mikha asked
on
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?
Comment
Watch Question

David FavorFractional CTO
Distinguished Expert 2019

Commented:
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 FavorFractional CTO
Distinguished Expert 2019

Commented:
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.
Senior Platform Engineer
Commented:
You can use MySQL locally for development.