3 ms·
I have been a mysql dba for years; I don't recommend mysql for anything or anyone. Oracle are adding glitter, not polish. If you still really want or need mysq
by mathnode 11y ago
I have been a mysql dba for years; I don't recommend mysql for anything or anyone. Oracle are adding glitter, not polish.
If you still really want or need mysql please do check out mariadb, even old versions like mariadb 5.3 onwards added a lot of features and fixes for old problems from before the Sun acquisition (Remember, MariaDB was forked with the Sun buyout or MySQL AB, not Oracle). It's not entirely a drop in replacement though, read the manual and test your configs!
What MariaDB/MySQL is still really good at, is scaling horizontally pretty quickly, just be sure to separate out different schema workloads into different server instances, and don't make your schema overly complex. Not that it can get too complex anyway with SQL/PSM heh-snort snort.
Want to scale bigger and faster, and maybe with an even more highly tuned dataset per-cluster? Cassandra. Lots of Oracle and IBM business is being slurped up by Cassandra and Datastax.
Want mixed database workloads and all the RDBMS management, SQL and PL goodies? PostgreSQL.
- deleted 11y ago[deleted]
- chris_wot 11y agoI'm genuinely curious - under what circumstances would you recommend MySQL or even MariaDB over PostgreSQL?
- mathnode 11y agoSince Streaming Replication and pg_basebackup was introduced in PostgreSQL; I generally wouldn't. MariaDB 10 and onwards has some fun features though if you are stuck with it. The CONNECT and TokuDB storage engines are very useful and interesting. Parallel, Multi-source, and GTID replication with multiple domains is very easy.