RE: checking status mysql replication HELP ?!?
"Mike Knox" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
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:[email protected]] Sent: 23 October 2003 14:44 To: Brent Bailey Cc: [email protected] 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 <snip> > 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/[email protected]