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 fc6e0086fc Updated the readme. 3 months ago
README.md Updated the readme. 3 months ago
change.sh Updated readme and change script 3 months ago
input.sh Initial commit 4 months ago
variables.env Whoops, forgot the variables.env 4 months ago

README.md

replication

A set of trivial scripts for mariadb replacation.

Setup

Firstly, edit the my.cnf file and consider the following lines

# 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

Secondly, edit the variables.env file according to your system.