You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Difference between revisions of "MariaDB/pt-heartbeat"

From Wikitech-static
Jump to navigation Jump to search
imported>LSobanski
imported>LSobanski
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
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 (except for multi-instance hosts). A process on the source server writes a timestamped row to the heartbeat table every second. A process on a 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 [[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}}
[[Category:MariaDB]]

Latest revision as of 10:12, 21 June 2021

pt-heartbeat is a service running on MariaDB servers (except for multi-instance hosts). A process on the source server writes a timestamped row to the heartbeat table every second. A process on a 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)