checking status mysql replication HELP ?!?

------=_NextPart_000_00E5_01C39949.78BD9AA0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Im using Solaris 5.7 with apache & mysql . this server is setup to
replicate with another identical machine..to keep the 2 machines in sync

in case of the primary server fails we have a backup ..anywho my
question is ..how do I check to see the status of the replication
process
running or not,

from what I understand.I should be able to log into mysql doing

mysql -u username -p database name

it prompts for a password . I enter the pass and I get the

mysql>

from what im reading I should be able to do a

mysql> show master status

OR
mysql> show slave status

and it should return whether its running or not.

But it doesn't .it just returns this

mysql> show master status
->

what does this mean ? Im still kinda new to mysql .if anyone can point
me in the right direction that would be AWESOME.

Any and all help is GREATLY appreciated

Thank you
Brent Bailey CCNA
High Speed Data Services
MetroCast Cablevision
603-332-8629 ext:242
bbailey@metrocastcablevision.com


------=_NextPart_000_00E5_01C39949.78BD9AA0--

Re: checking status mysql replication HELP ?!?

Brent Bailey wrote:

> Im using Solaris 5.7 with apache & mysql . this server is setup to
> replicate with another identical machine..to keep the 2 machines in sync



> mysql> show master status
> ->
>
> what does this mean ? Im still kinda new to mysql .if anyone can point
> me in the right direction that would be AWESOME.

It's asking for a full SQL statement, which needs to be terminated with
a semicolon.

If you don't put one in, it assumes a multi-line statement and prompts
you for the next line. So, either type a semicolon (';') after the
prompt, or terminate the initial statement with one before pressing return.

Regards,

Vincent


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

RE: checking status mysql replication HELP ?!?

I've just implemented a quick and dirty check. As the master's updates are
performed on the slave the file master.info gets updated. Depending on the
frequency of updates to the master - you could just take a copy of
master.info and then compare for differences - say every 15 minutes. Not
elegant but it's Unix scriptable.

Mike

-----Original Message-----
From: Vincent Cunniffe [mailto:vincent@ariatele.com]
Sent: 23 October 2003 14:44
To: Brent Bailey
Cc: bugs@lists.mysql.com
Subject: Re: checking status mysql replication HELP ?!?


Brent Bailey wrote:

> Im using Solaris 5.7 with apache & mysql . this server is setup to
> replicate with another identical machine..to keep the 2 machines in sync



> mysql> show master status
> ->
>
> what does this mean ? Im still kinda new to mysql .if anyone can point
> me in the right direction that would be AWESOME.

It's asking for a full SQL statement, which needs to be terminated with
a semicolon.

If you don't put one in, it assumes a multi-line statement and prompts
you for the next line. So, either type a semicolon (';') after the
prompt, or terminate the initial statement with one before pressing return.

Regards,

Vincent


------------------------------------------------------------ ------------------
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.

============================================================ ==================


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: checking status mysql replication HELP ?!?

Hello all,

Brent,
Run SHOW MASTER STATUS on Master only and SHOW SLAVE STATUS on Slave respecively.

Mike Knox wrote:
> I've just implemented a quick and dirty check. As the master's updates are
> performed on the slave the file master.info gets updated. Depending on the
> frequency of updates to the master - you could just take a copy of
> master.info and then compare for differences - say every 15 minutes. Not
> elegant but it's Unix scriptable.

I don't see any benefit over checking SHOW SLAVE STATUS output.

Besides everything you must take care that nothing writes master.info except for
mysqld.




> Mike

--
Are you MySQL certified? -> http://www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org