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 vote225 views1 answer
Into operator in sql
SQL
0 vote220 views1 answer
Where field is null sql knex
SQL
0 vote229 views1 answer
Postgresql combine values in one field
SQL
0 vote212 views1 answer
Sqlite commands
SQL
0 vote244 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
1 vote225 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote215 views1 answer
Mysql count grouped rows
SQL
0 vote241 views1 answer
Oracle chain step succeeded
SQL
3 votes227 views1 answer
Oracle list dates without weekends
SQL
0 vote210 views1 answer
Sql get table last modified time
SQL