Hi all,
We use MySQL as a database backend on a portal site. We have a two
database server setup (one master, one slave). The master is a PIV 3,2 GHz.,
2 GB Ram and a 80GB Raid-1 system. The slave is a PIV 3.2 GHz., 4 GB Ram and
a 80GB Raid-0 system. Both run on MySQL 4.1.9 and only use InnoDB. Even
though the slave is a bigger system and is quite fast with selects, it
always falls behind in replication (Seconds behind the server keeps growing
at high-load times).
Is there any way to speed up the replication a little more? I have already
tried a whole lot of things but have never been successful, yet :-(
Here is a snapshot of the configuration:
skip-name-resolve
key_buffer=1M
max_allowed_packet=1M
thread_cache_size=128
thread_stack=128K
table_cache=1024
join_buffer_size=5M
read_buffer_size=5M
sort_buffer_size=5M
thread_concurrency=4
query_cache_size = 32M
query_cache_limit = 1M
query_cache_type = 2
max_connections=900
innodb_data_file_path=ibdata1:2G:autoextend
innodb_buffer_pool_size=1200M
innodb_additional_mem_pool_size=20M
P.S.: I hope I have given you enough information - it's my post on the
list...;-)
I appreciate your help,
Hannes Rohde
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
