search

zettadb / kunlun-storage-081809

Kunlun-storage is the storage component for Kunlun distributed DBMS. It's developed based on percona-mysql-8.0.x and contains exclusive features used by Kunlun distributed DBMS, performance enhancements and XA transaction crash safety enhancements without which MySQL would not be able to execute XA transactions reliably.
Other
31 stars 6 forks source link

[feature]kunlun-storage Heartbeat-plugin #2

Closed snowao closed 3 years ago

snowao commented 3 years ago

In some scenarios,a continuous binlog flow is valuable. So,we implement this plugin to generate a heartbeat data every 3 seconds to the zetta_sysdb.

====================================================================== mysql> show create table zetta_sysdb.heartbeat; +-----------+---------------------------------------------------------- | Table | Create Table +-----------+---------------------------------------------------------- | heartbeat | CREATE TABLE heartbeat ( host_port varchar(20) NOT NULL, beat_time varchar(30) DEFAULT NULL, PRIMARY KEY (host_port) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | +-----------+----------------------------------------------------------

mysql> select * from zetta_sysdb.heartbeat; +--------------------+---------------------+ | host_port | beat_time | +--------------------+---------------------+ | 192.168.0.135:8001 | 2021-10-19 16:19:39 | +--------------------+---------------------+ 1 row in set (0.00 sec)

======================================================================

[bugfix]modify the heartbeat timestamp year value.

snowao commented 3 years ago

LGTM