Topic: Requests from one DB (one server) to a DB (other server)

Good afternoon!
Prompt, whether probably to do  of one DB (one server) to a DB (other server) and how?


Re: Requests from one DB (one server) to a DB (other server)

https://dev.mysql.com/doc/refman/5.7/en … ngine.html


Re: Requests from one DB (one server) to a DB (other server)

Yes, it turned out, thanks, a first-class thing.
If to whom it is useful, I will short describe as it becomes
1) Action the first, whether we check Federated Storage Engine unit through command line is installed
(We are connected to mysql through command line, in this case)

mysql> show engines;

Should there will be a type table:
(We Look, whether is in this table FEDERATED if is not present, we pass to following action)

| Engine | Support | Comment |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | DISABLED | Supports transactions and page-level locking |
| BLACKHOLE | NO |/dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | NO | Archive storage engine |
| CSV | NO | CSV storage engine |
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |

2) we Install Federated Storage Engine unit

mysql> install plugin federated soname ' ha_federated.so ';

3) Further again we execute a command

mysql> show engines;

Also we look, should there will be record FEDERATED | NO, if NO it is necessary for us to launch it.
4) It is launched FEDERATED, by file editing my.cnf (my.ini)
Ways can be different depending on the version mysql and OS:
We add record federated in the unit [mysqld]


5) It is necessary to restart mysql

# /etc/init.d/mysqld restart

6) if at restarting the error, and mysql not  got out

Warning: World-writable config file '/etc/my.cnf ' is ignored

That is necessary for checking up through properties of a file my.cnf or a command

ls-la mysql.cnf

Resolutions on record/reading
It should be correct: - rw-r - - r -
7) if mysql it was successfully restarted, we execute a command show engines; also should be
Further create FEDERATED tables and enjoy.
How to create, it is possible to esteem here:
https://dev.mysql.com/doc/refman/5.7/en … ction.html