Replication ISSUE

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 423,488 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,742 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 463 | Replies: 1

•

Join Date: Jun 2008

Posts: 1

Reputation: tech@gmail.com is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

tech@gmail.com tech@gmail.com is offline

Offline

Newbie Poster

Replication ISSUE

Jun 10th, 2008

Hi All

2 db servers
replication interval in every 60 secs right now
needs to have length interval ncreased
is this o.k. to do - pro's and cons of this

Thanks for ur time and help..............

•

Join Date: Dec 2007

Posts: 113

Reputation: mwasif is an unknown quantity at this point

Rep Power: 1

Solved Threads: 13

mwasif

Offline

Junior Poster

Re: Replication ISSUE

Jun 15th, 2008

Are you talking about connect retry? 60 secs are fine for connect retry. Increasing this interval will increase the lag time beween master and slave at some point.