Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql host communication

 
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
Marshal
Posts: 34839
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Interesting. Thanks for sharing that.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic