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.
10 Older Entries »
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]
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.
Primary keys are the backbone of efficient data access and maintaining data consistency in your MySQL databases. However, altering them requires careful planning and execution, as incorrect procedures can lead…
The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable.
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]
This exclusive webinar is tailored for database administrators and IT professionals aiming to enhance their systems’ efficiency and reliability using Galera Cluster. This session focuses on practical best practices, showcases new features, and provides an extended platform for your queries.
What You Will Learn:
* Core Best Practices: Dive into essential practices, from employing primary keys and leveraging InnoDB to deciding if to optimise read/write splits and managing AUTO_INCREMENT settings.
* Advanced Configuration: Uncover advanced techniques for error monitoring, configuring Galera across networks, and fine-tuning the gcache for optimal performance. * Innovative Features: Stay ahead with insights on implementing Non-Blocking Operations for seamless schema changes, coordinating distributed …[Read more]
MySQL Plugin has been extensively used with MySQL. It is being evolved into COMPONENT deployment. This article is written to share the steps with MySQL Keyring Component Installation.
MySQL Enterprise Edition includes encrypted file component for Keyring. This provides a more secure way to store the master key with TDE.
Installation of component with keyring has to be static rather than running SQL command "INSTALL COMPONENT". There are 2 scopes with component installation.
Global vs Local
With Global component installation, the configuration is located with the MySQL installation folder.
With Local component installation, the global configuration is referenced to locate the local configuration from the Datadir.
Assuming the installation is with the package and …[Read more]
Teachers workshop HK, Feb 2024
Oracle offers a variety of SKDs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to list the backups of MySQL HeatWave instances in a given compartment.
If you use MySQL Shell for Visual Studio Code, using a bastion host is the easiest method to connect to a MySQL HeatWave DB Instance on OCI.
If you already have a connection setup using a bastion to host, you may experience the same problem as me, MySQL Shell complains about an invalid fingerprint detected:
This error has nothing to do with the fingerprint of your user OCI Key. The problem is related to the key of your bastion host as you can see in the output window:
This happens if you have changed your bastion host for example.
To resolve the problem, remove the current ssh host key for the
bastion host stored in your
$ ssh-keygen -R "host.bastion.us-ashburn-1.oci.oraclecloud.com"
Use the name of your bastion host of course.
When done, it’s already fixed, you can connect back to your MySQL HeatWave DB Instance using MySQL Shell …[Read more]
10 Older Entries »