List:Replication« Previous MessageNext Message »
From:Claudio J. Chiabai Date:January 30 2009 6:14pm
Subject:Re: Replication of certain databases only?
View as plain text  
show slave status ?

El Friday 30 January 2009 16:03:02 Thomas Ackermann escribió:
> Jan-Aage Frydenbø-Bruvoll schrieb:
> > Try upping the size further until you get it going - you can always
> > take the limit down again once you get things stable.
>
> Thanx again!
>
> I increased the size to 256M and then 512M - stopped and started the
> slaves ...
> Same message :-(
>
> My my.cnf:
>
>
> grep -v ^\#  my.cnf | grep -v ^$
> [client]
> port            = 3307
> socket = /var/run/mysqld/mysql.sock
> [mysqld]
> port            = 3307
> socket = /var/run/mysqld/mysql.sock
> skip-locking
> key_buffer = 16M
> max_allowed_packet = 1M
> table_cache = 64
> sort_buffer_size = 512K
> net_buffer_length = 8K
> read_buffer_size = 256K
> read_rnd_buffer_size = 512K
> myisam_sort_buffer_size = 8M
> bind-address            = <myip>
> log-bin
> binlog-do-db=nickdb
> binlog-do-db=usr_web1_1
> binlog-do-db=uwc3
> server-id       = 1
> innodb_data_home_dir = /usr/local/mysql/var/
> innodb_data_file_path = ibdata1:10M:autoextend
> innodb_log_group_home_dir = /usr/local/mysql/var/
> innodb_log_arch_dir = /usr/local/mysql/var/
> innodb_buffer_pool_size = 256M
> innodb_additional_mem_pool_size = 2M
> innodb_log_file_size = 12M
> innodb_log_buffer_size = 8M
> innodb_flush_log_at_trx_commit = 1
> innodb_lock_wait_timeout = 50
> [mysqldump]
> quick
> max_allowed_packet = 16M
> [mysql]
> no-auto-rehash
> [isamchk]
> key_buffer = 20M
> sort_buffer_size = 20M
> read_buffer = 2M
> write_buffer = 2M
> [myisamchk]
> key_buffer = 20M
> sort_buffer_size = 20M
> read_buffer = 2M
> write_buffer = 2M
> [mysqlhotcopy]
> interactive-timeout
>
>
> For mysqldump, "max_allowed_packet" is 16M while it is 1M for mysqld (on
> Default) ...
> I copied most of that from the mysql examples ...
>
>
> Server is 4.1.22, one slave is 4.1.21 and the other 4.1.22 too - both
> with the same effect, which seems to be an argument for a problem on the
> master ..

-- 
Saludos ... Claudio
============================
Zarcrom Industries Corporation
16192 Coastal Highway
Lewes, DE 19958
http://www.zarcrom.com.ar/


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