MySQL group replication in Ubuntu 16.04

Posted February 2, 2018 2.4k views
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?

1 comment

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.

Submit an Answer
1 answer

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.