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

11 votes189 views1 answer
Mysql order by two columns priority
SQL
0 vote171 views1 answer
Not equal to blank in mysql
SQL
0 vote176 views1 answer
Mysql begin statement
SQL
11 votes187 views1 answer
Oracle view source
SQL
0 vote173 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote178 views1 answer
Big table in mysql
SQL
0 vote217 views1 answer
Pagination with row_number
SQL
1 vote191 views1 answer
Mysql show database size in mb
SQL
5 votes186 views2 answers
Oracle find all tables with column name
SQL
0 vote176 views1 answer
View psql output in horizontal scrolling
SQL