by Corrado Pandiani | Nov 2, 2022 | Insight for Developers, MySQL
Are you familiar with the UNION statement for your SQL queries? Most likely, you are. It has been supported for a long time. In case you are not familiar with UNION, don’t worry, I’m going to show you how it works with simple examples. Considering...
by Mario García | Nov 1, 2022 | Insight for DBAs, MySQL, Open Source
For testing purposes, especially if you’re working on a project that uses any database technology to store information, you may need data to try out your project. In that case, you have two options: Find a good dataset (Kaggle) or, Use a library like Faker...
by Vadim Tkachenko | Oct 31, 2022 | Cloud, Insight for DBAs, MySQL
To follow up on my previous Kubernetes articles: Installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation) and Have Percona Server for MySQL running (Using Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL...
by Michael Villegas | Oct 27, 2022 | Insight for DBAs, MySQL, Percona Software
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...
by Vadim Tkachenko | Oct 14, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
As we have Kubernetes installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation) and have Percona Server for MySQL running (Using Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL Operator) lets review how we can...
by Vadim Tkachenko | Oct 13, 2022 | MySQL, Open Source, Percona Software
MySQL is an outstanding database for online transaction processing. With suitable hardware, it is easy to execute more than 1M queries per second and handle tens of thousands of simultaneous connections. Many of the most demanding web applications on the planet are...
by David Stokes | Oct 12, 2022 | Insight for DBAs, Insight for Developers, MySQL
Oracle releases updates to MySQL on a quarterly basis and the Release Notes for 8.0.31 arrived just before the software. This time around there are some very interesting new features that will be handy including SQL standards support, as well as over 130 bug fixes....
by Vadim Tkachenko | Oct 11, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
As we have Kubernetes installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation), now we will install Percona Server for MySQL Operator into the running cluster. I will copy some ideas from Peter’s Minukube tutorial (see Exploring...
by Mauricio Cacho | Oct 5, 2022 | Insight for DBAs, Insight for Developers, MySQL
A few weeks back, we faced an issue in a replication environment for a Managed Services client: LAST_ERROR_MESSAGE: Worker 2 failed executing transaction ‘UUID:GTID’ at master binlog.0012345, end_log_pos 98765; Error ‘Operation CREATE USER failed for...
by David Stokes | Oct 4, 2022 | Insight for DBAs, MySQL
If you watched Finding Poorly Designed Schemas and How to Fix Them you witnessed Marcos Albe use some very interesting queries. These queries let you find tables without primary keys, tables with non-integer primary keys, tables that do not use InnoDB, tables and...
by Matthew Boehm | Sep 27, 2022 | Insight for DBAs, MySQL
Geo locations are a cornerstone of modern applications. Whether you’re a food delivery business or a family photographer, knowing the closest “something” to you or your clients can be a great feature. In our ‘Scaling and Optimization’...
by Daniel Guzmán Burgos | Sep 26, 2022 | Cloud, MySQL, Percona Software
The microservice architecture is not a new pattern but has become very popular lately for mainly two reasons: cloud computing and containers. That combo helped increase adoption by tackling the two main concerns on every infrastructure: Cost reduction and...
by Vadim Tkachenko | Sep 23, 2022 | Insight for DBAs, Insight for Developers, MySQL
When you develop an application you expect success, and often success comes with growth problems. These problems especially show themselves in the area of data storage, where being stateful is not as easy to scale as the stateless parts of the application. There are...
by Vadim Tkachenko | Sep 20, 2022 | Cloud, MySQL, Percona Software
We are looking to provide simplified ways to deploy Percona software in cloud environments, especially for more advanced scenarios like replication and multi-node cluster (in the case of Percona XtraDB Cluster). For this I propose trying out our new Terraform...
by Mike Benshoof | Sep 20, 2022 | Insight for DBAs, MySQL, Percona Software, Security
In a post written earlier this year – Percona Server for MySQL Encryption Options and Choices – I discussed some of the options around encryption in MySQL. Being such a complex topic, that post was meant to clarify and highlight various aspects of “encryption” at...
by Arunjith Aravindan | Sep 15, 2022 | Cloud, MySQL, Percona Software
This article outlines the basic configurations for setting up and deploying Percona XtraDB Cluster 8.0 (PXC) on Amazon EC2, as well as what is new in the setup compared to Percona XtraDB Cluster 5.7. What is Percona XtraDB Cluster an ideal fit for? Percona XtraDB...
by David Stokes | Sep 13, 2022 | Insight for DBAs, MySQL, PostgreSQL
First, a big thanks for the kind responses to this series, and, as requested, here is an overview of index types available in PostgreSQL. The supporting video with bonus material can be found here. PostgreSQL has several popular index types including B-tree, Hash,...
by Peter Zaitsev | Sep 8, 2022 | Insight for DBAs, Monitoring, MySQL, Percona Software
In my previous blog post, ProcFS UDF: A Different Approach to Agentless Operating System Observability in Your Database, I wrote about the ProcFS UDF MySQL plugin, which allows you to get operating systems stats, through the MySQL database, without having shell access...
by Kedar Vaijanapurkar | Sep 7, 2022 | Insight for DBAs, MySQL
A large table is a pain for many reasons as long as it is in a system. And as if that’s not enough, it is also a difficult task to get rid of it. In this post, we will understand why it is a pain to do this operation and what we can do about it. It will be like...
