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), […]
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Quick Tour of MySQL HeatWave on AWS
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 InnoDB ReplicaSet/Cluster/ClusterSet & MySQL Shell 8.0.33
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.
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 […]
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]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!
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]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.