List:Replication« Previous MessageNext Message »
From:Claudio J. Chiabai Date:February 2 2009 7:17pm
Subject:Re: Master does not write binary logs! (was: Re: Replication does not start)
View as plain text  
Permissions (mysql:mysql)? No activity en databases? (Binlog_Do_DB: 
nickdb,usr_web1_1,uwc3)

Try set new prefiz en master Binlogs y change the master to new binary LOG's


El Monday 02 February 2009 17:10:35 Thomas Ackermann escribió:
> It seems, the Master just does not write binary logs!
>
>
> Here is the configuration:
>
> [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            = mysql
> log-bin
> binlog-do-db=nickdb,usr_web1_1,uwc3
> server-id       = 1
>
> [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
>
>
>
> Does anything above prevent the binary logs to be written?!?
>
> The master itself believe everything to be OK:
>
> mysql -e "show master status\G"
> *************************** 1. row ***************************
>             File: mysql-bin.000003
>         Position: 4
>     Binlog_Do_DB: nickdb,usr_web1_1,uwc3
> Binlog_Ignore_DB:
>
>
> But mysql-bin.000003 is untouched since some time - althought the
> databases get changed!
>
> So, binary loging is not correctly running and the cause for all my
> problems!

-- 
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