Thu, 02 May 2024 18:09:33 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/mysql-8-4-first-peek/ https://www.percona.com/blog/mysql-8-4-first-peek/#respond Wed, 01 May 2024 13:13:29 +0000 https://www.percona.com/blog/?p=96106 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 hair-pulling and swearing among those affected. Please note this is a […]]]> https://www.percona.com/blog/mysql-8-4-first-peek/feed/ 0 96106 https://www.percona.com/blog/json_table-will-be-in-postgresql-17/ https://www.percona.com/blog/json_table-will-be-in-postgresql-17/#respond Thu, 11 Apr 2024 15:11:37 +0000 https://www.percona.com/blog/?p=95673 JSON_TABLE() will be in PostgreSQL 17! It almost made it two years ago but was yanked away at the last minute. We will get it shortly when PostgreSQL 17 is officially released this year! Please see this.Why is this important?JSON has become the data interchange format of choice for most developers. JSON had a litany […]]]> https://www.percona.com/blog/json_table-will-be-in-postgresql-17/feed/ 0 95673 https://www.percona.com/blog/postgresql-for-mysql-dbas-second-edition-is-now-available/ https://www.percona.com/blog/postgresql-for-mysql-dbas-second-edition-is-now-available/#respond Tue, 02 Apr 2024 17:24:16 +0000 https://www.percona.com/blog/?p=95539 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 PostgreSQL DBA. Years later, that same sentiment is still […]]]> https://www.percona.com/blog/postgresql-for-mysql-dbas-second-edition-is-now-available/feed/ 0 95539 https://www.percona.com/blog/percona-pg_tde-project-keyring-options/ https://www.percona.com/blog/percona-pg_tde-project-keyring-options/#respond Mon, 01 Apr 2024 13:17:52 +0000 https://www.percona.com/blog/?p=95492 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 on a keyring.Two keysEncrypting the data requires two types of keys.The first […]]]> https://www.percona.com/blog/percona-pg_tde-project-keyring-options/feed/ 0 95492 https://www.percona.com/blog/percona-postgresql-pg_tde-extension-march-update/ https://www.percona.com/blog/percona-postgresql-pg_tde-extension-march-update/#respond Thu, 28 Mar 2024 14:41:58 +0000 https://www.percona.com/blog/?p=95442 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.DocumentationThe pg_tde documentation is here. You will find many options for obtaining pg_tde – Docker images, RPM, DEB, and source code.What pg_tde […]]]> https://www.percona.com/blog/percona-postgresql-pg_tde-extension-march-update/feed/ 0 95442 https://www.percona.com/blog/why-your-next-mysql-database-should-not-be-a-mysql-database/ https://www.percona.com/blog/why-your-next-mysql-database-should-not-be-a-mysql-database/#respond Tue, 26 Mar 2024 13:03:45 +0000 https://www.percona.com/blog/?p=95362 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 EditionsTraditionally, the MySQL Community Edition has been a mainstay in the open source community for decades, and it is available for free. Originally, MariaDB was a […]]]> https://www.percona.com/blog/why-your-next-mysql-database-should-not-be-a-mysql-database/feed/ 0 95362 https://www.percona.com/blog/are-your-mysql-users-using-password-or-thebossisajerk-as-passwords/ https://www.percona.com/blog/are-your-mysql-users-using-password-or-thebossisajerk-as-passwords/#respond Tue, 06 Feb 2024 14:17:08 +0000 https://www.percona.com/blog/?p=94102 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 used. The first step is to compile a list of words and phrases you want to exclude, and that […]]]> https://www.percona.com/blog/are-your-mysql-users-using-password-or-thebossisajerk-as-passwords/feed/ 0 94102 https://www.percona.com/blog/mysql-or-postgresql-which-is-better/ https://www.percona.com/blog/mysql-or-postgresql-which-is-better/#respond Thu, 01 Feb 2024 10:00:21 +0000 https://www.percona.com/blog/?p=88894 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 have to ask them what they want to do and how […]]]> https://www.percona.com/blog/mysql-or-postgresql-which-is-better/feed/ 0 88894 https://www.percona.com/blog/pg_tde-update-perconas-project-to-add-transparent-data-encryption-to-postgresql/ https://www.percona.com/blog/pg_tde-update-perconas-project-to-add-transparent-data-encryption-to-postgresql/#respond Tue, 30 Jan 2024 17:40:06 +0000 https://www.percona.com/blog/?p=93659 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 communication, we would appreciate your feedback and invite PostgreSQL users to […]]]> https://www.percona.com/blog/pg_tde-update-perconas-project-to-add-transparent-data-encryption-to-postgresql/feed/ 0 93659 https://www.percona.com/blog/percona-pg_tde-and-ubuntu-please-test-transparent-data-encryption-for-postgresql/ https://www.percona.com/blog/percona-pg_tde-and-ubuntu-please-test-transparent-data-encryption-for-postgresql/#respond Mon, 29 Jan 2024 14:52:39 +0000 https://www.percona.com/blog/?p=93654 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 under development, and we are seeking your assistance in testing it.This blog […]]]> https://www.percona.com/blog/percona-pg_tde-and-ubuntu-please-test-transparent-data-encryption-for-postgresql/feed/ 0 93654 https://www.percona.com/blog/percona-pg_tde-and-docker-please-test-transparent-data-encryption-for-postgresql/ https://www.percona.com/blog/percona-pg_tde-and-docker-please-test-transparent-data-encryption-for-postgresql/#respond Fri, 26 Jan 2024 13:48:39 +0000 https://www.percona.com/blog/?p=93656 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 development, and we need your help testing it.This blog will cover what you […]]]> https://www.percona.com/blog/percona-pg_tde-and-docker-please-test-transparent-data-encryption-for-postgresql/feed/ 0 93656 https://www.percona.com/blog/quick-peek-mysql-8-0-36-and-8-3/ https://www.percona.com/blog/quick-peek-mysql-8-0-36-and-8-3/#respond Wed, 17 Jan 2024 13:58:05 +0000 https://www.percona.com/blog/?p=93492 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 not reflect the view of anyone […]]]> https://www.percona.com/blog/quick-peek-mysql-8-0-36-and-8-3/feed/ 0 93492 https://www.percona.com/blog/book-review-postgresql-14-internals-by-egor-rogov/ https://www.percona.com/blog/book-review-postgresql-14-internals-by-egor-rogov/#respond Tue, 07 Nov 2023 14:40:28 +0000 https://www.percona.com/blog/?p=89780 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 data organization to details on the many available indexing options.  This book has five major sections on MVCC and Isolation […]]]> https://www.percona.com/blog/book-review-postgresql-14-internals-by-egor-rogov/feed/ 0 89780 https://www.percona.com/blog/quick-peek-mysql-8-2-and-8-0-35/ https://www.percona.com/blog/quick-peek-mysql-8-2-and-8-0-35/#comments Mon, 06 Nov 2023 16:25:03 +0000 https://www.percona.com/blog/?p=91937 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 long-accepted behavior, including wildcards, will change eventually.We get 83 […]]]> https://www.percona.com/blog/quick-peek-mysql-8-2-and-8-0-35/feed/ 1 91937 https://www.percona.com/blog/adding-transparent-data-encryption-to-postgresql-with-pg_tde-please-test/ https://www.percona.com/blog/adding-transparent-data-encryption-to-postgresql-with-pg_tde-please-test/#respond Mon, 16 Oct 2023 13:33:58 +0000 https://www.percona.com/blog/?p=91691 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 your feedback and invite PostgreSQL users to test the extension and provide feedback either […]]]> https://www.percona.com/blog/adding-transparent-data-encryption-to-postgresql-with-pg_tde-please-test/feed/ 0 91691 https://www.percona.com/blog/percona-toolkit-a-quick-introduction-to-summary/ https://www.percona.com/blog/percona-toolkit-a-quick-introduction-to-summary/#comments Mon, 02 Oct 2023 14:04:18 +0000 https://www.percona.com/blog/?p=91186 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 to perform manually.You can get summaries of your database servers, or you verify […]]]> https://www.percona.com/blog/percona-toolkit-a-quick-introduction-to-summary/feed/ 1 91186 https://www.percona.com/blog/you-need-to-actively-support-open-source-software-or-it-will-disappear/ https://www.percona.com/blog/you-need-to-actively-support-open-source-software-or-it-will-disappear/#respond Fri, 22 Sep 2023 13:41:28 +0000 https://www.percona.com/blog/?p=91034 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 find yourself sequestered with rapidly aging software.Before open source […]]]> https://www.percona.com/blog/you-need-to-actively-support-open-source-software-or-it-will-disappear/feed/ 0 91034 https://www.percona.com/blog/why-you-need-to-be-at-the-southern-california-linux-expo/ https://www.percona.com/blog/why-you-need-to-be-at-the-southern-california-linux-expo/#respond Thu, 21 Sep 2023 13:08:37 +0000 https://www.percona.com/blog/?p=91030 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. Percona has sponsored this show for many years, provided presenters, and participated in the […]]]> https://www.percona.com/blog/why-you-need-to-be-at-the-southern-california-linux-expo/feed/ 0 91030 https://www.percona.com/blog/putting-the-fun-in-mysql-functional-indexes/ https://www.percona.com/blog/putting-the-fun-in-mysql-functional-indexes/#respond Wed, 06 Sep 2023 12:59:22 +0000 https://www.percona.com/blog/?p=90587 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, what is a functional index?DefinitionsThe examples below use MySQL, but it is helpful to […]]]> https://www.percona.com/blog/putting-the-fun-in-mysql-functional-indexes/feed/ 0 90587 https://www.percona.com/blog/postgresql-for-mysql-dbas-episode-13-inheritance/ https://www.percona.com/blog/postgresql-for-mysql-dbas-episode-13-inheritance/#respond Fri, 01 Sep 2023 12:23:54 +0000 https://www.percona.com/blog/?p=90337 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 PostgreSQL environment.One of the interesting facets that you need to […]]]> https://www.percona.com/blog/postgresql-for-mysql-dbas-episode-13-inheritance/feed/ 0 90337