[Percona Community Forum] Summary
A brief summary since 2026-11-09 02:54:51 UTC
- Product
- Percona
- Sent from
- percona1.discoursemail.com
- Sent
No dark-mode styles — this email renders the same in a dark client.
A brief summary of [Percona Community Forum][1] since 2026-11-09 02:54:51 UTC
3 New Topics
16 New Users
### Popular Topics
[Running MySQL for Canadian clients: keeping data, binlogs and backups in Canada][2]
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...
[Well this looks like a job for me: My first weeks at Percona | Percona Community][3]
After a looong break, I’m back in open source. I have officially joined Percona - the open-source database experts. And I jumped in headfirst: straight to PGConf.EU to cover it.
This is a companion discussion topic for the original entry at https://percona.community/blog/2026/11/13/well-this-looks-like-a-job-for-me/
[PostgreSQL restores: preserve ownership and grants, or remap … | Percona Community][4]
A PostgreSQL restore can recover every row and still leave the application unable to insert the next one. To understand why, we need to look at ownership, table permissions and sequence permissions separately. Default privileges add a further question: who will create the next table?
This is a companion discussion topic for the original entry at https://percona.community/blog/2026/11/12/postgresql-restore-ownership-acls-default-privileges/
[1]: https://forums.percona.com/
[2]: https://forums.percona.com/t/running-mysql-for-canadian-clients-keeping-data-binlogs-and-backups-in-canada/41429
[3]: https://forums.percona.com/t/well-this-looks-like-a-job-for-me-my-first-weeks-at-percona-percona-community/41434
[4]: https://forums.percona.com/t/postgresql-restores-preserve-ownership-and-grants-or-remap-percona-community/41427
[5]: https://forums.percona.com/
This summary is sent from [Percona Community Forum][5] when we haven't seen you in a while. Change [your email settings][6], or [click here][7] to unsubscribe.
[6]: https://forums.percona.com/my/preferences/emails
[7]: https://forums.percona.com/email/unsubscribe/e241727e0d6e3fba48cc40552919000a0e5176d78eb37cff42d1cbca889c6d62- Accession
- nse/percona/2026-11-16/7041
- From
- Percona Community Forum · notifications@percona1.discoursemail.com
- Sent
- 16 November 2026 · 02:00 UTC











