Question
MySQL group replication in Ubuntu 16.04
- Posted February 2, 2018
- MySQLConfiguration ManagementHigh AvailabilityUbuntu 16.04
I am trying to create an instance in one AWS region that would be a group replica of an instance in a different region(both are database servers). I followed the digital ocean’s tutorial on how to configure mysql group replication on ubuntu 16.04.
But, when I modify the my.cnf file and restart mysql, I get the following errors in the mysql’s error log: 2018-01-31T12:33:21.855687Z 0 [ERROR] Can’t start server: Bind on TCP/IP port: Cannot assign requested address 2018-01-31T12:33:21.855690Z 0 [ERROR] Do you already have another mysqld server running on port: 3306? 2018-01-31T12:33:21.855699Z 0 [ERROR] Aborting
When I changed the config to the default one and then start mysql, I am able to grep mysql using $sudo netstat -lntp|grep 3306.
Can anyone tell me how I can overcome this issue?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi @nisari,
You could run netstat -lp | grep 3306 to find out what program is already listening on port 3306, then you can stop MySQL which is already running by kill -9 pid and try again with group replication configuration.
Regards, Rajkishore
Try DigitalOcean for free
Click below to sign up and get $100 of credit to try our products over 60 days!
Hi @nisari, what changes did you make in your
my.cnffile?