Bug #31182 Can you provide interface for server_id of thread for multiple master replicatio
Submitted: 25 Sep 2007 9:35 Modified: 26 Sep 2007 1:50
Reporter: chun li Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S4 (Feature request)
Version:5.1.20 OS:Linux (redhat linux)
Assigned to: CPU Architecture:Any
Tags: multi-master, replication, research, server_id

[25 Sep 2007 9:35] chun li
Description:
We are researching the database replication of MySQL 5.1.20 and plan to build a multiple master replication tools because we can not find any plan of the multiple master replications in the 5.1 roadmap.

We are now confronted with a problem that we can not simulate the SQL thread of replication because we can not changed the server_id of the thread. So when we issuing a query which was get from relay log, it will store in the binlog of MySQL server with the server_id of local MySQL server but not the server_id of original site. I am asking if you can provide the interface to get and set the value of server_id in the thread. I will be very thankful if you can provide this. Thanks. Can you tell me if there is any plan to build multiple master replication and conflict resolution in the future of MySQL server release?

How to repeat:
n

Suggested fix:
n
[25 Sep 2007 11:31] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of Bug #27845
[26 Sep 2007 1:50] chun li
ok, Thanks, I will follow that bug.