Is it possible for mysql to create a distributed database?
Is it possible for mysql to create a distributed database ? http://en.wikipedia.org/wi开发者_如何学Cki/Distributed_database
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.
Depends on your definition, but MySQL Cluster may fit your need.
You should had a look at TiDB. It's an open source MySQL compatible NewSQL HTAP database.
https://github.com/pingcap/tidb
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.
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.
精彩评论