List:Replication« Previous MessageNext Message »
From:Jessica Maas Date:December 8 2009 1:37pm
Subject:Master-Master (or circular replication) --> error connecting to
master
View as plain text  
Hi everyone,

I just tried to set up a Master-Master or circular replication with two
servers following this tutorial:
http://www.howtoforge.com/mysql_master_master_replication
(But I'm using Windows Server 2003 instead of linux - please DON'T ask why,
I have to use Windows and I CAN'T switch to linux)

My configuration:
Master 1: 192.168.0.1
Slave 1: 192.168.0.5

But now I'm stuck at step 5 with the following error (my.ini-files below):
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.0.1
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: dbserver2-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: No <-------------------------------------- here
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: 212
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
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1045
Last_IO_Error: error connecting to master 'replication@stripped
.1:3306' - retry-time: 60 retries: 86400
<------------------------------------------------- and here
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)

ERROR:
No query specified


-----------------------------Master 1 my.ini------------------------------
[client]
port=3306

[mysql]
default-character-set=latin1

[mysqld]
port=3306
basedir="C:/server/mysql/"
datadir="C:/server/mysql/data/"

log-bin
binlog-do-db=moodle # input the database which should be replicated
binlog-ignore-db=mysql # input the database that should be ignored for
replication
binlog-ignore-db=test
server-id=1

default-character-set=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=35M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=69M
key_buffer_size=56M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=3M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=108M
innodb_log_file_size=54M
innodb_thread_concurrency=8

[mysqld_safe]
err-log="C:/server/mysql/log/mysql.log"
pid-file="C:/server/mysql/pid/mysql.pid"

-----------------------------Slave 1 my.ini------------------------------
[client]
port=3306

[mysql]
default-character-set=latin1

[mysqld]
port=3306
basedir="C:/server/mysql/"
datadir="C:/server/mysql/data/"

server-id=2

master-host = 192.168.0.1
master-user = replication
master-password = slave
master-port = 3306

default-character-set=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=35M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=69M
key_buffer_size=56M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=3M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=108M
innodb_log_file_size=54M
innodb_thread_concurrency=8

[mysqld_safe]
err-log="C:/server/mysql/log/mysql.log"
pid-file="C:/server/mysql/pid/mysql.pid

Does anyone have an idea why it doesn't work?
I hope someone can help me out.

Thanks in advance,
Jessica

Thread
Master-Master (or circular replication) --> error connecting to masterJessica Maas8 Dec
  • Re: Master-Master (or circular replication) --> error connecting to masterJessica Maas8 Dec
    • Re: Master-Master (or circular replication) --> error connecting to masterEber Duarte8 Dec