SYNCHRONIZATION TESTING OF ACTIVE CLUSTERED SERVERS

• US 20160041859A1
• Filed: 04/17/2015
• Published: 02/11/2016
• Est. Priority Date: 08/11/2014
• Status: Active Grant

• Current Assignee: SAS Institute Incorporated
• Original Assignee: SAS Institute Incorporated
• Inventors: Burns, Michael Kent, Grimes, Gregory Ivan
• Granted Patent: US 9,998,544 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/00 Error detection; Error correction; Monitoring error detection, correction or monitoring in information storage based on relative movement between record carrier and transducer G11B20/18; monitoring, i.e. supervising the progress of recording or reproducing G11B27/36; in static stores G11C29/00
• CPC Class Codes: G06F 11/1458 Management of the backup or restore process
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 11/20 using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
• CPC Class Codes: G06F 11/2094 Redundant storage or storage space G06F11/2056 takes precedence
• CPC Class Codes: G06F 11/2097 maintaining the standby controller/processing unit updated initialisation or re-synchronisation thereof G06F11/1658 and subgroups
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: H04L 67/125 involving control of end-device applications over a network

Abstract

In a computing device that performs synchronization testing of a plurality of active clustered servers, a request to check synchronization between slave data stored and master data is received. The request includes master synchronization test values computed by a master node that include a number of records included in a dataset and a sum of modification time values for the records. Slave synchronization test values are computed that include a number of records included in the dataset of the slave data and a sum of modification time values for the records in the dataset of the slave data. The computed slave synchronization test values are compared to the master synchronization test values. A message is sent to the requesting device indicating the slave node is synchronized when the computed synchronization test values match or indicating the slave node is not synchronized when the computed synchronization test values do not match.

Claims

1. A non-transitory computer-readable medium having stored thereon computer-readable instructions that when executed by a computing device cause the computing device to:

receive a request to check synchronization between slave data stored at a slave node and master data stored at a master node from a requesting device, wherein the request includes master synchronization test values computed by the master node, wherein the master synchronization test values include a number of records included in a dataset of the master data and a sum of modification time values for the records included in the dataset of the master data, wherein each modification time value of the modification time values for the records included in the dataset of the master data indicates a time that a respective record of the records included in the dataset of the master data was last modified;

compute slave synchronization test values in response to receipt of the request, wherein the slave synchronization test values include a number of records included in the dataset of the slave data and a sum of modification time values for the records in the dataset of the slave data, wherein each modification time value of the modification time values for the records in the dataset of the slave data indicates a time that a respective record of the records included in the dataset of the slave data was last modified;

compare the computed slave synchronization test values to the received master synchronization test values; and

send a message to the requesting device that indicates that the slave node is synchronized with the master node when the computed slave synchronization test values match the received master synchronization test values, or that indicates that the slave node is not synchronized with the master node when the computed slave synchronization test values do not match the received master synchronization test values.

2. The non-transitory computer-readable medium of claim 1, wherein the received master synchronization test values include a lowest object identifier computed from the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a lowest object identifier computed from the records in the dataset of the slave data.

3. The non-transitory computer-readable medium of claim 2, wherein the received master synchronization test values include a highest object identifier computed from the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a highest object identifier computed from the records in the dataset of the slave data.

4. The non-transitory computer-readable medium of claim 1, wherein the received master synchronization test values include a lowest modification time value computed from the modification time values for the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a lowest modification time value computed from the modification time values for the records in the dataset of the slave data.

5. The non-transitory computer-readable medium of claim 4, wherein the received master synchronization test values include a highest modification time value computed from the modification time values for the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a highest modification time value computed from the modification time values for the records in the dataset of the slave data.

6. The non-transitory computer-readable medium of claim 1, wherein the received request further includes a minimum time, wherein the modification time value of each respective record of the records included in the dataset of the master data and used to compute the master synchronization test values is greater than or equal to the minimum time, and wherein the modification time value of each respective record of the records included in the dataset of the slave data and used to compute the slave synchronization test values is greater than or equal to the minimum time.

7. The non-transitory computer-readable medium of claim 1, wherein the received request further includes a maximum time, wherein the modification time value of each respective record of the records included in the dataset of the master data and used to compute the master synchronization test values is less than or equal to the maximum time, and wherein the modification time value of each respective record of the records included in the dataset of the slave data and used to compute the slave synchronization test values is less than or equal to the maximum time.

8. The non-transitory computer-readable medium of claim 1, wherein the received request further includes a specific dataset name associated with the dataset of the master data, wherein the dataset of the slave data has the specific dataset name.

9. The non-transitory computer-readable medium of claim 1, wherein the requesting device is the master node.

10. The non-transitory computer-readable medium of claim 1, wherein the request is an update request that indicates an update to a record of the dataset.

11. The non-transitory computer-readable medium of claim 1, wherein the request is automatically and periodically generated.

12. The non-transitory computer-readable medium of claim 1, wherein the time that the respective record of the records included in the dataset of the master data was last modified includes a date value and a time value.

13. The non-transitory computer-readable medium of claim 1, wherein the computer-readable instructions further cause the computing device to synchronize the slave node with the master node when the computed second synchronization test values do not match the received first synchronization test values.

14. A computing device comprising:

a processor; and

a non-transitory computer-readable medium operably coupled to the processor, the computer-readable medium having computer-readable instructions stored thereon that, when executed by the processor, cause the computing device to

receive a request to check synchronization between slave data stored at a slave node and master data stored at a master node from a requesting device, wherein the request includes master synchronization test values computed by the master node, wherein the master synchronization test values include a number of records included in a dataset of the master data and a sum of modification time values for the records included in the dataset of the master data, wherein each modification time value of the modification time values for the records included in the dataset of the master data indicates a time that a respective record of the records included in the dataset of the master data was last modified;

compute slave synchronization test values in response to receipt of the request, wherein the slave synchronization test values include a number of records included in the dataset of the slave data and a sum of modification time values for the records in the dataset of the slave data, wherein each modification time value of the modification time values for the records in the dataset of the slave data indicates a time that a respective record of the records included in the dataset of the slave data was last modified;

compare the computed slave synchronization test values to the received master synchronization test values; and

send a message to the requesting device that indicates that the slave node is synchronized with the master node when the computed slave synchronization test values match the received master synchronization test values, or that indicates that the slave node is not synchronized with the master node when the computed slave synchronization test values do not match the received master synchronization test values.

15. The computing device of claim 14, wherein the received master synchronization test values include a lowest object identifier computed from the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a lowest object identifier computed from the records in the dataset of the slave data.

16. The computing device of claim 15, wherein the received master synchronization test values include a highest object identifier computed from the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a highest object identifier computed from the records in the dataset of the slave data.

17. The computing device of claim 14, wherein the received master synchronization test values include a lowest modification time value computed from the modification time values for the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a lowest modification time value computed from the modification time values for the records in the dataset of the slave data.

18. The computing device of claim 17, wherein the received master synchronization test values include a highest modification time value computed from the modification time values for the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a highest modification time value computed from the modification time values for the records in the dataset of the slave data.

19. The computing device of claim 14, wherein the received request further includes a minimum time, wherein the modification time value of each respective record of the records included in the dataset of the master data and used to compute the master synchronization test values is greater than or equal to the minimum time, and wherein the modification time value of each respective record of the records included in the dataset of the slave data and used to compute the slave synchronization test values is greater than or equal to the minimum time.

20. The computing device of claim 14, wherein the received request further includes a maximum time, wherein the modification time value of each respective record of the records included in the dataset of the master data and used to compute the master synchronization test values is less than or equal to the maximum time, and wherein the modification time value of each respective record of the records included in the dataset of the slave data and used to compute the slave synchronization test values is less than or equal to the maximum time.

21. The computing device of claim 14, wherein the request is an update request that indicates an update to a record of the dataset.

22. The computing device of claim 14, wherein the request is automatically and periodically generated.

23. A method of synchronization testing of a plurality of active clustered servers, the method comprising:

receiving a request to check synchronization between slave data stored at a slave node and master data stored at a master node from a requesting device by a computing device, wherein the request includes master synchronization test values computed by the master node, wherein the master synchronization test values include a number of records included in a dataset of the master data and a sum of modification time values for the records included in the dataset of the master data, wherein each modification time value of the modification time values for the records included in the dataset of the master data indicates a time that a respective record of the records included in the dataset of the master data was last modified;

computing, by the computing device, slave synchronization test values in response to receipt of the request, wherein the slave synchronization test values include a number of records included in the dataset of the slave data and a sum of modification time values for the records in the dataset of the slave data, wherein each modification time value of the modification time values for the records in the dataset of the slave data indicates a time that a respective record of the records included in the dataset of the slave data was last modified;

comparing, by the computing device, the computed slave synchronization test values to the received master synchronization test values; and

sending, by the computing device, a message to the requesting device that indicates that the slave node is synchronized with the master node when the computed slave synchronization test values match the received master synchronization test values, or that indicates that the slave node is not synchronized with the master node when the computed slave synchronization test values do not match the received master synchronization test values.

24. The method of claim 23, wherein the received master synchronization test values include a lowest object identifier computed from the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a lowest object identifier computed from the records in the dataset of the slave data.

25. The method of claim 24, wherein the received master synchronization test values include a highest object identifier computed from the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a highest object identifier computed from the records in the dataset of the slave data.

26. The method of claim 23, wherein the received master synchronization test values include a lowest modification time value computed from the modification time values for the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a lowest modification time value computed from the modification time values for the records in the dataset of the slave data.

27. The method of claim 26, wherein the received master synchronization test values include a highest modification time value computed from the modification time values for the records in the dataset of the master data, and wherein the computed slave synchronization test values further include a highest modification time value computed from the modification time values for the records in the dataset of the slave data.

28. The method of claim 23, wherein the received request further includes a minimum time, wherein the modification time value of each respective record of the records included in the dataset of the master data and used to compute the master synchronization test values is greater than or equal to the minimum time, and wherein the modification time value of each respective record of the records included in the dataset of the slave data and used to compute the slave synchronization test values is greater than or equal to the minimum time.

29. The method of claim 23, wherein the request is an update request that indicates an update to a record of the dataset.

30. The method of claim 23, wherein the request is automatically and periodically generated.