Re: Replication crashes when max_bin_log_size is reached
Yes, you seem to have the same problem. And I'm sorry to say but we have still not been able to find a solution for the problem. :/
Currently I have to monitor the database and when the relay log size almost reach the max_bin_log_size limit I have to do like this:
1) STOP SLAVE;
2) FLUSH LOGS;
3) Restart mysqld.
This way is the only way we can make it work and get mysql to rotate the relay log. But it's very annoying and as our business is growing we have to do this more frequently. Currently we have to do this almost 2 times a week. :(
I have tried pretty everything I can think our. I can't be permission problem cause I have tried with all permissions. But I have no longer any idea of what can be the cause of the problem and I have run out of ideas for a solution.
What version of MySQL do you use? What platform do you use?
We use MySQL 4.0.23 and RedHat Linux 2.4.22-1.2149.nptl and we also have ensim running on the server.
It seem to me that it's either a bug in MySQL or a bug in RedHat Linux. Our Master database run the same version of MySQL but with FreeBsd Linux instead and it has had no problems with creating new bin-logs. But I guess it's another deal with the relay logs.
If you manage to solve the problem I'm very interested in knowing how :)
Subject
Views
Written By
Posted
5984
February 19, 2005 08:33PM
3306
March 15, 2005 10:04AM
3673
April 20, 2005 06:29AM
3058
April 24, 2005 09:29PM
3115
April 30, 2005 02:52AM
Re: Replication crashes when max_bin_log_size is reached
3033
April 30, 2005 09:45AM
2950
May 01, 2005 02:29AM
2836
May 01, 2005 02:32AM
3019
May 06, 2005 01:59AM
2721
May 06, 2005 02:00AM
7809
May 11, 2005 08:12PM
3402
May 12, 2005 01:16PM
3149
May 16, 2005 04:32PM
2913
May 17, 2005 02:20AM
3094
May 17, 2005 06:53AM
2892
May 17, 2005 09:54AM
2985
May 17, 2005 06:23PM
3033
May 18, 2005 04:13AM
2980
May 18, 2005 08:02AM
5447
May 20, 2005 02:56PM
3833
May 23, 2005 03:30AM
2883
May 23, 2005 03:38AM
3000
May 31, 2005 08:52AM
3044
May 31, 2005 11:44AM
3119
May 02, 2005 07:31PM
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.