|
Planet MySQL
|
Planet MySQL - https://planet.mysql.com
|
-
Create Replica DB system Made Easy for MySQL HeatWave Service on OCI
MySQL HeatWave Service (MHS) on Oracle Cloud Infrastructure (OCI) already provides multiple ways to create a new DB system, such as restoring from a backup, using Point-in-Time Recovery (PITR), or importing data from Object Storage. However, when creating a new DB system from an existing DB system, especially in another region, the process required several sequential […]
-
Extending MySQL Capabilities with UDFs, Plugins and Components
MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are:
User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual For the purposes of this post I will be using the current LTS version MySQL 8.
-
Do not uselessly grant CREATE and ALTER TABLE
This lesson should have been learned with the CREATE TABLE of death, but it is worth a refresh.
Do not uselessly grant CREATE and ALTER TABLE
The reason I am posting this reminder is that another crashing bug related to DDL came to my attention. This bug is only fixed in a recent version of MySQL (probably not affecting 5.6 and 5.7), so if you are running the latest 8.0 or 8.4, you should
-
Switching to JSON Error Logging in MySQL
You no longer need to manually parse the MySQL Error log via scripting and RegEx pattern matching. Using the component_log_sink_json component you can obtain JSON error logging for easier parsing.
-
Installing MySQL 9.7 LTS Community Edition on CentOS
Historically installing MySQL on a RedHat Compatible Linux server was as simple as yum install mysql-server.
Today’s MySQL Oracle Linux, Red Hat Enterprise Linux, CentOS, and Fedora 9.7 instructions are not accurate mixing in 8.
|
