[dbs] MySQL Replikation haut nicht hin

[Niels Jende]

Hallo zusammen,

ich stehe vor einem Problem, welches mir nicht einleuchten will und 
hoffe, dass einer von Euch eine Lösung hat -- bzw mir sagen kann, wo ich was 
falsch gemacht habe.

Also ich habe hier zwei MySQL Server (debian etch 4.0r5) und möchte nun eine Replikation haben.

So, nach etwas googlen habe ich dann gefunden, dass ich nur etwas an den jeweiligen 
my.cnf's zu ändern habe. Dieses habe ich auch gemacht, aber es will nicht.

Hier mal die my.cnf des Slave:

[mysqld]
#
# * Basic Settings
#
#user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
server-id = 1
master-host = IP des Master
master-user = replikator
master-password = PWD
master-port = 3306
report-host = IP des Slave

hier die des Master:

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
server-id = 1
log_bin = binary


Wenn ich nun den Status vom Slave abfrage bekomme ich das hier:

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 10.2.2.22
Master_User: replikator
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: test3-relay-bin.000005
Relay_Log_Pos: 98
Relay_Master_Log_File:
Slave_IO_Running: No
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: 0
Relay_Log_Space: 98
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: NULL 

und so sieht es beim Master aus:


show master status;
+---------------+----------+-----------------------+-----------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+-----------------------+-----------------------+
| binary.000056 | 98 | include_database_name | include_database_name |
+---------------+----------+-----------------------+-----------------------+
1 row in set (0.00 sec)

und das hier bekomme ich, wenn ich mir die Processlist ansehe:

mysql> show PROCESSLIST\G;
*************************** 1. row ***************************
     Id: 1
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 1052
  State: Connecting to master
   Info: NULL
*************************** 2. row ***************************
     Id: 2
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 1052
  State: Has read all relay log; waiting for the slave I/O thread to update it
   Info: NULL
*************************** 3. row ***************************
     Id: 10
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show PROCESSLIST
3 rows in set (0.00 sec)

ERROR:
No query specified


So, wo habe ich mir einen Bock geschossen?

Ach ja, die Datenbank, ist kein Produktivsystem, liegt unter ~/test

Habt ihr eine Idee?

Besten Dank
Gruß
Niels
__________________________________________________________________
"Run, Fatboy, Run" sowie "Rails & Ties" kostenlos anschauen!
Blockbuster-Gutscheine sichern unter http://www.blockbuster.web.de