Dropping MySQL, evaluating alternative DBs, picking the best for our use case

After reading their experience at https://usefathom.com/blog/viral it is clear to me that they should not change the databse but invest in a deeper competence in mysql.

After all, when they did create the proper indexes and set the proper column types, mysql did perform well.

If anything, I'd enable additional monitoring (eg: Performance Schema in RDS mysql and/or percona monitoring&management) and invest in learning about reading&interpreting such monitoring.

https://github.com/vitessio/vitess