Reply to thread

Postgres isn’t bad, but there are storage engines in MySQL that make Postgres look like an Excel spreadsheet.  I use ndbcluster storage engine exclusively these days and allows all sorts of interesting things… fault tolerance without slaves (every node is fully write capable), ability to take down nodes or servers with zero downtime for users, backups without any locks, 10M SQL writes per second (while also doing 50M SQL reads).  The bottleneck becomes your network connection and how many SQL queries you can push down your network connection (I run server interconnects with 54Gbit Infiniband just for that).


My point is that MySQL already has support for something that is next-level over MyISAM/InnoDB or Postgres.


It was originally designed for call logging in phone companies where a single second of downtime was not an option (even for planned upgrades).


[URL unfurl="true"]https://www.mysql.com/products/cluster/[/URL]


Back
Top Bottom