Team Exasol
Team Exasol

Background

This article guides you through the steps required to configure the automatic time synchronization via NTP servers on EXASolution clusters.

Prerequisites

If the time shift is greater than one hour it is required to set the time at first manually, which is described in Manually setting time via EXAoperation.
There is no downtime need if the time shift is less than one hour.

⚠️ Please note that:

  1. The cluster nodes constantly exchange configuration and vitality information and depend on proper time synchronization. While it is possible to manually set the time on EXASolution clusters, it is highly recommended to supply NTP servers for time synchronization.
  2. The tasks performed in EXAoperation requires a user with at least "Administrator" privileges.

Please ensure that the NTP servers provided to EXAoperation

  1. are connectible from the cluster (port filtering, firewalling) and
  2. can be addressed by name or IP address (i.e.: hostnames must be resolvable through DNS).
    Check the gap between the currently configured time and the actual time

Procedure

1.1 Check currently configured time on the cluster

  • Open 'Services > Monitoring'
  • Check the following value in the field:
1.1.1_Check_time.PNG
  • Open 'Configuration > Network'
  • Check the value in the field "Time Zone"
1.1.2_check_timezone.PNG

Make a rough estimation of the mismatch. ⚠️If the mismatch is greater than one hour please set the time manually, which is described in Manually setting time via EXAoperation.

1.2 Configure NTP Server

  • Open 'Configuration > Network'
  • Click on "Edit" 

1.2.1_edit_network.PNG

  • Add the IP-addresses of the server
1.2.2_add_ntp.PNG
  •  Apply the new configuration
1.2.3_added_ntp.PNG

1.3. Synchronize time on the cluster

  • Open 'Service > Monitoring'
  • Click on "Synchronize Time"
1.3.1_synchronise_time.PNG

Now the cluster will synchronize the time with the configured NTP servers constantly.