• Post Reply Bookmark Topic Watch Topic
  • New Topic

mysql host communication  RSS feed

 
Rodrigo Bossini
Ranch Hand
Posts: 113
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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?

Thanks.
 
Rodrigo Bossini
Ranch Hand
Posts: 113
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36446
454
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Interesting. Thanks for sharing that.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!