MySQL group replication in Ubuntu 16.04

February 2, 2018 538 views
MySQL Configuration Management High Availability Ubuntu 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?

Be the first one to answer this question.