Secure PXC backups: pull from a separate server, restrict SSH and test restores
A production backup pattern for PXC: a separate backup server pulls data through a restricted SSH key, with monitoring and restore validation.
root@0root:~# find /blog -tag "pxc"
#Pxc
Articles tagged with Pxc.
Monitoring PXC from outside the cluster: Prometheus, alerts and failure detection
A practical monitoring design for Percona XtraDB Cluster: external Prometheus, node and MySQL exporters, wsrep alerts and backup monitoring.
Building a highly available MySQL layer with PXC, ProxySQL and Keepalived
A production case: three PXC nodes, three ProxySQL instances, a floating VIP, single-writer routing and balanced SELECT traffic.