by David Stokes | May 1, 2024 | Insight for DBAs, MySQL
MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing... by David Stokes | Apr 11, 2024 | Insight for DBAs, PostgreSQL
by David Stokes | Apr 2, 2024 | Insight for DBAs, PostgreSQL
Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers looking for talent. One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified... by David Stokes | Apr 1, 2024 | Percona Software, PostgreSQL, Security
Percona’s pg_tde project brings a long-needed ability to encrypt data to PostgreSQL transparently. We are actively asking you to test this code to help build a better project. So please test pg_tde!As you have probably read in earlier blogs on pg_tde, it depends... by David Stokes | Mar 28, 2024 | Open Source, Percona Software, PostgreSQL
Transparent Data Encryption is one ‘missing item’ in comparing PostgreSQL to commercial databases. Percona’s pg_tde project will correct this shortcoming. Progress is ongoing, and Percona would love your feedback, so please download and test.... by David Stokes | Mar 26, 2024 | MySQL, Open Source, Percona Software
MySQL is a very popular database and a good choice for new projects. But is it the best choice?Luckily you have several options for this choice. MySQL Community vs. Enterprise Editions Traditionally, the MySQL Community Edition has been a mainstay in the open source... by David Stokes | Feb 6, 2024 | Insight for DBAs, MySQL, Security
Are your MySQL users using ‘password’, ‘s3cr3t’, or ‘thebossisajerk’ as their passwords? Easy-to-guess passwords can be disastrous to the security of your data, but there is a way to exclude inappropriate words or phrases from being... by David Stokes | Feb 1, 2024 | Database Trends, Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in June of 2023 and updated in February of 2024.For more than a quarter of a century, people have been discussing “Which is better, MySQL vs. PostgreSQL?” — with no resolution. When people ask me which is better, I... by David Stokes | Jan 30, 2024 | Open Source, Percona Software, PostgreSQL
PG_TDE is an experimental transparent data encryption access method for PostgreSQL 16 and beyond that I reviewed last October. There have been a lot of changes that covered in this post. This software is under active development. In the spirit of open and transparent... by David Stokes | Jan 29, 2024 | Open Source, Percona Software, PostgreSQL
PostgreSQL differs from certain other databases as it lacks a native solution to encrypt data on disk transparently. At Percona, we are in the process of developing PG_TDE, a tool designed to encrypt data using the AES-CTR encryption algorithm. This code is currently... by David Stokes | Jan 26, 2024 | Open Source, Percona Software, PostgreSQL
Securing your data can be a tough task. Unlike some other databases, PostgreSQL does not have a native solution to encrypt data on disk transparently. Percona is developing PG_TDE to encrypt that data using the AES-CTR encryption algorithm. This code is in... by David Stokes | Jan 17, 2024 | Insight for DBAs, MySQL
Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what is new, what is in the seventy-three bugs fixed, and what has changed in the three months since the last releases. Comments in italics are my own and do... by David Stokes | Nov 7, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
The book PostgreSQL 14 Internals has been available in PDF format for quite a while, but recently, the ability to order a printed copy became available (https://postgrespro.com/community/books/internals).This 548-page tome from PostgresPro covers the spectrum from... by David Stokes | Nov 6, 2023 | Insight for DBAs, Insight for Developers, MySQL
Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. This blog post is a quick look at the release notes to see what these new versions bring to the community. You’ll want to keep an eye on the deprecations in particular because some... by David Stokes | Oct 16, 2023 | Open Source, Percona Software, PostgreSQL
PG_TDE is an experimental transparent data encryption access method for PostgreSQL 16 and beyond. This software is under active development and at a very early stage of design and implementation. In the spirit of open and transparent communication, we would appreciate... by David Stokes | Oct 2, 2023 | Insight for DBAs, Percona Software
Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex... by David Stokes | Sep 22, 2023 | Insight for DBAs, Insight for Developers, Open Source
Percona is dedicated to open source software. But recently, open source software has come under attack. Once open source software is being locked away by changing licenses and code that you depended on. You either get to pay for the privilege of having less freedom or... by David Stokes | Sep 21, 2023 | Insight for DBAs, Insight for Developers, Open Source
You can show your support for open source software by participating in an event next March in Pasadena, California – The Southern California Linux Expo, or SCaLE. SCaLE is the largest community-run open source and free software conference in North America.... by David Stokes | Sep 6, 2023 | Insight for DBAs, MySQL
Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. You may also hear this type of index being called Index on expression.So,... by David Stokes | Sep 1, 2023 | Insight for DBAs, MySQL, PostgreSQL
MySQL users can easily be confused by the seemingly infinite differences between MySQL and PostgreSQL. The good news is that for someone familiar with MySQL, they have the basics of databases covered and can explore some of the treasures to be discovered in the new...