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

4 votes1.1K views1 answer
Oracle show errors
SQL
0 vote341 views1 answer
WHERE not regex in SQL
SQL
2 votes387 views1 answer
Datefromparts mssql
SQL
5 votes355 views1 answer
Sysdate in oracle sql
SQL
0 vote337 views1 answer
Mysql utc timestamp
SQL
8 votes344 views2 answers
Oracle auto increment primary key
SQL
0 vote363 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote342 views1 answer
Replace content value from old to new sql
SQL
0 vote353 views1 answer
Load data from text file to mysql database on mac terminal
SQL
1 vote330 views1 answer
Get rows affected mysql python
SQL