topic Re: Can we change the system time while the cluster and package is running? in Operating System - Linux

Can we change the system time while the cluster and package is running?

Jack007 — Sun, 18 Dec 2011 15:50:47 GMT

thanks a lot!

Re: Can we change the system time while the cluster and package is running?

Dennis Handly — Mon, 19 Dec 2011 04:22:20 GMT

Are you talking forward or backward?

I assume you are not just changing the timezone? Do you have NTP installed?

Re: Can we change the system time while the cluster and package is running?

Jack007 — Mon, 19 Dec 2011 07:51:35 GMT

Hi Dennis,

what's the differences?

My customer hasn't mention this.

Re: Can we change the system time while the cluster and package is running?

Dennis Handly — Mon, 19 Dec 2011 08:43:28 GMT

>what's the differences?

There may not be but setting the clock back is always worse.

Re: Can we change the system time while the cluster and package is running?

Patrick Wallek — Mon, 19 Dec 2011 20:15:09 GMT

How big of a time change are you looking to make? Seconds? Minutes? Hours? Days?

Is there a database running? If so changing the time can cause issues with the database as transaction times have the potential to suddenly not match.

Chaning the time backwards can really cause DB issues as the time is suddenly in the past.

Re: Can we change the system time while the cluster and package is running?

Jack007 — Tue, 27 Dec 2011 15:54:14 GMT

Dennis and Patrick,

Thanks for your advice, it's very helpful to me.

At last my customer stoped the DB and halted the MCSG cluster, then modified the system time.

I will ask talk about the impact of changing the time with the DBA.

Thanks again!