Oracle MySQL Group    The Oracle Cloud Infrastructure OCI command line interface CLI allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a read replica of a MySQL HeatWave instance.

Oracle MySQL Group    MySQL Meetups EMEA in April

Oracle MySQL Group    The Oracle Cloud Infrastructure OCI command line interface CLI allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a backup of a MySQl HeatWave instance and then restore that back up to a new HeatWave instance.

Oracle MySQL Group    OSC Japan recap

PlanetScale    Learn how to visualize the memory usage of a MySQL connection

Jean-François Gagné    Yes, this is a catchy title, but it is true, and it got you reading this post : . amp;nbsp; Another title could have been Please load this mysql dump: what could go wrong amp;nbsp; . amp;nbsp; As you guessed, loading a dump is not a risk free operation. amp;nbsp; In this post, I explain how the...

MySQL Performance Blog    It’s a common scenario to have a Percona Monitoring and Management PMM server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The Ingress NGINX Controller is one of the most popular choices for managing the inbound traffic to K s. It...

Oracle MySQL Group    The Oracle Cloud Infrastructure OCI command line interface CLI allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to retrieve a list of MySQL HeatWave instances, retrieve more detailed information for a specific instance, and update properties of that...

Oracle MySQL Group    Join us at MySQL and HeatWave Summit , on May, in Redwood Shores, California. Free, unperson event, open to all. Learn about Generative AI and Machine Learning. Get One on One Help and Feature Demos. Hear from Leading Companies like NVIDIA, Meta, LY Corp, CERN, Panasonic Avionics. And...

MySQL Performance Blog    We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community and was recognized as a MySQL Rock Star in .In the previous interview with Vinicius, we discussed the upcoming End of Life EOL for MySQL . . Now that MySQL . has reached EOL,...

Oracle MySQL Group    The Oracle Cloud Infrastructure OCI command line interface CLI allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to retrieve reference data and create a new MySQL HeatWave instance.

Vitess    My name is Arvind Murty, and from May to July of , I worked on Vitess via an internship with PlanetScale. I was first introduced to Vitess when I was in high school as a potential open source project for me to work on. I had been interested in working on one because they’re a relatively easy...

Oracle MySQL Group    HWJP meetup Apr

Jean-François Gagné    Not very long ago well, maybe a little longer, this post is in draft for more than a year , in the spawn of less than days, I suggested many colleagues to reproduce a problem they had with MySQL in a quot;more simple environment quot;. amp;nbsp; Such more simple environment can be created with...

Oracle MySQL Group    Learn more about basic single channel replication setup as well as the high end active active circular or merge replication setups. In this series we will describe how it works both on high level as well as the detailed technical level.

Oracle MySQL Group    Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to update some propertied of a backup of a MySQL HeatWave instance.

Oracle MySQL Group    The initial release focused on MySQL OLTP observability. Building upon the existing foundation, we are pleased to announce an extension of its monitoring capabilities encompassing MySQL HeatWave clusters and Lakehouse enabled DB Systems. With this enhancement, the Database Management service...

MySQL Performance Blog    ProxySQL recently released version . . , and going through the release notes, I focused on the following:Added support for caching sha password This is great news for the community The caching sha password authentication method for frontend connections is now available. This has been a long...

Michael McLaughlin    I’ve been using Alan Beaulieu’s Learning SQL to teach my SQL Development class with MySQL . It’s a great book overall but Chapter lacks a complete exercise. Here’s all that the author provides to the reader. This is inadequate for most readers to work with to solve the concept of a transaction....

Oracle MySQL Group    MySQL HeatWave Faster Point in time Recovery

PlanetScale    MySQL has built in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems.

MySQL Performance Blog    Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and other DMLs could have unwanted side effects such as inconsistent ordering: rows can appear in different order on different nodes in your cluster.If you are not...

HowToForge    MySQL is a free, open source, relational database management platform powered by Oracle Cloud. This tutorial will show you how to install MySQL on Ubuntu . server.

Alena Subotina    Today, accessing and managing databases remotely is a fundamental skill for developers, system administrators, and anyone working with data driven applications. In this article, we will demonstrate how to establish an SSH connection to a MySQL database on a DigitalOcean Droplet a virtual private...

Codership    Codership is please to announce a new release of Galera Manager. This brings the installer to version . . you can check this by typing: . gm installer version which will report gm installer version . . linux amd and the actual Galera Manager GUI to . . . Users will notice many...

Oracle MySQL Group    Episode of MySQL Shorts in now available

Alena Subotina    Duplicates pose an ongoing risk to the data consistency and the overall database efficiency. This article will explore the issue of duplicate records, including their origins, the effects they have on databases, and strategies for swiftly detecting and permanently removing duplicates. The post How...

Codership    Codership is pleased to announce a new Generally Available GA release of the multi master Galera Cluster for MySQL . , consisting of MySQL wsrep . . release notes, download , with Galera replication library . release notes, download implementing wsrep API version . This release...

Oracle MySQL Group    Let’s take a look at these examples to understand how Javascript functions inside MySQL can be used.

Frederic Descamps    You may have noticed that MySQL now supports creating functions and store procedures in Javascript using GraalVM. This new functionality is only available in MySQL Enterprise and MySQL HeatWave. As a developer, you can also get free access to MySQL Enterprise from Oracle Technology Network ...

PlanetScale    Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.

Oracle MySQL Group    This blog post provides some recommendations for MySQL DBAs when using Instant DDL operations.

Frederic Descamps    In MySQL . ., we introduced a new algorithm for DDLs that won’t block the table when changing its definition. The first instant operation was adding a column at the end of a table, this was a contribution from Tencent Games. Then in MySQL . . we added the possibility to add or remove a...

Alena Subotina    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 Q appeared first on Devart Blog.

MySQL Performance Blog    Percona XtraBackup PXB version . . 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...