Operational Database Management Systems
By Peter Zaitsev Amazon Aurora with MySQL Compatibility comes in three editions which, at the time of writing, have quite a few differences around the features that they support. Make sure you don’t assume...
By Vinicius Grippa | August 7, 2018 | Posted originally here. In this blog post, we’ll discuss how to set a replication from MySQL 8.0 to MySQL 5.7. There are some situations that having this configuration might...
by Avinash Vallarapu | August 6, 2018 | Originally Posted here. Implementation of MVCC (Multi-Version Concurrency Control) in PostgreSQL is different and special when compared with other RDBMS. MVCC in PostgreSQL controls which tuples can be visible to...
By Peter Zaitsev | January 30, 2018 | In this blog post, I’ll look at whether optimizing indexing is always the key to improving MySQL query performance (spoiler, it isn’t). As we look at MySQL query performance, our first...