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 vote158 views1 answer
How to to get time in sql
SQL
0 vote202 views1 answer
Mysql update table from select on another table
SQL
0 vote142 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote171 views1 answer
Prisma transaction
SQL
0 vote166 views1 answer
Add new column in sql with foreign key
SQL
11 votes133 views1 answer
Get ddl materialized view oracle
SQL
5 votes139 views2 answers
Sql create tabel with primary key auto_increment code
SQL
4 votes133 views1 answer
Mysql copy table with new name
SQL
0 vote143 views1 answer
How to update sql server version
SQL
23 votes129 views6 answers
How to create table in sql
SQL