Ubuntu 15.10上實作

檢查狀態先

進入mysql

輸入show engines ;

    mysql> show engines ;

    
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

    | Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |

    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

    | CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
    | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
    | MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
    | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
    | FEDERATED          | YES     | Federated MySQL storage engine                                 | NO           | NO   | NO         |
    | ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
    | InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
    
    +--------------------+---------+----------------------------------------------------------------+--------------+------+——————+

若沒有。則修改my.cnf,有的話就走table的步驟

先將client mysql server 新增federated

vim /etc/mysql/my.cnf

最後一行加入

    [mysqld]
    federated

Restart mysql

將已存在的table匯出欄位

並修改後面的值

ENGINE 改為 FEDERATED

並且新增

CONNECTION='mysql://user:passwd@host:3306/db/table';

再匯入,若通過驗證,即可同步