mysql - 将不同 mysql 服务器的不同模式链接到一台 mysql 服务器中，以便他可以管理查询

Question

我有 5 个不同的模式，最终我想将它们分成不同的服务器，根据负载进行特定的 RAM 和 CPU 分配。

如何配置才能将不同服务器的模式显示到“前端”mysql 服务器中？

Answer 1

1. MySQL Proxy :

   The MySQL Proxy is an application that communicates over the network using the MySQL network protocol and provides communication between one or more MySQL servers and one or more MySQL clients.

   但是，请注意:

    Warning

   MySQL Proxy is currently an Alpha release and should not be used within production environments.

2. The FEDERATED Storage Engine :

   The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. No data is stored on the local tables.

3. Replication :

   Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).

   但是，请注意:

   In this environment, all writes and updates must take place on the master server. Reads, however, may take place on one or more slaves.