# server\_id force to be "1" in all nodes

**URL:** <https://forums.percona.com/t/server-id-force-to-be-1-in-all-nodes/5796>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [August 8, 2017, 4:48am UTC](https://forums.percona.com/t/server-id-force-to-be-1-in-all-nodes/5796 "2017-08-08T04:48:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![y-taka](https://avatars.discourse-cdn.com/v4/letter/y/5daacb/32.png) [@y-taka](https://forums.percona.com/u/y-taka)\
**Post date:** [August 8, 2017, 4:48am UTC](https://forums.percona.com/t/server-id-force-to-be-1-in-all-nodes/5796/1 "2017-08-08T04:48:37Z")

</div>

I created PXC 3 nodes environment by official Docker image of Percona XtraDB Cluster 5.7.

I add “server\_id” parameter in my.cnf of each node, as below :

node1 : server\_id = 10  
node2 : server\_id = 20  
node3 : server\_id = 30

However, after starting all nodes, it seems “server\_id = 1”.

# mysql -u root -ppassword -h 127.0.0.1 -P 13306 -e “show global variables like ‘server\_id’”

mysql: [Warning] Using a password on the command line interface can be insecure.  
±--------------±------+  
| Variable\_name | Value |  
±--------------±------+  
| server\_id | 1 |  
±--------------±------+

[https://www.percona.com/blog/2015/07/16/bypassing-sst-pxc-binary-logs/](https://www.percona.com/blog/2015/07/16/bypassing-sst-pxc-binary-logs/)

According to above blog post, the same server-id is recommended.  
This behavior is the specification or not ?

---

<div class="post-metadata">

**Author:** ![krunalbauskar](https://avatars.discourse-cdn.com/v4/letter/k/439d5e/32.png) [@krunalbauskar](https://forums.percona.com/u/krunalbauskar)\
**Post date:** [August 11, 2017, 4:18am UTC](https://forums.percona.com/t/server-id-force-to-be-1-in-all-nodes/5796/2 "2017-08-11T04:18:49Z")

</div>

This is bit strange. I tried the same at my end with some random server\_id but I see the assigned server\_id.

./bin/mysql --user root -S -e “select @@server\_id”  
±------------+  
| @@server\_id |  
±------------+  
| 433 |  
±------------+

±----------------+  
| @@version |  
±----------------+  
| 5.7.17-13-29.20 |  
±----------------+

---

<div class="post-metadata">

**Author:** ![y-taka](https://avatars.discourse-cdn.com/v4/letter/y/5daacb/32.png) [@y-taka](https://forums.percona.com/u/y-taka)\
**Post date:** [September 5, 2017, 8:27pm UTC](https://forums.percona.com/t/server-id-force-to-be-1-in-all-nodes/5796/3 "2017-09-05T20:27:05Z")

</div>

Hi krunalbauskar,

Sorry for my late. I’m appreciate your test.  
It seems to be problem in only my environment.

So I’ll survey more, thanks.