Reputation: 2041
Is it possible for mysql to create a distributed database ? http://en.wikipedia.org/wiki/Distributed_database
Upvotes: 11
Views: 30586
Reputation: 11
You should had a look at TiDB. It's an open source MySQL compatible NewSQL HTAP database.
https://github.com/pingcap/tidb
Upvotes: 1
Reputation: 973
Sure, it is possible to do this. You can certainly create a distributed (horizontally scaled) database with MySQL and the specific technique(s) used for this are related to parallel databases. To a lesser extent several people implement sharding style solutions that give you some of the benefits of horizontal scalability, but also place some limitations on them.
Upvotes: 0
Reputation: 148
The Clustrix Database is a distributed database built from the ground up to be a MySQL replacement. It has a shared nothing architecture and automatically distributes data and does distributed query evaluation.
Upvotes: 0
Reputation: 180004
Sure. Any large site like WordPress.com couldn't possibly hope to run their entire MySQL database off one server. They use replication and sharding to distribute the database over tens, hundreds, or thousands of servers.
Upvotes: 6