@lefredbe.bsky.socialRDS → EC2: cheaper, sure… but what about performance? 🤔
A real-world story of migrating a 500+ GB production #MariaDB database from AWS RDS to EC2.
Replication, cutover, rollback, performance — and the actual cost impact.
👉 mariadb.org/migrating-a-... #AWS #Database #mariadb #proxysql #luroconnect
@hugovalters.bsky.socialProxySQL monitors MySQL Group Replication via hostgroup rules, no external scripts needed. Auto failover on primary changes.
https://www.valtersit.com/vault/automated-backend-failover-with-group-replication-hostgroup--fe52ce/
#proxysql #group-replication #failover
@hugovalters.bsky.socialZero-downtime DB maintenance with ProxySQL: flip mysql_servers status ONLINE to OFFLINE_SOFT, let existing sessions finish, keep new traffic off https://www.valtersit.com/vault/draining-database-backend-nodes-gracefully-for-zerodowntime--7cf49e/ #mysql #proxysql #maintenance
@hugovalters.bsky.socialProxySQL caches query results at the proxy layer. Set cache_ttl (ms) on a rule, results hash by digest+params, and reads hit memory instead of https://www.valtersit.com/vault/enabling-inmemory-query-result-caching-for-highfrequency-rea-26850e/ #proxysql #caching #performance
@hugovalters.bsky.socialTest production SQL safely: ProxySQL 2.5+ mirrors queries to a shadow hostgroup via mirror_hostgroup rules, responses still served from https://www.valtersit.com/vault/mirroring-production-traffic-to-staging-clusters-using-mirro-9c97a7/ #proxysql #traffic-mirroring #ValtersIT
@hugovalters.bsky.socialSync configs across multiple ProxySQL nodes via the proxysql_servers table and admin interface peer polling. Full guide for Ubuntu 22.04, Debian 12, https://www.valtersit.com/vault/orchestrating-multinode-proxysql-cluster-configuration-synci-31b48e/ #mysql #proxysql #clustering
@hugovalters.bsky.socialProxySQL rewrites SQL in RAM using match_pattern/replace_pattern regex rules in mysql_query_rules before queries hit backends. Zero client changes. https://www.valtersit.com/vault/implementing-realtime-sql-query-rewriting-via-match-and-repl-245c82/ #mysql #proxysql #ValtersIT