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 vote301 views1 answer
Soql update query
SQL
2 votes318 views1 answer
Sqlplus clear screen
SQL
0 vote324 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote293 views1 answer
Match end of string regex sql
SQL
0 vote288 views2 answers
Sql server select where date
SQL
1 vote285 views1 answer
Load sql into mamp
SQL
0 vote301 views1 answer
How to input data as id in database sql c#
SQL
1 vote302 views1 answer
Increasing font and zooming in mysql workbench
SQL
2 votes324 views2 answers
Spring where to put the data sql
SQL
0 vote305 views1 answer
Sql reverse order of results
SQL