I've been asked to setup replication between master and slave database. The aim is not to lock any tables while dumping database.
I've never setup replication but I have found this guide:
https://plusbryan.com/mysql-replication-without-downtime He is using these settings.
server-id=1 binlog-format = mixed log-bin=mysql-bin datadir=/var/lib/mysql innodb_flush_log_at_trx_commit=1 sync_binlog=1
server-id = 101 binlog-format = mixed log_bin = mysql-bin relay-log = mysql-relay-bin log-slave-updates = 1 read-only = 1
Could you please guys advise me if what following settings mean and what impact they will have on whole settings (database is around 35GB)
One more thing. This replication needs to be 'row based' so instead mixed I shall use row option in master settings
innodb_flush_log_at_trx_commit=1 sync_binlog=1 log-slave-updates = 1 read-only = 1
In don't want to suffer any performance issue or high I/O because of constant disk writes. As I mentioned I have no experience on settings this up so I'm kindly asking you for help. Many Thanks
SHOW TABLE STATUSor
SHOW CREATE TABLE.