This is the first episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.
Like any series, in this episode I’m going to give you some context and set up the characters.
The post Discovering MySQL Database Service – Episode 1 – Introduction first appeared on dasini.net - Diary of a MySQL expert.
The MySQL Ecosystem has been using InnoDB as the default transactional engine for many years now. If you are one of the few still using MyISAM, it is time you also converted and benefited from InnoDB.
If you plan to upgrade to MySQL 8.0, you have several options to deal with those MyISAM tables.
Please note that you should not use MyISAM tables. MyISAM is not ACID compliant and can lead to data loss. Also MyISAM only supports full table lock and no row locking.
As you may recall, in 5.7, MyISAM has MYD, MYI, FRM files. In 8.0, the FRM is replaced with SDI (Serialized Dictionnary Information). Lets review multiple ways to migrate those MyISAM tables to 8.0:
Migration Options
There are multiple solutions to migrate the MyISAM data to 8.0:
Locking is an important concept in databases. They help regulate
access to the data, so your SELECT queries return
consistent results and DML and DDL statements leave the data and
schema in a consistent state. For the data, there are four
different transaction isolation levels that influence which locks
are taken. The most two commonly used isolation levels are
REPEATABLE READ (the default in InnoDB) and
READ COMMITTED (the default in some other
databases). Both of those are said to provide non-locking reads,
but there is a little more to it than that.
Selecting into a user variable causing a lock wait timeout.
One case where reads are always locking is when you explicitly requests …
[Read more]There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular ones. It is highly reliable and efficient, so it is no wonder that it has become a default storage engine for all MySQL versions from 5.5 on. Let us take a look at its […]
The post What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips appeared first on Devart Blog.
Startups SnapVision, GridMarkets, SnapperFutureTech, CAST.AI, and Aptivio scale faster with a multicloud strategy that includes Oracle Cloud Infrastructure
Startups SnapVision, GridMarkets, SnapperFutureTech, CAST.AI, and Aptivio scale faster with a multicloud strategy that includes Oracle Cloud Infrastructure
In a prior blog, we announced that Oracle had set a new goal to power Oracle Cloud with 100% renewable energy by 2025 to secure the energy required for our data centers’ ongoing operation. Today, Oracle has expanded its commitment to sustainability by pledging to power our global operations, both ou...
In a prior blog, we announced that Oracle had set a new goal to power Oracle Cloud with 100% renewable energy by 2025 to secure the energy required for our data centers’ ongoing operation. Today, Oracle has expanded its commitment to sustainability by pledging to power our global operations, both ou...
MySQL Shell is the popular tool to work with MySQL and it integrates perfectly everything for MySQL Database Service (MDS) in Oracle Cloud Infrastructure (OCI).
For any logical dump and load of data and especially to dump data to MDS, MySQL Shell Utility is the recommended solution.
MySQL Shell Dump & Load is faster, is parallel and compatible with OCI (block storage, MDS grants, automatic primary key creations, ...)
This post is about compression.
By default, MySQL Shell Dump uses zstd compression.
Zstd, short for Zstandard, is a fast lossless compression algorithm, targeting real-time compression scenarios at zlib-level compression ratio.
It's possible to specify the compression algorithm to use for MySQL Shell Dump Utility with the compression option.
The accepted …
[Read more]MySQL Shell is the popular tool to work with MySQL and it integrates perfectly everything for MySQL Database Service (MDS) in Oracle Cloud Infrastructure (OCI). For any logical dump and load of data and especially to dump data to MDS, MySQL Shell Utility is the recommended solution. MySQL Shell Dump...