List:Replication« Previous MessageNext Message »
From:Thomas Ackermann Date:February 2 2009 7:01pm
Subject:Replication does not start
View as plain text  
Hello again,
i tried to setup master and skave new - according to this URL:

http://homepage.mac.com/kelleherk/iblog/C711669388/E20061027215152/index.html

That felt good, as i used the right mysqldump options ...

But still, the slave just does not do nothing!

Here is the status:


The last data of the slave - from 19:32

essen:/var/lib/mysql # \ls -CFlrt usr_web1_1/ | tail -4
-rw-rw----  1 mysql mysql     8720 Feb  2 19:32 ibf_tracker.frm
-rw-rw----  1 mysql mysql     2048 Feb  2 19:32 ibf_tracker.MYI
-rw-rw----  1 mysql mysql     2829 Feb  2 19:32 ibf_tracker.MYD
-rw-rw----  1 mysql mysql   197632 Feb  2 19:32 ibf_topics.MYI


The slave´s status:

essen:/var/lib/mysql # mysql -e "show slave status\G"
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: mysql
                Master_User: slave
                Master_Port: 3307
              Connect_Retry: 60
            Master_Log_File: mysql-bin.000003
        Read_Master_Log_Pos: 4
             Relay_Log_File: essen-relay-bin.000002
              Relay_Log_Pos: 47
      Relay_Master_Log_File: mysql-bin.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 4
            Relay_Log_Space: 47
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 0

The slave´s processes:

essen:/var/lib/mysql # mysql -e "show processlist\G"
*************************** 1. row ***************************
     Id: 1
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 752
  State: Waiting for master to send event
   Info: NULL
*************************** 2. row ***************************
     Id: 2
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 752
  State: Has read all relay log; waiting for the slave I/O thread to 
update it
   Info: NULL
*************************** 3. row ***************************
     Id: 6
   User: mycs
   Host: essen:38696
     db: nickdb
Command: Sleep
   Time: 1
  State:
   Info: NULL
*************************** 4. row ***************************
     Id: 8
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show processlist





And now the master:

root@mysql:/usr/local/mysql/var# \ls -CFlrt usr_web1_1/ | tail -4
-rw-rw---- 1 mysql mysql   326480 Feb  2 19:50 ibf_members.MYD
-rw-rw---- 1 mysql mysql     4096 Feb  2 19:50 ibf_sessions.MYI
-rw-rw---- 1 mysql mysql     1992 Feb  2 19:50 ibf_sessions.MYD
-rw-rw---- 1 mysql mysql   186368 Feb  2 19:51 ibf_topics.MYI
root@mysql:/usr/local/mysql/var# 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:
root@mysql:/usr/local/mysql/var# mysql -e "show processlist\G"
*************************** 1. row ***************************
     Id: 1
   User: slave
   Host: hetzner:37767
     db: NULL
Command: Binlog Dump
   Time: 2274
  State: Has sent all binlog to slave; waiting for binlog to be updated
   Info: NULL
*************************** 2. row ***************************
     Id: 403
   User: slave
   Host: essen214:39486
     db: NULL
Command: Binlog Dump
   Time: 907
  State: Has sent all binlog to slave; waiting for binlog to be updated
   Info: NULL
*************************** 3. row ***************************
     Id: 485
   User: mycs
   Host: austria073:47492
     db: nickdb
Command: Sleep
   Time: 535
  State:
   Info: NULL
*************************** 4. row ***************************
     Id: 530
   User: mycs
   Host: austria073:47494
     db: nickdb
Command: Sleep
   Time: 382
  State:
   Info: NULL
*************************** 5. row ***************************
     Id: 588
   User: mycs
   Host: austria:52704
     db: nickdb
Command: Sleep
   Time: 143
  State:
   Info: NULL
*************************** 6. row ***************************
     Id: 604
   User: mycs
   Host: austria:52707
     db: nickdb
Command: Sleep
   Time: 14
  State:
   Info: NULL
*************************** 7. row ***************************
     Id: 620
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show processlist



So, all processes seem to run?
All stati are OK?

But still, nothing get´s replicated :-(


The log on the slave says, that everything is OK:

090202 19:58:51 [Note] Slave SQL thread initialized, starting 
replication in log 'mysql-bin.000003' at position 4, relay log 
'./essen-relay-bin.000002' position: 47
090202 19:58:51 [Note] Slave I/O thread: connected to master 
'slave@mysql:3307',  replication started in log 'mysql-bin.000003' at 
position 4

What may be wrong with my databases?!?

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