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 votes219 views5 answers
Install postgresql 10 centos 7
SQL
8 votes161 views3 answers
Mysql alter table add index
SQL
1 vote208 views1 answer
Count of tables in database mysql
SQL
0 vote175 views3 answers
Database restoring error
SQL
0 vote181 views1 answer
Mariadb create index if not exists
SQL
0 vote182 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote159 views1 answer
SQL Server format datetime
SQL
2 votes191 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote186 views2 answers
How to see table associated with a schema in sql
SQL
0 vote179 views1 answer
Mysql regex exact match
SQL