The latest from the MySQL community

It’s Thursday afternoon, and a developer has an idea.

Nothing complicated. They are working on a new application feature and want to test an idea before committing to a larger implementation. A quick prototype is already running locally. So far, so good. Next, they want to deploy the application to a shared environment so their colleagues can try it out. The application needs a database too, but it needs to be accessible from the shared environment, not just their laptop. And that’s where things get more complicated.

Now they need to submit a request to the infrastructure team, wait for an environment to be provisioned, or spend the afternoon working through Kubernetes configurations. What should have been a quick experiment becomes another task on somebody else’s backlog.

This is a common problem for engineering teams. Getting a database running in a shared environment shouldn’t require extensive coordination or …

Jonathan Miller has spent 27 years in database performance testing. He talks about TAF, the open source Test Automation Framework that benchmarks MariaDB, MySQL and PostgreSQL side by side, configuration provenance, and how to prove your patch made MariaDB faster.

The Man Who Benchmarks MariaDB Against the World appeared first on MariaDB.org

Building a Database DBA Lab with Docker, PostgreSQL, MySQL, and Percona Monitoring and Management

How I built a local database playground, learned a few lessons the hard way, and created a practical command reference along the way.

Introduction

One of the best ways to learn database administration is to get your hands dirty.

Documentation is important, but there’s something different about building your own environment, breaking it, troubleshooting it, and eventually understanding why everything works.

Recently, I decided to create a local database lab using Docker Desktop on my Mac. My goal was straightforward: build an environment where I could experiment with MySQL, PostgreSQL, Percona XtraDB Cluster (PXC), and Percona Monitoring and Management (PMM), without worrying about disrupting a production environment.

What started as a few containers quickly became a much more …

Learn what data integrity in DBMS means, why it’s vital for database accuracy, and how to maintain it effectively. Read on to protect your data now.

The post Data Integrity in a Database: How to Ensure Accuracy and Security appeared first on Devart Blog.

Hi all,

I’ve just been playing with DBeaver community and have migrated an old postgres schema to mysql with very little hassle.

After this, I’ve looked more into Dbeaver and found the following survey: https://dbeaver.com/2024/05/31/survey-results-shaping-the-future-with-customer-feedback/

Quite interesting!

Especially as one would think that a data migration task is more a DBA task. Good to know!

I also found the following links useful:

dbeaver.com/docs/dbeaver/Data-transfer

No option to dump DB without data #2176

…

Percona has a great set of tools known as the Percona Toolkit, one of which is pt-upgrade. The idea behind this tool is to replay a captured sequence of queries that were executed on a different database server. This is very useful to validate if a new version of the database server works as expected […]

This article examines ANSI SQL, the universal SQL standard that ensures compatibility across databases such as PostgreSQL, Oracle, MySQL, and SQL Server. Learn its history, key features, components, and benefits, and understand how it compares to vendor-specific SQL dialects in building scalable, maintainable, and cross-platform database systems.

The post What Is ANSI SQL and Why You Should Use It  appeared first on Devart Blog.

Index maintenance can be a real challenge for anyone managing databases, and what makes it even trickier is that open source databases each handle it differently. In this post, we’ll take a closer look at how those differences show up in practice, and what they mean for you. When rows are added, updated, or deleted […]

In a previous blog post, we've advertised the use of SQL EXISTS rather than COUNT(*) to check for existence of a value in SQL. I.e. to check if in the Sakila database, actors called WAHLBERG have played in any films, instead of: SELECT count(*) FROM actor a JOIN film_actor fa USING (actor_id) WHERE a.last_name = … Continue reading An Efficient Way to Check for Existence of Multiple Values in SQL →

Introduction In this article, we are going to see how Index Selectivity works in relational database systems and why the database Optimizer might choose to avoid using an index if the number of matching records is large. Index selectivity is inversely proportional to the number of index entries matched by a given value. So, a unique index has the highest selectivity because only a single entry can be matched by any given value. On the other hand, if column values are skewed, then a column value matching a large number of table... Read More

The post Index Selectivity appeared first on Vlad Mihalcea.