Birmingham mumbai

[
 344 
]
Another configuration file that we'll need to edit is 
/etc/mysql/mariadb.conf.d/50-
server.cnf
. In this file, we have the following line:
bind-address = 127.0.0.1 
With this default setting, the 
mysql
 daemon is only listening for connections on 
localhost (
127.0.0.1
), which is a problem since we'll need to connect to it from 
another machine (the secondary server). Change this line to the following:
bind-address = 0.0.0.0 
Next, we'll need to access the MariaDB shell on the primary server and execute the 
following commands:
GRANT REPLICATION SLAVE ON *.* to 'replicate'@'192.168.1.204' 
identified by 'password'; 
Here, we're creating a replication user named 
replicate
 and allowing it to connect 
to our primary server from the IP address 
192.168.1.204
. Be sure to change that 
IP to match the IP of your secondary server, but you can also use a hostname 
identifier such as 
%.mydomain
 if you have a domain configured, which is equivalent to 
allowing any hostname that ends with 
.mydomain
. Also, we're setting the password 
for this user to 
password
, so feel free to customize that as well to fit your password 
requirements (be sure to make a note of the password).
We should now restart the 
mariadb
 daemon so that the changes we've made to the 
mysql.cnf
 file take effect:
sudo systemctl restart mariadb 
Next, we'll set up the secondary server. But before we do that, there's a consideration 
to make now that will possibly make the process easier on us. In a production 
environment, it's very possible that data is still being written to the primary server. 
The process of setting up a secondary server is much easier if we don't have to worry 
about the primary database changing while we set up the secondary. The following 
command, when executed within the MariaDB shell, will lock the database and 
prevent additional changes:
FLUSH TABLES WITH READ LOCK;
If you're absolutely sure that no data is going to be written to the 
primary server, you can disregard that step.

---

Chapter 13