[Database O & M] Time Zone settings for databases (servers) and time zones in major regions of the world

[What is the problem with incorrect time zone settings?] during overseas project O & M, you may encounter time zone settings. If the time zone is improperly set or the time zones of servers of the same project are inconsistent, project Data exceptions may occur. If the data table field uses the date field, the default value of the field is sysdate, and the program

[What is the problem with incorrect time zone settings?] during overseas project O & M, you may encounter time zone settings. If the time zone is improperly set or the time zones of servers of the same project are inconsistent, project Data exceptions may occur. If the data table field uses the date field, the default value of the field is sysdate, and the program

[What are the problems with improper time zone settings]

When performing O & M for overseas projects, you may encounter time zone settings. If the time zone is improperly set or the time zones of servers of the same project are inconsistent, project Data exceptions may occur.
If the data table field uses the date field, the default value of the field is sysdate, and the default value of the field is used when the program inserts a record, it may cause data exceptions. Exercise caution when modifying the time zone of the database server.

[Server time synchronization method]

# Change the time synchronization server to the required address (Windows Address is recommended, because most PCs in the world use Windows OS. According to CNZZ data, in the Chinese operating system market, Microsoft Windows still dominated the market in January 2014, with a share of 90.63%)

Physical server environment:

*/10 */usr/sbin/ntpdate-u time.windows.com;/sbin/clock-w>/tmp/clock. log

Virtual Machine environment:

*/10 */usr/sbin/ntpdate-u time.windows.com>/tmp/clock. log

[How to modify the time zone settings of an online project]

Replacing/etc/localtime will immediately take effect for the operating system. However, if the operating system runs database program software, the database will not take effect immediately. You must restart the database. Therefore, if the current database has a problem with the time zone, it is recommended to maintain the status quo or confirm with the program development, and provide a feasible solution, and then perform database maintenance and modify the time zone. Of course, for a database that has just been installed and does not have any business data, you can re-install the database after modifying the operating system time zone to ensure that the time zone of the database metadata is correct.

Remember: failure is not possible. If there is a risk of failure, and the status quo is not maintained, it is a good choice to do nothing.

[Time zone and setting method for overseas regions]

#################### Set timezone ################## ###########

# TimeZone: UTC + 8, CST

# Area: China
Ln-fs/usr/share/zoneinfo/Asia/Shanghai/etc/localtime
Sed-I's/^ ZONE. */ZONE = "Asia \/Shanghai"/G'/etc/sysconfig/clock

# TimeZone: UTC + 8, SGT
# Area: Singapore
Ln-fs/usr/share/zoneinfo/Singapore/etc/localtime
Sed-I's/^ ZONE. */ZONE = "Singapore"/G'/etc/sysconfig/clock

# TimeZone: UTC + 7, ICT
# Area: Vietnam
Ln-fs/usr/share/zoneinfo/Asia/Ho_Chi_Minh/etc/localtime
Sed-I's/^ ZONE. */ZONE = "Asia \/Ho_Chi_Minh"/G'/etc/sysconfig/clock

# TimeZone: UTC-8, PST
# Area: US, California
Ln-sf/usr/share/zoneinfo/America/Los_Angeles/etc/localtime
Sed-I's/^ ZONE. */ZONE = "America \/Los_Angeles"/G'/etc/sysconfig/clock

# TimeZone: UTC + 8, EST
# Area: Au
/Usr/share/zoneinfo/Australia/sysydney
Ln-sf/usr/share/zoneinfo/Australia/sysydney/etc/localtime
Sed-I's/^ ZONE. */ZONE = "Australia \/sysydney"/G'/etc/sysconfig/clock

# TimeZone: UTC + 1, CEST
# Area: German
Ln-fs/usr/share/zoneinfo/Europe/Berlin/etc/localtime
Sed-I's/^ ZONE. */ZONE = "Europe \/Berlin"/G'/etc/sysconfig/clock