Bug #15670 | Replication | ||
---|---|---|---|
Submitted: | 11 Dec 2005 20:17 | Modified: | 23 Dec 2005 14:19 |
Reporter: | benhamou ariel | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.16 | OS: | Windows (windows 2003 server) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[11 Dec 2005 20:17]
benhamou ariel
[11 Dec 2005 20:29]
MySQL Verification Team
Sorry I didn't ubderstand very well what are you reporting. Please provide the slave and master setup (my.ini files) and a sample of table on master and the queries that the slave can't update. Thanks in advance.
[14 Dec 2005 10:53]
benhamou ariel
Fichier my.ini du serveur
Attachment: my.ini (application/octet-stream, text), 1.13 KiB.
[14 Dec 2005 10:54]
benhamou ariel
Fichier my.ini du slave
Attachment: my.ini (application/octet-stream, text), 946 bytes.
[14 Dec 2005 12:40]
benhamou ariel
all the requetes to send to the slave is taken into account. It are put on the files of log but are not carried out
[23 Dec 2005 13:52]
MySQL Verification Team
While setting your master/slave configuration files (my.ini) I noticed that you are using the 3306 port for both. I assume that master and slave are installed on different machines, that is correct? Thanks in advance.
[23 Dec 2005 14:00]
benhamou ariel
Indeed. The two basic engines of data are sure 2 different waiters
[23 Dec 2005 14:19]
MySQL Verification Team
I was unable to repeat, I edited your configuration files for my environment install and the slave is updated: E:\master\bin>mysql --defaults-file=e:\master\my.ini -uroot --prompt="master>" Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.17-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. master>grant all on *.* to "slaveuser"@"localhost" identified by "slaveuser"; Query OK, 0 rows affected (0.14 sec) master>show master status\G *************************** 1. row *************************** File: sc002-bin.000001 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: mysql 1 row in set (0.01 sec) E:\slave\bin>mysql --defaults-file=e:\slave\smy.ini -uroot --prompt="slave>" Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.17-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. slave>CHANGE MASTER TO -> MASTER_HOST='localhost', -> MASTER_USER='slaveuser', -> MASTER_PASSWORD='slaveuser', -> MASTER_LOG_FILE='sc002-bin.000001', -> MASTER_LOG_POS=98; Query OK, 0 rows affected (0.23 sec) slave>start slave; Query OK, 0 rows affected (0.00 sec) slave>show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: localhost Master_User: slaveuser Master_Port: 3306 Connect_Retry: 98 Master_Log_File: sc002-bin.000001 Read_Master_Log_Pos: 98 Relay_Log_File: sc004-relay-bin.000002 Relay_Log_Pos: 235 Relay_Master_Log_File: sc002-bin.000001 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: 98 Relay_Log_Space: 235 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 1 row in set (0.03 sec) slave>show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.09 sec) slave> master>create database slavetest; Query OK, 1 row affected (0.02 sec) master>use slavetest Database changed master>create table tb1 (id int not null, nombre char(20)); Query OK, 0 rows affected (0.06 sec) master>insert into tb1 values (1,"maria"); Query OK, 1 row affected (0.00 sec) master>insert into tb1 values (2,"josefina"); Query OK, 1 row affected (0.00 sec) master> slave>show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | slavetest | | test | +--------------------+ 4 rows in set (0.00 sec) slave>use slavetest Database changed slave>select * from tb1; +----+----------+ | id | nombre | +----+----------+ | 1 | maria | | 2 | josefina | +----+----------+ 2 rows in set (0.00 sec) slave>show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: localhost Master_User: slaveuser Master_Port: 3306 Connect_Retry: 98 Master_Log_File: sc002-bin.000001 Read_Master_Log_Pos: 517 Relay_Log_File: sc004-relay-bin.000002 Relay_Log_Pos: 654 Relay_Master_Log_File: sc002-bin.000001 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: 517 Relay_Log_Space: 654 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 1 row in set (0.00 sec) slave>