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

0 vote193 views4 answers
How to connect form to database
SQL
0 vote211 views1 answer
Less than date query sqlachemy
SQL
0 vote355 views1 answer
Running mysql from bash sc
SQL
0 vote192 views1 answer
Sql server set complex constraints
SQL
0 vote188 views1 answer
How to check xampp mysql password
SQL
0 vote195 views1 answer
Custom row number
SQL
3 votes149 views4 answers
Mysql delete duplicate rows
SQL
0 vote225 views3 answers
Sql select statements
SQL
0 vote206 views1 answer
Define a variable in mysql from select
SQL
0 vote189 views1 answer
Mysql find non alphanumeric characters
SQL