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 vote146 views1 answer
Regex mongoose
SQL
2 votes118 views4 answers
Sql query interview questions
SQL
0 vote116 views1 answer
Allow null in psql
SQL
2 votes103 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote95 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
3 votes103 views1 answer
RENAME table pl sql
SQL
4 votes114 views1 answer
W3schools create table
SQL
0 vote105 views1 answer
Oracle right characters
SQL
2 votes103 views2 answers
Mysql on duplicate key ignore
SQL
5 votes131 views3 answers
Sql limit offset
SQL