How long replication takes?
I have build up a simple master - slave configuration.
Sometimes (i can't reproduce this behaviour) replication doesn't do anything for about 5-6 minutes. The 'show slave status' statement is ok, the I/O thread and slave thread are running.
My question: Why does replication took so long and how long can it take maximal, is there any parameter i have to set properly?
Greetings
Martin Schmidt
I'm using mysql version 4.0.18 and have the following configuration:
master:
[mysqld]
server-id = 110
master-host = x.x.x.x
master-user = xxxx
master-password = xxxx
master-port = 3306
master-connect-retry = 5
skip-slave-start
log-slave-updates
log-bin
log-bin=/var/lib/mysql/log-bin
log-bin-index=/var/lib/mysql/bin-log.index
max-binlog-size=32768K
master-info-file=/var/lib/mysql/master.info
relay-log=/var/lib/mysql/relay-bin
relay-log-index=/var/lib/mysql/relay-bin-log.index
relay-log-info-file=/var/lib/mysql/relay-log.info
max-relay-log-size=16384K
replicate-ignore-db=mysql
replicate-ignore-db=test
max_allowed_packet=768M
max_connections=256
slave:
[mysqld]
server-id = 111
master-host = x.x.x.x
master-user = xxxx
master-password = xxxx
master-port = 3306
master-connect-retry = 5
skip-slave-start
log-slave-updates
log-bin
log-bin=/var/lib/mysql/log-bin
log-bin-index=/var/lib/mysql/bin-log.index
max-binlog-size=32768K
master-info-file=/var/lib/mysql/master.info
relay-log=/var/lib/mysql/relay-bin
relay-log-index=/var/lib/mysql/relay-bin-log.index
relay-log-info-file=/var/lib/mysql/relay-log.info
max-relay-log-size=16384K
replicate-ignore-db=mysql
replicate-ignore-db=test
max_allowed_packet=768M
max_connections=256
Subject
Views
Written By
Posted
How long replication takes?
9424
December 06, 2004 03:49AM
3735
December 06, 2004 03:51AM
3833
December 07, 2004 03:47PM
3555
December 18, 2004 12:30PM
3652
December 19, 2004 03:55AM
3864
December 30, 2004 11:45AM
3416
January 01, 2005 04:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.