In my previous post (Puzzled by MySQL Replication), I describe a weird, but completely documented, behavior of replication that had me scratching my head for hours because it was causing data corruption. I did not give too many details then as I also wanted allowing you to scratch your head if you wished. In this post, I describe this behavior in more details.
But first I need to
[…] when the value of the key that encrypted its file password is known. We can use this amazing post https://mysql.wisborg.dk/2019/01/28/automatic-decryption-of-mysql-binary-logs-using-python/ to decrypt the binary log. To use this script, we need only have access to the keyring […]
We will have a look at a new feature in MySQL 8.0 called binlog encryption. This feature is available from the MySQL version 8.0.14 or above.
Our previous blogs discussed about table space encryption in MySQL and Percona servers. In Mydbops, we are giving high importance about achieving security compliances.
The binary log records changes made to the databases so that it can be used to replicate the same to the slaves and also for the point in time recovery (PITR). So, it means that if someone has access to the binary logs, they can reproduce our entire database in many forms. As a DBA, we need to make sure that the binary log files are protected from users who are having access to the file system and also, log files need …
[Read more]Good
LikeLike
We know the MySQL Shell is the advanced client tool for communicate to the MySQL server . MySQL Shell has lot of features like InnoDB Cluster control , InnoDB ReplicaSet, MySQL Shell utilities , MySQL server management etc … Today I came to know, MySQL shell helps lot in monitoring as well ( query, threads, resource consumption , locking ) .
In this blog I am going to explain how to use the MySQL Shell for monitor your server .
MySQL Shell provides two hot commands \show and \watch for monitor the MySQL server and report generating purpose .
\show : Execute the report with the provided options
\watch : Execute the report in loop with provided options
\show with thread example :
\show with query example :
You can execute any query within the double quotes .
\show with threads example :
…[Read more]
When I tell people that they can use MySQL without SQL they tend
to be skeptical. But with the MySQL Document Store you can
do just that with a new NoSQL API and in this case there is no
structured query language.pre-FOSDEM MySQL Days (which is sold out
and there is a waiting list) is my tutorial on using the Document
Store. Those in my session will be able to see how to use
the MySQL Shell (mysqlsh) to connect to a MySQL server and save
data without have to do the many things a DBA used to have to do
in the past such as normalize data, setup relations, and several
other tasks. Plus the schema-less Document Store means you
can alter your data needs without having to do an endless series
of ALTER TABLES.
| … |
MySQL InnoDB Cluster in 8.0.19 has new version of MySQL InnoDB
Cluster MetaData.
MySQL Shell 8.0.19 full function has to be running with V2
metadata.
This is the tutorial for an sample upgrade of MySQL 8.0.18 to
MySQL 8.0.19
Reference :
https://mysqlserverteam.com/upgrading-mysql-innodb-cluster-metadata/
The following InnoDB Cluster is running with MySQL 8.0.18.
Running MySQL Shell 8.0.19 with MySQL InnoDB Cluster 8.0.18
(which the metadata version is @1.0.1) with command
dba.getCluster() results in Warning :
WARNING: No cluster change operations can be executed because the
installed metadata version 1.0.1 is lower than the version
required by Shell which is version 2.0.0. Upgrade the metadata to
remove this restriction. See \? …
From the initial release, one of the biggest complaints I had about Group Replication is that it allowed “stale” reads and there was no way to prevent them or to even know that you read “stale” data. That was a huge limitation. Thankfully, Oracle released features to control the consistency levels, and it was exactly a year ago! I don’t know about you, but I personally was confused by naming it group_replication_consistency=’AFTER’ or ‘BEFORE’.
So now I want to try to make sense of it and share my understanding (even if it is one year later).
Setup:
Introduction
Before I talk about installation of MySQL inside docker, it's
more important to know
what is Docker?
- Docker is a tool designed to create , deploy
,and run an application any where.
-It allow us to package up application with all requirements such
as libraries and other dependencies and ship it all as a
PACKAGE.
who uses Docker?
Developer : Docker enables developer to develop application
without spending much time on IT infrastructure.
Sysadmin :-Docker enables sysadmin to streamline the
software delivery, such as develop and deploy bug fixes and new
features without any roadblock.
Enterprise :-Docker works in the cloud , on premise ,and
supports both traditional …
As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put together some concepts on how InnoDB flushing works in recent Percona Server for MySQL versions (8.0.x prior to 8.0.19, or 5.7.x). It is important to understand this aspect of InnoDB in order to tune it correctly. This post is a bit long and complex as it goes very deep into some InnoDB internals.
InnoDB internally handles flush operations in the background to remove dirty pages from the buffer pool. A dirty page is a page that is modified in memory but not yet flushed to disk. This is done to lower the write load and the latency of the transactions. Let’s explore the various sources of flushing inside InnoDB.
Idle Flushing
We already discussed the idle flushing in the previous post …
[Read more]