Hello Andreas, If hs_sync_interval is 0 the sync process depends on how often the timeout process is running if the value is greater 0 it means an additional delay if the timeout interval is too short for you.
But I want to mention that the log is shared between master and standbys so the sync process does not need to transport log. Sync only means that the standbys are told up to which point they are allowed to recover. Kind regards Uwe -----Original Message----- From: Andreas Goldstein [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 12:40 AM To: Hahn, Uwe Cc: maxdb@lists.mysql.com Subject: RE: [FSID] Meaning of HS_SYNC_INTERVAL = 0 ? 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]
