Does MySQL automatically outline?

Question

Now I am dealing with TON (trust me) data that should be available in real time for quick reading and writing to clients. The backend storage system we use is Oracle, but we would like to replace our large, muscular machines with a more compact system.

For various reasons, we cannot use Cassandra, and we are testing (but I'm afraid) MongoDB (it is really young and lacking some critical functions), so I was thinking about recouping a bunch of MySQL instances.

Is there a good system to manage this, or do I need to minimize by myself? I found several projects, but it is not clear to me whether they support adding / removing fragments on the fly.

Answer 1

You can very efficiently implement MySQL database overflows. If your outline is simple, it can be done at your application level, but if it's more complicated, you might want to use a tool. Many options are described on our website here, as well as advanced options that we support.

Learn more about the options here:

http://www.dbshards.com/articles/database-sharding-whitepapers/

It is also important to consider the entire life cycle for a scanned environment, including disaster recovery, active replication, backup, recovery, and re-scalding, as you mentioned above.

FYI , 1000 ( -) . , , ( ).

Answer 2

! , @cisaacson, , , - db. , , , . , ( ). , ... , ( /mysql sharding Wikipedia ). , : , ? ? , , , , .. , , , :)

Answer 3

Sharding-JDBC is a JDBC driver for shard databases and tables. perhaps you can try using it.