Post the output from running 'show slave status\G' on the slave.
On Feb 18, 2008 11:42 PM, Jose Thomas <tk.jose@stripped> wrote:
> Hello DB masters,
>
> Please forgive me for a long mail.
>
> MASTER and SLAVE are running MySQL version 4.1.20 on RHEL4.
>
> Setting up replication from MASTER to SLAVE successfully as per the
> instructions in the mysql URL.
> The DB used in the master is "portal" and at the slave is it called
> "portallive"
>
> Every thing appears to be working, as the MASTER is creating the "binlog"
> file(in the mysql-bin.00000x) and
> client receives it instantly(in the slave-relay.0000x). However, database
> in the SLAVE is not getting updated.
> It is always shows the "timestamp" of the creation time.
>
> I will attach both the master and slave /etc/my.cnf file and some
> additional details below.
>
> Here is the DIRECTORY LISTING from the MASTER (see the "timestamp")
>
> [root@www logs]# pwd
> /var/lib/mysql/logs
> [root@www logs]# ll
> total 4244
> -rw-rw---- 1 mysql mysql 2346331 Feb 18 12:47 mysql-bin.000001
> -rw-rw---- 1 mysql mysql 1971007 Feb 18 14:26 mysql-bin.000002
> -rw-rw---- 1 mysql mysql 74 Feb 18 12:47 mysql-bin.index
> [root@www logs]#
>
> And here is the DIRECTORY LISTING from the SLAVE SIDE (note the time
> stamp)
>
> [root@stage mysql]# pwd
> /var/lib/mysql
> [root@stage mysql]# ls -l slave-relay*
> -rw-rw---- 1 mysql mysql 1972003 Feb 18 14:25 slave-relay.000002
> -rw-rw---- 1 mysql mysql 34 Feb 18 12:46 slave-relay-log.index
> [root@stage mysql]#
>
> Also I 'tail'ed both "mysql-bin.000002" and "slave-relay-000002" in the
> Master and Slave and
> the updates are almost instantly.
>
> But the ACTUAL DB time stamp in the MASTER is getting updated, but in the
> SLAVE it is remain same as the dump created.
> I would like to see the DB in the Master(portal) is same as the DB in the
> Slave(portallive).
>
> My question is that any additional change or command required to pass the
> already updated binlog
> information in the slave to the DB?. Why the DB in the Slave is not the
> replication of the DB in the Master?
>
> Any responses are appreciated.
>
> Thanks in advance for your time and help
> Jose
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
--
Mark Callaghan
mcallaghan@stripped
