Showing entries 1 to 10 of 21936
10 Older Entries »
Displaying posts with tag: MySQL (reset)
Champs Recap: Devart’s Award-Winning Products in Q1 2024

Last season was quite fruitful in terms of awards scored by our products on independent review platforms. And today, we've got a lot more of those to share. Without further ado, let's get started!

The post Champs Recap: Devart’s Award-Winning Products in Q1 2024 appeared first on Devart Blog.

Percona XtraBackup 8.0.28 Supports Encrypted Table Backups with AWS KMS

Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL.In this blog post, we will discuss how […]

Percona Operator for MySQL Now Supports Automated Volume Expansion in Technical Preview

Volume Expansion, a feature that became generally available since Kubernetes version 1.24, allows users to increase the capacity of their Persistent Volumes and underlying storage within Kubernetes. There is no need to use clouds’ UI or APIs to do that anymore. In our Operators, we use Stateful Sets – a Kubernetes resource that was designed for […]

Announcing Vitess 19

Announcing Vitess 19 # We're thrilled to announce the release of Vitess 19, our latest version packed with enhancements aimed at improving scalability, performance, and usability of your database systems. With this release, we continue our commitment to providing a powerful, scalable, and reliable database clustering solution for MySQL. What's New in Vitess 19 # Dropping Support for MySQL 5.7: As Oracle has marked MySQL 5.7 end of life in October 2023, we're also moving forward by dropping support for MySQL 5.

Help Us Improve MySQL Usability and Double Win!

What makes a great user experience? There are probably as many answers to this question as there are users because we are talking about very subjective and personal feelings and observations.While there are multiple experts at Percona, we also believe that one should not be forced to become a database expert to be able to […]

What’s New in MySQL 8.3: Feature Overview

The latest version of MySQL Server, 8.3, has been available as a General Availability (GA) release for a while. In case you have missed it, here is a brief recap of the newly available features and enhancements.

The post What’s New in MySQL 8.3: Feature Overview appeared first on Devart Blog.

MySQL install ‘n’ config one-liners

Back again, now with MySQL installs. And this means using the MySQL repository this time around.

I’ve been installing and configuring InnoDB Clusters and ClusterSets and thinking about the Ansible and Terraform users amongst us, maybe one-liners might help someone out there.

So, what about if I share how to install the MySQL repo, install the MySQL instance, create an InnoDB Cluster, add a MySQL Router, create a ClusterSet, make sure the Router is ClusterSet-aware, and then test it out. And all via one-liners.

First up, obrigado Miguel for https://github.com/miguelaraujo/ClusterSet-Demo.

To simplify the command execution sequence, these sections aim to help summarize the technical commands required to create the whole platform. And on a default path & port configuration, to ease operational deployments for all those 000’s of …

[Read more]
How to Change a Column Type in MySQL

This article will walk you through the essentials of MySQL, shedding light on the intricacies of column types, and explore scenarios where altering column types becomes a necessity, exemplified through the lens of dbForge Studio for MySQL.

The post How to Change a Column Type in MySQL appeared first on Devart Blog.

How to avoid data loss in MySQL Primary Key change

Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.

The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable.

Parametric Queries

In 2021, I wrote a MySQL example for my class on the usefulness of Common Table Expressions (CTEs). When discussing the original post, I would comment on how you could extend the last example to build a parametric reporting table.

Somebody finally asked for a concrete example. So, this explains how to build a sample MySQL parametric query by leveraging a filter cross join and tests the parameter use with a Python script.

You can build this in any database you prefer but I used a studentdb database with the sakila sample database installed. I’ve granted privileges to both databases to the student user. The following SQL is required for the example:

-- Conditionally drop the levels table.
DROP TABLE IF EXISTS levels;
 
-- Create the levels list.
CREATE TABLE levels
( level_id       int unsigned primary key auto_increment
, …
[Read more]
Showing entries 1 to 10 of 21936
10 Older Entries »