by David Stokes | Aug 2, 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... by David Stokes | 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... by David Stokes | 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... by David Stokes | 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... by David Stokes | 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... by David Stokes | Apr 4, 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... by David Stokes | Mar 1, 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... by David Stokes | 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... by David Stokes | Feb 9, 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... by David Stokes | 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... by David Stokes | 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... by David Stokes | 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... by David Stokes | Dec 8, 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... by David Stokes | Dec 7, 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... by David Stokes | Dec 5, 2022 | Insight for DBAs, MySQL, Percona Software
The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL.The prerequisite for installing Percona’s Audit Log... by David Stokes | Dec 1, 2022 | Insight for DBAs, MySQL, Percona Software
Data masking is a handy tool to obscure sensitive information. Percona Server for MySQL is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation... by David Stokes | Nov 30, 2022 | Database Trends, Insight for DBAs, MySQL
While the LAMP stack – Linux/Apache/MySQL/PHP – is not the dominant platform it was a decade ago, there are still many websites that depend on it. One of the pillars of this quartet had a milestone last week when PHP 8.0 passed into End Of Life status.... by David Stokes | Nov 16, 2022 | Insight for DBAs, PostgreSQL
MERGE was introduced to PostgreSQL in version 15 and it will have a major impact on the way you write queries. This will definitely change the way you can handle transaction logs and other similar updates.Imagine that you have an existing table filled with useful... by David Stokes | Nov 9, 2022 | Insight for Developers, MySQL, Percona Software
MySQL 8.0.31 added INTERSECT and EXCEPT to augment the long-lived UNION operator. That is the good news. The bad news is that you have to be careful using the EXCEPT operator as there is a trick.Let’s start with some simple tables and load some simple data. SQL... by David Stokes | Oct 25, 2022 | Cloud, Insight for DBAs, MySQL
This week is KubeCon in Detroit, and in preparation for attending I have been polishing up my Kubernetes skills. This big rush to put software in containers and have Kubernetes run everything is getting a lot of push in the industry. Many software applications run...