Local AI for DevOps: OpenCode, Ollama and an AWS EKS Experiment
Local AI DevOps in a Proxmox VM: OpenCode, Ollama and Qwen2.5-Coder for AWS EKS, Terraform and GitOps, with IAM setup and security boundaries.
root@0root:~# cat blog.conf
0ROOT Blog
Real infrastructure cases, failures, fixes and lessons from production.
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.
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.
MySQL DELETE removed millions of rows, but the .ibd file didn't shrink
We cleaned millions of old rows from a large MySQL table. The data was gone, but the disk space wasn't. OPTIMIZE TABLE returned about 200 GB to the filesystem.