Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 2096 to 2105 of 45533 « Previous | Next »
Quick Tour of MySQL HeatWave on AWS

Quick Tour of MySQL HeatWave on AWS   MySQL HeatWave on AWS is a fully managed MySQL database service running on Amazon Web Services (AWS). It is built on the Enterprise Edition of the MySQL Database and is the only MySQL service with a scalable, integrated, real-time query accelerator with machine learning-based automation (MySQL Autopilot), […]

Quick Tour of MySQL HeatWave on AWS

Quick Tour of MySQL HeatWave on AWS

Announcing MySQL Server 8.0.33

On April 18 2023, MySQL Server 8.0.33 was released. It is the latest release of our MySQL 8.0 General Availability Release. The new release introduces a few new features alongside with some deprecations, as well as bugfixes and security fixes. New MySQL Enterprise Edition Data Masking Component MySQL Enterprise Edition now provides data masking and de-identification capabilities […]

Announcing MySQL Server 8.0.33

Announcing MySQL Server 8.0.33

Announcing MySQL InnoDB ReplicaSet/Cluster/ClusterSet & MySQL Shell 8.0.33

Announcing MySQL InnoDB ReplicaSet/Cluster/ClusterSet & MySQL Shell 8.0.33

Connecting to a MySQL HeatWave Database Instance Using OpenVPN

When you provision a MySQL HeatWave database instance, you can only connect to the database from services inside of OCI. Using an OpenVPN running on an OCI Compute instance we can connect to a MySQL HeatWave instance from clients outside of OCI. In this post, we'll show you how to do this.

Connecting to a MySQL HeatWave Database Instance Using OpenVPN

MySQL HeatWave Database is a fully managed service on Oracle Cloud Infrastructure (OCI) that is developed, managed, and supported by the MySQL team at Oracle. When you provision a new MySQL instance under OCI, you can only connect to the database from inside the OCI network. While this is a great security feature for production services hosted in […]

How to Persist a Hashed Format Password Inside ProxySQL

In this blog post, we will see how to persist the password inside the ProxySQL mysql_users table in hashed format only. Also, even if someone stored the password in cleartext, we see how to change those into the hashed format easily.

Here we are just highlighting one of the scenarios during work on the client environment where we noticed that the ProxySQL mysql_users table had more than 100 user entries, but some of them were available/inserted into the clear text password, whereas some were inserted properly into hashed entries.

Before just explaining those simple commands that were used to fix those clear text entries into the hashed entry quickly, let’s see some more information about the ProxySQL mysql_users table and the password formats.

Password formats inside ProxySQL

ProxySQL is capable of storing passwords in two different formats within the mysql_users.password …

[Read more]
OpenLampTech issue #75 – Substack Repost

I’m learning so much each week from just running the OpenLampTech developer newsletter to reading the great content shared within. There is always something to learn and I am thankful for your reading each week.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

If you are not yet subscribed, head on over and grab a free subscription and get the weekly OpenLampTech publication delivered straight to your inbox.

In OpenLampTech issue #75, we are looking at …

[Read more]
schemadiff: Vitess In-memory Schema Diffing, Normalization, Validation and Manipulation

Introducing schemadiff, an internal library in Vitess that has been one of its best-kept secrets until now. At its core, schemadiff is a declarative, programmatic library that can produce a diff in SQL format of two entities: tables, views, or full blown database schemas. But it then goes beyond that to normalize, validate, export, and even apply schema changes, all declaratively and without having to use a MySQL server. Let's dive in to understand its functionality and capabilities.