Showing entries 1 to 10 of 43820
10 Older Entries »
Top MySQL Hosting Providers in 2024 for Reliable Database Management

Cloud-based database hosting seems to be an extremely viable solution for modern apps. After all, the entire management-and-maintenance thing is relegated to the hosting provider, scalability is not an issue, and you are free to focus on product development as you see fit.

The post Top MySQL Hosting Providers in 2024 for Reliable Database Management appeared first on Devart Blog.

WePay's Journey to Enhanced Database Performance with MySQL Enterprise Edition

WePay, the integrated payments arm of JPMorgan Chase, has taken significant strides to enhance its database infrastructure by upgrading to MySQL Enterprise Edition. For businesses looking to optimize their payment infrastructure, the journey of WePay serves as an insightful case study on leveraging advanced database solutions for maximum uptime and security.

Tracking Dual Passwords in MySQL

We already have blog posts about Dual Password in MySQL from Brian Sumpter – Using MySQL 8 Dual Passwords, and from Marco Tusa – MySQL Dual Passwords – How To Manage Them Programmatically Let’s skip the details about dual passwords and focus on tracking password usage. How can we be sure that we are using […]

New JSON format for EXPLAIN

MySQL 8.3 introduced a new JSON format for EXPLAIN reflecting how the execution plan actually is built, allowing for programmatic analysis of plans and executions.

Support for large transactions in Galera: Taking Streaming Replication for a spin

We have documented streaming replication, and we have also mentioned how you can use streaming replication, and we also once did a webinar with recording on it, and we wrote a very in-depth blog post on how to use streaming replication to manage large transactions with Galera Cluster.

However, we had a question recently about streaming replication around the usage of wsrep_trx_fragment_unit and wsrep_trx_fragment_size (also, well …

[Read more]
Using the MySQL “SET ROLE” to Enforce “Least Privilege” Principles

How using SET ROLE can be used to define a “Least Privilege” model for accessing database objects based on a user’s current task.

preFOSDEM MySQL Belgian Days 2025 – save the dates

As announced yesterday, the MySQL Devroom is back at FOSDEM! For people preparing for their travel to Belgium, we want to announce that the MySQL Belgian Days fringe event will be held on the Thursday and Friday before FOSDEM. This event will take place on January 30th and 31st, 2025, in Brussels at the usual […]

preFOSDEM MySQL Belgian Days 2025 - save the dates

For people to prepare for their travel to Belgium, we want to announce that the preFOSDEM fringe event known as the MySQL Belgian Days will take place the Thursday and Friday, January 30 and 31, before FOSDEM.

Announcing Vitess 21

Announcing Vitess 21 # We're delighted to announce the release of Vitess 21 along with version 2.14.0 of the Vitess Kubernetes Operator. Version 21 focuses on enhancing query compatibility, improving cluster management, and expanding VReplication capabilities, with experimental support for atomic distributed transactions and recursive CTEs. Key features include reference table materialization, multi-metric throttler support, and enhanced Online DDL functionality. Backup and restore processes benefit from a new mysqlshell engine, while vexplain now offers detailed execution traces and schema analysis.

FLUSH_PRIVILEGES: A new dynamic privilege to execute FLUSH PRIVILEGES

MySQL 8.4 introduces a new privilege, FLUSH_PRIVILEGES, which allows database users to execute FLUSH PRIVILEGES statement without the need of RELOAD privilege.

Showing entries 1 to 10 of 43820
10 Older Entries »