Difference between revisions of "MariaDB/pt-heartbeat"

From Wikitech-static
Jump to navigation Jump to search
imported>LSobanski
 
imported>LSobanski
Line 1: Line 1:
{{Warning|content=Work in progress}}
pt-heartbeat is a service running on [[MariaDB]] servers. A process on the source server writes a timestamped row to the heartbeat table every second. A process on the replica compares the most recent entry in the table to the host clock to evaluate the replication lag. MediaWiki load-balancer will avoid replicas that don't have an up-to-date heartbeat entry.
 
pt-heartbeat is a service running on [[MariaDB]] servers. It writes a timestamped row to the heartbeat table on the primary server every second. On the replicas the most recent entry in the table is compared to the real time clock to evaluate the replication lag. MediaWiki load-balancer will avoid replicas that don't have an up-to-date heartbeat entry.


The [[https://www.percona.com/doc/percona-toolkit/LATEST/pt-heartbeat.html upstream version]] is developed by Percona, we use a modified version (pt-heartbeat-wikimedia).
The [[https://www.percona.com/doc/percona-toolkit/LATEST/pt-heartbeat.html upstream version]] is developed by Percona, we use a modified version (pt-heartbeat-wikimedia).


{{SRE/Data Persistence/Footer}}
{{SRE/Data Persistence/Footer}}

Revision as of 12:34, 3 June 2021

pt-heartbeat is a service running on MariaDB servers. A process on the source server writes a timestamped row to the heartbeat table every second. A process on the replica compares the most recent entry in the table to the host clock to evaluate the replication lag. MediaWiki load-balancer will avoid replicas that don't have an up-to-date heartbeat entry.

The [upstream version] is developed by Percona, we use a modified version (pt-heartbeat-wikimedia).



This page is a part of the SRE Data Persistence technical documentation
(go here for a list of all our pages)