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 vote143 views2 answers
Oracle create chain rule
SQL
0 vote149 views1 answer
Min salary in sql
SQL
0 vote147 views1 answer
What is metadata in sql
SQL
11 votes147 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote154 views1 answer
Mysql default uuid
SQL
-1 vote147 views1 answer
Select first rows postgresql
SQL
0 vote155 views1 answer
Enable outgoing remote MySQL access
SQL
2 votes147 views1 answer
Update trigger
SQL
4 votes164 views1 answer
Describe table mysql
SQL
0 vote168 views1 answer
Selecting all columns from table sql database
SQL