by Charly Batista | Nov 4, 2022 | Insight for DBAs, Insight for Developers, PostgreSQL
I was recently reading the PostgreSQL 15 release notes and stopped at “Allow unique constraints and indexes to treat NULL values as not distinct”. At first glance, it seems to be a minor change, but this feature may change many designs and make many lives... by Charly Batista | Nov 18, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Welcome to a weekly blog where I get to answer (like, really answer) some of the questions I’ve seen in the webinars I’ve presented lately. If you missed the latest one, PostgreSQL Performance Tuning Secrets, it might be helpful to give some of it a listen... by Charly Batista | Apr 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Apologies for the silly title, but the issue is a real one, even though it is not a new thing. Schema upgrades are not an ordinary operation in Galera. For the subject at hand, the bottom line is: under the default Total Order Isolation (TOI) method, “the... by Charly Batista | Dec 4, 2020 | MySQL, Open Source, Security
Getting MySQL working with self-signed SSL certificates is pretty simple. Having it working with a certificate signed by a trusted authority is also very simple, we just need to set the correct path and privileges to the file. The problem comes when we need to make... by Charly Batista | Jan 10, 2019 | Insight for DBAs, Open Source, PostgreSQL
Recently, one of our customers asked us how to minimize downtime when upgrading the database structure with changes that are not backwards-compatible. It’s an interesting question and I would like to visit some alternatives here. I will use PostgreSQL for this...