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