MySQL group replication in Ubuntu 16.04

Posted February 2, 2018 2.3k 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
Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!