Before we start, I would like to highlight that the fastest and recommended way to import data to a MySQL DB System in OCI is to use a parallel dump created using MySQL to Object Storage and load it during the creation of the MDS instance. MDS enables special features to increase the ingestion speed ...
Dec
22
2021
Dec
21
2021
MySQL Query Optimization is usually simple engineering. But seeking information about how to tune queries is treated on many web reference sites like some Harry Potter-ish spell casting. There are simple tips you need to be aware of to get the best of your queries...
Dec
20
2021
Hey all good folks! I’ve published another issue of your favorite newsletter, OpenLamp.tech, the newsletter for PHP/MySQL developers. This issue (like all the rest) is loaded with fantastic curated content. Enjoy and do share with others!
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
I enjoy writing and curating the OpenLamp.tech newsletter. If you would like to support my efforts and you are finding value in the weekly publication, please share this post or an issue with someone you think would value the content as well.
The Newsletter for PHP and MySQL Developers
In this week’s issue, we have …
[Read more]
Dec
20
2021
This post is the third and last of a series of articles dedicated to MySQL Database Service (MDS):
- Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System
- Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System
- Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave !
The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities.
We can now start a query on our MDS instance that has been populated with >200M rows:
SQL > SELECT year, Reporting_Airline,
AVG(ArrDelay) AS avgArrDelay …[Read more]
Dec
20
2021
In this first article we will start by creating a MySQL DB System and a Compute instance in OCI. One of the goal is also to see the benefits of HeatWave, so we will start by creating this single MySQL DB System on a HeatWave compatible shape. We will then see how to import a large amount of data ...
Dec
19
2021
With Aurora MySQL 8 now generally available to all, you may want to consider the plan for an upgrade path if you would like to take advantage of the new features for your application, for example, Common Table Expressions (CTE). This new major release has a much improved and streamlined upgrade progress from Aurora MySQL 5.7.
This tutorial will provide all the steps to allow you to try out setting up an Aurora cluster and performing an upgrade without the impact on your existing AWS environment. The two pre-requisites to getting started are:
- An AWS account. The Free 1 year AWS account provides many of the services used in these tutorials at no or little cost.
- The awscli. See …
Dec
17
2021
MySQL Database Service is available in all Oracle Cloud Infrastructure regions from day 1. The latest additions are Sweden Central (Stockholm), Italy Northwest (Milan), and UAE Central (Abu Dhabi).
Dec
17
2021
This post is the second of a series of articles dedicated to MySQL Database Service (MDS):
- Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System
- Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System
- Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave !
The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities.
Before we start, I would like to highlight that the fastest and recommended way to import data to a MySQL DB System in OCI is to use a parallel dump created using MySQL to Object Storage and load it …
[Read more]
Dec
17
2021
This post is the first of a series of articles dedicated to MySQL Database Service (MDS):
- Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System
- Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System
- Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave !
The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities.
In this first article we will start by creating a MySQL DB System and a Compute instance in OCI. One of the goal is also to see the benefits of HeatWave, so we will start by creating this …
[Read more]
Dec
17
2021
Background # A critical vulnerability CVE-2021-44228 in the Apache Log4j logging library was disclosed on Dec 9. The project provided release 2.15.0 with a patch that mitigates the impact of this CVE. It was quickly found that the initial patch was insufficient, and an additional CVE CVE-2021-45046 followed. This has been fixed in release 2.16.0. Who is affected? # The bulk of vitess code is in golang, and is unaffected by these vulnerabilities.