From: MaFai (zh-mahkbn.com.hk)
Date: Fri Jul 02 2004 - 04:41:24 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Dear ALL:

Some time the slave would crushed by I/O error.It happen at the server with the lower CPU.( per 45 days )
All of the slave database has block the binary log,it reduce the CPU loading.
The database would replicate text,int,varchar but no blob.
Network connection hasn't drop frequently,it seems hard to avoid that.
Do any way make the slave query more time but not just idle and wait for the data?
Since we can't bear the slave need 10 minutes to synchronize the data with master.

Here the master status
Uptime: 2592393 Threads: 24 Questions: 214644229 Slow queries: 197 Opens: 580 Flush tables: 1 Open tables: 254 Queries per second avg: 82.798

======== At 2004-07-01, 22:06:24 you wrote: ========

What does the network setup look like? What type of data is being replicated
varchar, text, blob? Is the network connection being dropped or are there
any errors being logged anywhere?

-----Original Message-----
From: MaFai
To: mysqllists.mysql.com
Sent: 6/30/04 10:34 PM
Subject: Replication Performance

Dear, mysqllists.mysql.com,

    We have set up 1 master and 4 slave as replication.
    Sometime,the slave need 4~10 minutes to synchronize the data with
master database.
    Do any way to tune the performance?
    Or any other way to reduce the time to replicate?
    

Best regards.

                MaFai
                zh-mahkbn.com.hk
                2004-07-01

= = = = = = = = = = = = = = = = = = = = = =
Best regards.

                MaFai
                zh-mahkbn.com.hk
                2004-07-02

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]