Hello Uwe, thanks for you response!
What you say is, that the synchonisation is completley automated and can only affected by the paramters HS_SYNC_INTERVAL (When will the synchronsiation happen) and HS_SYNC_DELAY (Up to what moment changes of the master will be replicated on the Standbys) and therefore is no need for a manual sync-command. Am I right then, that HS_SYNC_Interval = 0 means, that the changes of the master will result in triggering the synchronisation server immediateley (0 seconds delay) after the changes occured? Thanks for help and comments! Kind regards > --- Ursprüngliche Nachricht --- > Von: "Hahn, Uwe" <[EMAIL PROTECTED]> > An: "Andreas Goldstein" <[EMAIL PROTECTED]>, > <maxdb@lists.mysql.com> > Betreff: RE: [FSID] Meaning of HS_SYNC_INTERVAL = 0 ? > Datum: Thu, 8 Sep 2005 17:23:54 +0200 > > Hello Andreas, > > the timeout task is running every 30 sec and on a hot standby master > node > this task triggers a synchronize server which sends info's to the > standby nodes. > The parameter HS_SYNC_INTERVAL delays this behaviour so that not every > time the timeout task > is running the synchronize process is triggered. > So the synchronization is always done automatically and > there is no command to force a synch with the standbys. > > Kind regards > Uwe > > >-----Original Message----- > >From: Andreas Goldstein [mailto:[EMAIL PROTECTED] > >Sent: Thursday, September 08, 2005 4:21 PM > >To: maxdb@lists.mysql.com > >Subject: [FSID] Meaning of HS_SYNC_INTERVAL = 0 ? > > > >Hi Listmembers, > > > >When using the Hotstandby-feature of MaxDB the special DB-paramter > >HS_Sync_Interval is used to configure the period between two > >synchronisation-requests. The description of this parameter in DBM GUI > >mentions a range from 0 up to 36000 which will be interpreted > >as seconds. > >Unfourtunately it is not explicit said, what the meaning of 0 is. > > > >So my question is: > >Setting HS_Sync_Interval = 0 results in: > >a) No automatic synchronisation-requests will happen > >b) The sync-requests occur immediately after a change in the > >master-instance > >with no delay > > > > > >If a) is right: > >How can a sync-request triggered manualy? > > > >If b) is right: > >Are there any negative effects on the master-instance if a low delay is > >configured beside the possibility of heavy traffic? > > > >Thanks for comments and help > > > >Regards > > > >-- > >GMX DSL = Maximale Leistung zum minimalen Preis! > >2000 MB nur 2,99, Flatrate ab 4,99 Euro/Monat: > >http://www.gmx.net/de/go/dsl > > > >-- > >MaxDB Discussion Mailing List > >For list archives: http://lists.mysql.com/maxdb > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
