Posts

Showing posts from October, 2019

Database Week at the AWS Loft

Image
Here are my notes:https://databaseweekoctober2019sf.splashthat.comDatabases on AWS: The Right Tool for the Right JobI'm not taking super deep notes for many of these talks. I'm focusing on the highlights.PostgreSQL came after MySQL.8 categories of DBs on AWS:RelationalKey valueDocumentIn-memoryGraphSearchTime seriesLedgerSearch for: AWS Database ServicesFor relational, they have Amazon Aurora. It's compatible with MySQL and PostgreSQL. It has 5x throughput compared to MySQL (on RDS) and 3x compared to PostgreSQL (on RDS). It can scale out to 15 read replicas. It's fault tolerant and self-healing. It keeps 6 copies of the data across three AZs. It can provide continuous backup to S3. It has encryption at rest and in transit. It's fully managed by Amazon. They support cross region (unclear) and multimaster.Amazon.com itself uses Aurora at least for some stuff.There's a database migration service.They also support other DBs such as SQL Server using RDS.Next, she c…