List:Replication« Previous MessageNext Message »
From:Thomas Ackermann Date:January 30 2009 4:54pm
Subject:Re: Replication of certain databases only?
View as plain text  
Jan-Aage Frydenbø-Bruvoll schrieb:
> It's not 1 million packets - it's 1Mb per packet. You don't have to
> change your slave - just try doubling the value on the master. And
> yes, you have to - your first error message told you exactly that 1Mb
> was too little for what you are doing.
>   

Thanx for your advice - i tried to do so, increasing the value from 1M 
to 2M and then even to 8M.
I issued "stop slave;" and "start slave;" to get the slave running again 
- to no avail.
I stopped and started the master - also no effect ...

New data will not be replicated to the slave - and the slave continues 
to say:

090130 17:51:57 [Note] Slave SQL thread initialized, starting 
replication in log 'mysql-bin.000002' at position 305965, relay log 
'./essen214-relay-bin.000002' position: 47
090130 17:51:57 [Note] Slave I/O thread: connected to master 
'slave@mysql:3307',  replication started in log 'mysql-bin.000002' at 
position 305965
090130 17:51:57 [ERROR] Error reading packet from server: log event 
entry exceeded max_allowed_packet; Increase max_allowed_packet on master 
(server_errno=1236)
090130 17:51:57 [ERROR] Got fatal error 1236: 'log event entry exceeded 
max_allowed_packet; Increase max_allowed_packet on master' from master 
when reading data from binary log
090130 17:51:57 [ERROR] Slave I/O thread exiting, read up to log 
'mysql-bin.000002', position 305965

:-O

Thread
Replication of certain databases only?Thomas28 Jan
  • Re: Replication of certain databases only?Jeremy Zawodny29 Jan
    • Re: Replication of certain databases only?Thomas29 Jan
      • RE: Replication of certain databases only?Rick James29 Jan
        • Re: Replication of certain databases only?Thomas Ackermann30 Jan
          • Re: Replication of certain databases only?Truls Bergskaug30 Jan
            • Re: Replication of certain databases only?Thomas Ackermann30 Jan
              • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan
                • Re: Replication of certain databases only?Thomas Ackermann30 Jan
                  • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan
                    • Re: Replication of certain databases only?Thomas Ackermann30 Jan
                      • Re: Replication of certain databases only?Thomas Ackermann30 Jan
                        • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan
                          • Setting up slaves from a dump (was: Re: Replication of certain databasesonly?)Thomas1 Feb
                            • Re: Setting up slaves from a dump (was: Re: Replication of certain databases only?)Eric Bergen1 Feb
                              • Re: Setting up slaves from a dumpThomas1 Feb
                                • Re: Setting up slaves from a dumpEric Bergen1 Feb
                                  • Re: Setting up slaves from a dumpThomas2 Feb
                                    • Re: Setting up slaves from a dumpThomas2 Feb
                                      • Re: Setting up slaves from a dumpThomas2 Feb
                                        • Re: Setting up slaves from a dumpThomas2 Feb
                                          • Re: Setting up slaves from a dumpThomas2 Feb
                                            • Replication does not startThomas Ackermann2 Feb
                                              • Master does not write binary logs! (was: Re: Replication does notstart)Thomas Ackermann2 Feb
                                                • Re: Master does not write binary logs! (was: Re: Replication does not start)Claudio J. Chiabai2 Feb
                                                  • Re: Master does not write binary logs! (was: Re: Replication does not start)Claudio J. Chiabai2 Feb
                                                    • Re: Master does not write binary logs!Thomas2 Feb
                                                      • RE: Master does not write binary logs!Rick James2 Feb
                          • Re: Replication of certain databases only?Thomas1 Feb
                      • Re: Replication of certain databases only?Claudio J. Chiabai30 Jan
                        • Re: Replication of certain databases only?Thomas Ackermann30 Jan
                          • Re: Replication of certain databases only?Claudio J. Chiabai30 Jan
                      • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan
          • Re: Replication of certain databases only?Jan-Aage Frydenbø-Bruvoll30 Jan