Description:
Hi
I have three servers
A = Apache Server , It's running PHP
B = Master DB
C = Slave DB
In C.server show slave status \G;
It's response Slave_IO_Running: Yes and Slave_SQL_Running: Yes
And I login B.server use
INSERT INTO gameserver.ccu_log(calc_time,ccu) VALUES(UNIX_TIMESTAMP(),10);
It's working!
+-------+------------+-----+
| id | calc_time | ccu |
+-------+------------+-----+
| 28124 | 1282291240 | 10 |
+-------+------------+-----+
and C.server of slave can working ,too.
+-------+------------+-----+
| id | calc_time | ccu |
+-------+------------+-----+
| 28124 | 1282291240 | 10 |
+-------+------------+-----+
And then I in A.server use php to do this
$sql = "INSERT INTO gameserver.ccu_log(calc_time,ccu) VALUES(UNIX_TIMESTAMP(),$ccu);";
mysql_query($sql);
In B.server Master, still can work,so I get
+-------+------------+-----+
| id | calc_time | ccu |
+-------+------------+-----+
| 28124 | 1282291240 | 10 |
| 28124 | 1282295074 | 10 |
+-------+------------+-----+
But in C.server Slave, it's can not work...
only...
+-------+------------+-----+
| id | calc_time | ccu |
+-------+------------+-----+
| 28124 | 1282291240 | 10 |
+-------+------------+-----+
So, I observation mysql-bin.000001....
When I login B.server mysql cmd
use any insert into or update.
The Master and the Slave databases can work.
The mysql-bin.000001 will write this log.
But at A.server use php
The Master databases still can work.
But Slave database can not work...
And mysql-bin.000001 not write this log.
Please help us...
Thanks.
How to repeat:
Hi
I have three servers
A = Apache Server , It's running PHP
B = Master DB
C = Slave DB
In C.server show slave status \G;
It's response Slave_IO_Running: Yes and Slave_SQL_Running: Yes
And I login B.server use
INSERT INTO gameserver.ccu_log(calc_time,ccu) VALUES(UNIX_TIMESTAMP(),10);
It's working!
+-------+------------+-----+
| id | calc_time | ccu |
+-------+------------+-----+
| 28124 | 1282291240 | 10 |
+-------+------------+-----+
and C.server of slave can working ,too.
+-------+------------+-----+
| id | calc_time | ccu |
+-------+------------+-----+
| 28124 | 1282291240 | 10 |
+-------+------------+-----+
And then I in A.server use php to do this
$sql = "INSERT INTO gameserver.ccu_log(calc_time,ccu) VALUES(UNIX_TIMESTAMP(),$ccu);";
mysql_query($sql);
In B.server Master, still can work,so I get
+-------+------------+-----+
| id | calc_time | ccu |
+-------+------------+-----+
| 28124 | 1282291240 | 10 |
| 28124 | 1282295074 | 10 |
+-------+------------+-----+
But in C.server Slave, it's can not work...
only...
+-------+------------+-----+
| id | calc_time | ccu |
+-------+------------+-----+
| 28124 | 1282291240 | 10 |
+-------+------------+-----+
So, I observation mysql-bin.000001....
When I login B.server mysql cmd
use any insert into or update.
The Master and the Slave databases can work.
The mysql-bin.000001 will write this log.
But at A.server use php
The Master databases still can work.
But Slave database can not work...
And mysql-bin.000001 not write this log.
Please help us...
Thanks.
