Mysql config slave

[mysqld]

binlog_format     = ROW
log_bin           = binlog #The slave is going to copy all of the changes that are registered in the log.
expire_logs_days  = 10
server_id         = 1 #number must be unique and cannot match any other server-id in your replication group
log_slave_updates = 1
binlog_do_db      = databasename #You can include more than one database by repeating this line for all of the databases.

Source: planet.sito.ir

Similar codes

2 votes137 views1 answer
Sql server find columns list in tables
SQL
4 votes138 views1 answer
T-sql get duplicate rows
SQL
3 votes143 views2 answers
Mysql select database
SQL
0 vote132 views1 answer
Sql find gaps in date ranges
SQL
0 vote118 views1 answer
Sql show all users
SQL
10 votes238 views4 answers
Mysql if else
SQL
6 votes132 views2 answers
Drop foreign key
SQL
0 vote129 views1 answer
Install squirrel sql ubuntu
SQL
9 votes151 views3 answers
Date format in sql
SQL
0 vote132 views1 answer
Hou to run job from cmd .exe sql server jop
SQL