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 your feedback and invite PostgreSQL users to test the extension and provide feedback either […]
Oct 02, 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 to perform manually. You can get summaries of your database servers, or you […]
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 find yourself sequestered with rapidly aging software. Before open […]
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. Percona has sponsored this show for many years, provided presenters, and participated in the […]
Sep 06, 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, what is a functional index? Definitions The examples below use MySQL, but it […]
Sep 01, 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 PostgreSQL environment. One of the interesting facets that you need […]
Aug 02, 2023 |
Insight for DBAs, MySQL
The MySQL 5.7 End of Life is now two months away. Those of you who have waited may be wondering which is the best way to upgrade – an In-Place or Logical upgrade. An In-Place upgrade is where the binaries for 5.7 are replaced with the binaries for 8.0, and the upgrade is made to […]
Jul 31, 2023 |
Database Trends, Insight for DBAs, MySQL
Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality. The second […]
Jul 27, 2023 |
Insight for DBAs, MySQL
This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 and 8.1.0 on July 17th, 2023. MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. Many people loved access to the new features even if they could be risky, but others wanted stability and […]
Apr 19, 2023 |
Insight for DBAs, MySQL
MySQL released version 8.0.33 on April 18th, featuring some attention-catching features. This blog post is a quick review of the release notes looking for the exciting items, and comments in italics are solely my own. User-defined collations are now deprecated and will be removed in a future version. This is probably not a show-stopper for […]
Apr 12, 2023 |
Percona Events, Percona Live
Percona Live will be held May 22nd through the 24th in Denver, Colorado. The first day, May 22nd, is devoted to tutorials. These tutorials are intense, high-quality sessions where you can learn new skills. The list below is incomplete and may be re-arranged as schedules change. The instructors are well-known professionals in the open source […]
Apr 04, 2023 |
Insight for DBAs, Insight for Developers, MySQL
MySQL 5.7 reaches End of Life status this October. If you still need to start your migration, time is getting short. The first step for many is looking into the new reserved words in MySQL 8.0. As MySQL gets new functionality or the project matures, there are new additions to the list of reserved words […]
Mar 01, 2023 |
Insight for DBAs, MySQL, Percona Software
Oracle’s MySQL 5.7 has had a good, long run, but the official End of Life is October of 2023. The Era of MySQL 5.x will be over, and only MySQL 8.0 will be officially supported. Yup, six months away. So if you are running MySQL, you need to consider upgrading to version 8.0 N-O-W!! What […]
Feb 13, 2023 |
Insight for DBAs, PostgreSQL
Yes, MySQL DBAs can learn PostgreSQL! This series is for those who know MySQL and want to expand their knowledge, see how another database works, or are looking to expand their career horizons. In this episode we will look at transactions. Yes, MySQL with InnoDB does have the ability to perform transactions and this is […]
Feb 09, 2023 |
Insight for DBAs, Open Source
Welcome to 2023! Now it is time to get your databases ready for the rest of the year. First, how are your backups? You need to ensure that you are backing up all the data. Did someone ‘toss a project over the wall’ that needs to be added to the backup procedure? Or did you […]
Jan 26, 2023 |
Insight for DBAs, MySQL
Most of us are lucky that software bugs are a small part of our lives. The ‘things just work’ attitude works for most situations, but occasionally something appears that may seem trivial at first glance may be catastrophic. A bug appeared in MySQL’s recently released 8.0.32 that really caught my attention. This is a prime […]
Jan 19, 2023 |
Insight for DBAs, MySQL
Recently Oracle released new versions of their software and there are some things of note. MySQL 8.032 is not a major change but you do need to be aware of some changes just in case they have the potential to send you into the court of Murphy’s Law. So let’s look through the release notes […]
Dec 15, 2022 |
Insight for DBAs, MySQL, Open Source, PostgreSQL
JSON data and relational databases have traditionally been diametric opposites. One is very free form with minimal rules on the formatting and the other is very strict and formal. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with […]
Dec 08, 2022 |
Database Trends, Insight for DBAs, Insight for Developers, Percona Events, Percona Live
Percona Live 2023 will be in Denver Colorado May 22nd through the 24th. This is the premier open source database conference and you not only want to attend but you also need to present at! We are seeking talks from all experience levels to share their expertise in either 50-minute or 3-hour tutorials. Topics can […]
Dec 07, 2022 |
Open Source, PostgreSQL
There is an interesting project by the folks at PostgresPro that is translating Egor Rogov’s PostgreSQL 14 Internals into English. This an ongoing project being released as they make progress in providing a great resource to the PostgreSQL Community. Parts I – IV are published and Part V on indexes is on the way. It […]