Skip to content
  • My MySQL Youtube Channel
  • MySQL Community on Slack
  • Deploy to OCI
  • Upcoming Talks
  • Some talks and tutorials
  • New Features in MySQL 8.0
  • MySQL Version Diff
  • Art work credits
  • Disclaimer
lefred's blog: tribulations of a MySQL Evangelist
  • My MySQL Youtube Channel
  • MySQL Community on Slack
  • Deploy to OCI
  • Upcoming Talks
  • Some talks and tutorials
  • New Features in MySQL 8.0
  • MySQL Version Diff
  • Art work credits
  • Disclaimer
lefred's blog: tribulations of a MySQL Evangelist
  • 8.0, General, Migration, MySQL, MySQL 8.0, MySQL Shell

Migrating from MariaDB to MySQL using MySQL Shell

We are getting many requests for migration from MariaDB to MySQL. Here is a quick guide and steps to follow: On the MariaDB server: Create a logical dump of MariaDB (using MySQL Shell) Create a dedicated user for replication [optional]…

  • May 25, 2022
  • 8.0, MySQL, MySQL 8.0, MySQL Shell, Performance_Schema

A graph a day, keeps the doctor away ! – MySQL Checkpoint Age

In a previous post, I explained how you can collect and plot metrics using MySQL Shell. This is a new series of article where I will explain how to read and understand some of the generated graphs. Understanding your workload…

  • May 12, 2022
  • 8.0, Contributions, MySQL, MySQL 8.0

MySQL 8.0.29: thank you for the contributions

When it’s time for a new MySQL release, it’s also time to thank our contributors ! Released on April 26th, MySQL 8.0.29 contains several contributions from our awesome Community and on behalf of the entire MySQL Team, I would like…

  • May 1, 2022
  • 5 Comments
  • 8.0, Cloud, Data Visualization, Devel, MDS, MySQL, MySQL 8.0, MySQL Shell, Python

Poorman’s MySQL monitoring/trending

I could have also called this article When Pandas meet Dolphins in MySQL Shell. Some time ago, I wrote a post related on how to collect initial relevant data when trying to seek help for MySQL. Since then, the MySQL…

  • April 28, 2022
  • 1 Comment
  • 8.0, MySQL, MySQL 8.0, MySQL Shell

Poorman’s MySQL table audit information – part 3

Recently we saw how we can catch audit information using invisible column, JSON data type and triggers in MySQL 8.0: Poorman’s MySQL table audit information Poorman’s MySQL table audit information – part 2 Of course, the creation of these triggers…

  • April 19, 2022
  • 8.0, MySQL, MySQL 8.0

Poorman’s MySQL table audit information – part 2

I really enjoyed to dig into the solution I described yesterday in this post, to generate table audit information using invisible columns and triggers. In this post, I will focus only on the solution using a JSON column to store…

  • April 15, 2022
  • 8.0, MySQL, MySQL 8.0

Poorman’s MySQL table audit information

Today, somebody asked me how he could track the creation of a record (who created it and when) and who and when it was last modified. Usually, this is performed in a different table, called audit table. In MySQL you…

  • April 15, 2022
  • 8.0, Cloud, devops, General, HeatWave, MDS, MySQL, MySQL 8.0, OCI, Stacks, Terraform

Deploying Apache Airflow on OCI with MySQL HeatWave Database Service

Apache Airflow is an open-source workflow management platform for data engineering pipelines. Today we will see how we can deploy very easily Apache Airflow on a Compute instance in Oracle Cloud Infrastructure (OCI) using MySQL HeatWave Database Service (MDS). I…

  • April 7, 2022
  • 8.0, Document Store, JSON, MySQL, MySQL 8.0

How to modify a JSON field in SQL ?

Let’s start with some info about how MySQL Document Store handles JSON documents. Document Store and CRUD We know that MySQL 8.0 Document Store handles JSON documents with CRUD operations. We can add, delete and modify those documents very easily:…

  • April 6, 2022
  • 1 Comment
  • 8.0, Cloud, HeatWave, MDS, MySQL, MySQL 8.0, MySQL Shell, OCI

Live Migration from Azure Database for MySQL to MySQL Database Service on OCI

MySQL Database Service on OCI is all over the tech news with the latest HeatWave ML announcement [1][2][3][4][5]. This article explains how to perform a live migration of your Azure/MySQL to OCI As Azure allows public connections directly to the…

  • April 5, 2022
  • 8.0, Devel, MySQL, MySQL 8.0, rpm, sysbench

sysbench 1.1.0 rpm with SSL support

For a future article, I was again looking into the possibility of using sysbench to generate data and load on a MySQL database. However, I needed an SSL connection which only version 1.1.0 supports (see issue 308). Alexey didn’t create…

  • April 4, 2022
  • 8.0, Cloud, devops, MDS, MySQL, MySQL 8.0, OCI

Using OCI Serverless Functions and API Gateways to create logical dumps of a MySQL Database Service with MySQL Shell

When using cloud native application architectures, Functions have an important role for the business logic without managing any infrastructure. Functions is a serverless platform powered by the Fn Project open source engine. These Functions are mostly used to create and…

  • March 7, 2022
1 2 3 4 … 41
Next

Recent Comments

  • Gabriel on MySQL: when will the password of my users expire ?
  • qwertxl on Deploying Nextcloud on Oracle Cloud with MySQL Database Service and Object Storage
  • lefred on MySQL 8.0.29: thank you for the contributions
  • fanderchan on MySQL 8.0.29: thank you for the contributions
  • fanderchan on MySQL 8.0.29: thank you for the contributions

MySQL Shell Plugins - recent commits

  • fix again the plotting Signed-off-by: Frederic Descamps by Frederic Descamps on Apr 29, 2022 @ 22:39
  • Simplify the code and add a random color for fixed lines Signed-off-by: Frederic Descamps by Frederic Descamps on Apr 29, 2022 @ 10:57
  • adding extra info to the legend Signed-off-by: Frederic Descamps by Frederic Descamps on Apr 29, 2022 @ 10:06
Twitter Instagram LinkedIn GitHub YouTube

Copyright © 2022 lefred blog: tribulations of a MySQL Evangelist

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT