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 vote200 views2 answers
Athena drop partition
SQL
2 votes228 views2 answers
Mysql write into table
SQL
0 vote297 views1 answer
How to update random rows in sql
SQL
0 vote174 views1 answer
Show specific events on mysql
SQL
1 vote181 views1 answer
Rails run native ssql query
SQL
3 votes193 views3 answers
Mysqldump: couldn
SQL
0 vote280 views1 answer
Mysql collation portugues brasil
SQL
0 vote192 views2 answers
Sql query for getting details by id
SQL
0 vote198 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote175 views1 answer
Oracle free up space in tablespace
SQL