A set of trivial replication scripts
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Martins Eglitis 0481e95247 Added some more comments 2 months ago
README.md Added some more comments 2 months ago
change.sh Updated readme and change script 1 year ago
input.sh Initial commit 1 year ago
variables.env Whoops, forgot the variables.env 1 year ago

README.md

replication

A set of trivial scripts for mariadb replacation.

Setup

Edit the my.cnf file (or included files such as my.cnf.d/server.cnf) and edit the following lines

...
[mariadb]

# replication Master Server (default)
# binary logging is required for replication
log-bin = mysql-bin

# binary logging format - mixed recommended
binlog_format = mixed

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

# set to the local IP of the physical NIC
# e.g. 192.168.1.2 if only one bind address is required
# use 0.0.0.0 if more than one bind address is required
bind-address = 192.168.1.2

# set which databases will be replicated (optional)
replicate-do-db = db1
replicate-do-db = db2

# set which databases will be ignored (optional)
replicate-ignore-db = ignore1
replicate-ignore-db = ignore2

...

Then, edit the variables.env file according to your system and run the change.sh script. Master log file and log position can be obtained by running show master status\G on the master and then updating the variables.env file with the obtained values on the slave. If master-master replacation is required, repeat the steps above for both machines.