On Mon, 25 Apr 2005, Fagyal Csongor wrote:
> Hi,
>
> I am new to replication so excuse me if my question is stupid.
>
> The manual recommends that a nice scenario to take advantage of
> replication in MySQL is to send all updating queries to the master
> server, and reading from the slave. I would
Loo at :
mysql> show master status;
+---+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---+--+--+--+
| binlog.03 | 79 | | |
+--
Yes, replication can be behind. If you SHOW SLAVE STATUS on the slave
computer, you can see exactly how far behind the slave is on replication.
You should design your systems such that a lag in updates doesn't affect the
logic of your system.
There are many uses in which this is a non-issue.