I mentioned CitusDB for PostGreSQL. Could mention Galera for MySQL.
Basically, SQL cannot work on distributed systems. It breaks transactions, joins and a tons of stuff.
These solutions that tries to plug sharding on top of SQL are a big hack. They usually end up with the database underneath barely recognizable and half of the SQL and features dropped. Not to mention they take a lot of dirty engineering and exploratory work to get working.
If what you want is multi-master, use a database that is intended to do that out of the box. The most common being Cassandra. At least, it’s clear on it’s capabilities, you can get help from the official documentation and the internet and there is expertise available.
The HFT Guy 
And what about Galera Cluster or any other project to bring multi-master on SQL databases?
LikeLike
I mentioned CitusDB for PostGreSQL. Could mention Galera for MySQL.
Basically, SQL cannot work on distributed systems. It breaks transactions, joins and a tons of stuff.
These solutions that tries to plug sharding on top of SQL are a big hack. They usually end up with the database underneath barely recognizable and half of the SQL and features dropped. Not to mention they take a lot of dirty engineering and exploratory work to get working.
If what you want is multi-master, use a database that is intended to do that out of the box. The most common being Cassandra. At least, it’s clear on it’s capabilities, you can get help from the official documentation and the internet and there is expertise available.
LikeLike