Running MySQL for Canadian clients: keeping data, binlogs and backups in Canada

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:

  1. Replicas and failover nodes. A replica in another country breaks the promise, so every replica and standby sits in a Canadian data centre too.
  2. Binary logs and relay logs. They hold real row data, so I check where they live and how long they’re kept.
  3. Backups. XtraBackup or mysqldump files often land in object storage by default, so I confirm the bucket region and any cross-region copy settings.
  4. Monitoring and query analytics. Slow query logs and sampled queries can include customer data, so the monitoring server should be in Canada as well.
  5. Encryption. TLS for client and replication traffic, and encryption at rest for data files and backups.
  6. Restore tests. A backup that never gets restored is a guess, so I test restores on a Canadian host every quarter.
  7. 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?

Hello @4GoodHosting,
All of those are very good. What about the application itself? Making sure app servers are also in Canada. Any remote users in another country accessing the web/app servers, and accessing data? Make sure that is logged too in case there’s potential for data scrapes.