Is it possible to have a mysql service running in a host x and another mysql service running in a host y and have them to communicate?
Say, I have a proc or trigger running in host x, and need to connect to host y so I can insert some data. Is it possible?
I see wind mills
Joined: Jul 03, 2009
I was looking for something similar to the DBLINK feature present in Oracle.
Did not find it, but instead found something that solved my problem.
It's a storage engine, present in MySQL from version 5, which allows one to insert data in one table locally, and then the data is also inserted into a table on a configured remote mysql Server. It's called FEDERATED.