Re: Strange errors / messages on slave server

2010-06-02 Thread Johan De Meersman
Depending on your mysql version and environment, another solution might be to switch to row-based binlogs. Make sure to read the documentation thoroughly, though - there's a number of caveats. On Wed, Jun 2, 2010 at 2:55 PM, Martin Gainty wrote: > > > In less technical terms, if the master goes

RE: Strange errors / messages on slave server

2010-06-02 Thread Martin Gainty
> In less technical terms, if the master goes faster than the slave, the slave > will puke. MG>then the master will have to teach the slave MG>is the master the entrenched bureacucrat or is that the slave? > > Regards, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington

Re: Strange errors / messages on slave server

2010-06-02 Thread Machiel Richards
Wed, Jun 2, 2010 at 2:22 PM, Jerry Schwartz wrote: > >-Original Message- > >From: machiel.richards [mailto:machiel.richa...@gmail.com] > >Sent: Wednesday, June 02, 2010 3:56 AM > >To: mysql@lists.mysql.com > >Subject: RE: Strange errors / messages

RE: Strange errors / messages on slave server

2010-06-02 Thread Jerry Schwartz
>-Original Message- >From: machiel.richards [mailto:machiel.richa...@gmail.com] >Sent: Wednesday, June 02, 2010 3:56 AM >To: mysql@lists.mysql.com >Subject: RE: Strange errors / messages on slave server > >Hi All > > Just one other note on this issue ex

RE: Strange errors / messages on slave server

2010-06-02 Thread machiel.richards
Hi All Just one other note on this issue experienced. I used google to try and find some solutions / clues and all the suggestions are to increase the innodb buffer pool size. This was however recently done on the database to increase this to 4Gb already. However