MySQL Forums
Forum List  »  Replication

How long replication takes?
Posted by: Martin Schmidt
Date: December 06, 2004 03:49AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
How long replication takes?
9395
December 06, 2004 03:49AM
3724
December 06, 2004 03:51AM
3824
December 07, 2004 03:47PM
3542
December 18, 2004 12:30PM
3640
December 19, 2004 03:55AM
3848
December 30, 2004 11:45AM
3407
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.