Ideas, releases, practical guides, and perspectives from the people building with MySQL.
I was asked today what opportunities Oracle and MySQL had for new college graduates. I referred them to Start Your Success Story as the place to start. Oracle is a big company and always on the lookout for talent. The list of internships & programs is extensive.
But specifically what about MySQL? For someone who is not a recent graduate?
The …
[Read more]On Oracle Cloud Infrastructure, aka OCI, MySQL Database Service, aka MDS uses the snapshot technology to backup your data.
This article is the second part of multiple part blog series. In part 1, we dealt with taking snapshots as backup. In this part, we deal with restoring the data.
Managed Snapshots
We saw in the post one how to create the snapshots automatically (Backup Plan) or Manually. Both type of backups are what we call Managed Snapshots. This means that as a user, we don’t have access to the Object Storage where the backup is stored.
So what’s the purpose of these snapshots ?
Let’s see them:
Data Restore
Restoring a MDS backup is recommended of course to save the data and in case of issue (hardware or software problem unlikely or human issue more …
[Read more]On Oracle Cloud Infrastructure, aka OCI, MySQL Database Service, aka MDS uses the snapshot technology to backup your data. This article is the second part of multiple part blog series. In part 1, we dealt with taking snapshots as backup. In this part, we deal with restoring the data. Managed Snapsho...
On Oracle Cloud Infrastructure, aka OCI, MySQL Database Service, aka MDS uses the snapshot technology to backup your data.
I will explain how it works in the multiple part blog series. In part 1, we will deal with taking snapshots as backup. In part 2, we will see how to restore data and for which usage.
Snapshots
The Oracle Cloud Infrastructure Block Volume service provides you with the capability to group together multiple volumes in a volume group.
This is exactly what MDS uses to store the data.
We can easily see this from some global variables:
+-----------------------------+--------------------------------+ | Variable_name | Value | +-----------------------------+--------------------------------+ | datadir | /db/data/ | | innodb_data_home_dir | /db/data/ | | innodb_log_group_home_dir …
[Read more]On Oracle Cloud Infrastructure, aka OCI, MySQL Database Service, aka MDS uses the snapshot technology to backup your data. I will explain how it works in the multiple part blog series. In part 1, we will deal with taking snapshots as backup. In part 2, we will see how to restore data and for which u...
In the last installment the flexible and easy to use open source data analysis and manipulation tool Pandas, built on top of the Python programming language, was used with the MySQL Shell, aka mysqlsh. Pandas is a very popular open source project that features data structures and tools to manipulate numerical tables. And the name is derived from Panel Data and not the bamboo chewing critters.
Tasks like generating a series is simple:
dstokes@localhost pandas]$ python
Python 3.9.6 (default, Jul 16 2021, 00:00:00)
[GCC 11.1.1 20210531 (Red Hat 11.1.1-3)] on linux
Type "help", "copyright", "credits" or "license" for more
information.
>>> import pandas as pd
>>> import numpy as …
Recently, Oracle added a Bastion Service to OCI. And you may also have noticed that the OCI Dashboard offers you the possibility to use a browser based terminal: Cloud Shell. Today, we will see how we can use these two components to connect from the browser to a MDS DB System. We need the MySQL DB S...
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 locks by adding the FOR SHARE or FOR
UPDATE modifiers. However there are also cases where
SELECT statements becomes locking due to the way the
result of the statement is used. …
