官术网_书友最值得收藏!

Federated

The FEDERATED storage engine allows you to create a single database on multiple physical servers. It opens a client connection to another server and executes queries against a table there, retrieving and sending rows as needed. It was originally marketed as a competitive feature that supported many enterprise-grade proprietary database servers, such as Microsoft SQL Server and Oracle, but that was always a stretch, to say the least. Although it seemed to enable a lot of flexibility and neat tricks, it has proven to be a source of many problems and is disabled by default. However, we can enable it by starting the MySQL Server binary with --federated option.

Let's create a FEDERATED table.

CREATE TABLE user_federated ( 
id INT(20) NOT NULL AUTO_INCREMENT,
name VARCHAR(32) NOT NULL DEFAULT '',
PRIMARY KEY (id),
INDEX name (name))
ENGINE=FEDERATED DEFAULT CHARSET=latin1
CONNECTION='mysql://remote_user:[password]@remote_host:port/federated/table';

The connection field contains information mentioned as follows for your ready reference:

  • remote_user: A username of remote MySQL Server
  • password: A password of remote MySQL Server
  • remote_host: A hostname of the remote server
  • port: Port number of the remote server
  • federated: Remote server database name
  • table: Remote server database table name
主站蜘蛛池模板: 靖边县| 井研县| 锦屏县| 河源市| 怀集县| 宜城市| 贡嘎县| 张家港市| 象山县| 德安县| 南岸区| 宜春市| 富源县| 宜宾市| 茂名市| 城步| 侯马市| 图木舒克市| 五寨县| 裕民县| 建湖县| 洪江市| 九寨沟县| 新田县| 扎鲁特旗| 增城市| 静乐县| 阿图什市| 罗城| 宁强县| 林西县| 璧山县| 永德县| 荥经县| 襄樊市| 石景山区| 屯留县| 瑞丽市| 永靖县| 嘉禾县| 东乡|