472,353 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

checking replication in 4.0.x

Hello list,

I'm in the phase of upgrading mysql from 3.23(.58) to 4.0(.23). I have
some replication setups. Following the manual, the upgrade process went
very smooth.

Now I have some problems with checking replication automatically. For
3.23 I wrote a shell script, that looks on the master for the Binlog
Dump Processes in "show processlist;". That worked perfectly. If the
replication was disrupted, the respective process was gone immediately
and the check script could send a warning. Principally, the same check
script works for 4.0.23, too, but if I stop a slave, the respective
Binlog Dump Process vanishes not immediately from the master. It lasts
2200 to 2600 seconds, before the process is gone. Even if I shut down
the whole slave server, the Binlog Dump Process stays in the
processlist. I haven't found a variable to shorten these 2200 to 2600
seconds to a shorter period of time.

With this experience, I tried to setup report-host on the slave side
and check on the master with "show slave hosts;". This works also as
the method above: If slave is disconnected, the respective slave stays
in the list of "show slave hosts;". Only after a longer period of time,
the slave vanished from the list.

OK, I could write a script to check replication on the slave side. But
I did this some times ago (on 3.23). The result was, that in some
cases, the script ("show slave status;" also) reported a running slave,
which wasn't the truth. So I wouldn't trust this method.

Is there a possibility to check replication on the master side?

For answers I thank you very much.

Best Regards
Kurt Tragant

Jul 23 '05 #1
0 1203

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Cherrish Vaidiyan | last post by:
Hello, I have certain doubts regarding replication of Oracle 9i in Red Hat Linux 9. 1) I want to implement asynchronous/synchronous...
by: Cherrish Vaidiyan | last post by:
Frank <fbortel@nescape.net> wrote in message news:<bqgb99$a04$1@news1.tilbu1.nb.home.nl>... > Cherrish Vaidiyan wrote: > > Hello, > > > > I have...
by: steve | last post by:
Hi, several years ago , I implemented the oracle replication system. At that time our database was ported from an old Fox pro application. ( K...
by: John | last post by:
Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field...
by: dlesandrini | last post by:
I need advice about my decision to go with Replication in general. This post was placed on the Microsoft Replication newsgroup, but I really value...
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them...
by: David W. Fenton | last post by:
See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center...
by: Gert van der Kooij | last post by:
Hi, Our SQL Replication is between DB2 databases on Windows servers. I'm searching for the document which tells me how to migrate our SQL...
by: Query Builder | last post by:
Hi, I have transactional replication set up on on of our MS SQL 2000 (SP4) Std Edition database server Because of an unfortunate scenario, I...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.