I manage MySQL databases for a few Canadian clients who now ask that their data stays in Canada, mostly because of PIPEDA and provincial rules in BC and Quebec. Picking a Canadian region for the primary server is the easy part. These are the things I check beyond that:
- Replicas and failover nodes. A replica in another country breaks the promise, so every replica and standby sits in a Canadian data centre too.
- Binary logs and relay logs. They hold real row data, so I check where they live and how long they’re kept.
- Backups. XtraBackup or mysqldump files often land in object storage by default, so I confirm the bucket region and any cross-region copy settings.
- Monitoring and query analytics. Slow query logs and sampled queries can include customer data, so the monitoring server should be in Canada as well.
- Encryption. TLS for client and replication traffic, and encryption at rest for data files and backups.
- Restore tests. A backup that never gets restored is a guess, so I test restores on a Canadian host every quarter.
- Support access. I write down who can reach the servers and from which countries.
What else do you check when a client needs MySQL data kept inside one country?