List:Replication« Previous MessageNext Message »
From:Mark Callaghan Date:February 19 2008 3:40pm
Subject:Re: Slave DataBase us not updating, though binlog getting all updates from Master
View as plain text  
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

Thread
Slave DataBase us not updating, though binlog getting all updates from MasterJose Thomas19 Feb
  • Re: Slave DataBase us not updating, though binlog getting all updates from MasterMark Callaghan19 Feb
    • Re: Slave DataBase us not updating, though binlog getting all updates from MasterJose Thomas21 Feb