Logical backup’s are of great use in data migration across cloud environments and table level recoveries. The new Mysql shell 8.0.22 ,has introduced a couple of new utilities named util.dumpTable() and util.exportTable() to export individual tables from a MySQL. Prior to 8.0.22 it is not possible to make a backup of single table using MySQL Shell.
MySQL Shell’s new table dump utility util.dumpTables() from this we can take the dump of the specific tables of the schema using this utility.it works in the same way as the instance dump utility util.dumpInstance() …
10 Older Entries »
MySQL configuration variables are a set of server system variables used to configure the operation and behavior of the server. In this blog post, we will explain the differences in managing the configuration variables between MySQL 5.7 and MySQL 8.0. We will explain three different ways for setting the configuration variables based on your use-case. […]
The amount of transactions committed is an important information, but how could you return an accurate value?
This is a question I got from my colleague Ivan, he was challenging with global status values
innodb_metrics… but this was not
In fact depending which storage engine you are using, if binary
logs are enabled, if you rollback transactions, if you are using
auto_commit, etc… all those parameters influence
So the first question was “What metrics or else should we use ?”. In my opinion, the most accurate “counter” for transactions are the GTIDs.
And this is why I created yet another MySQL Shell plugin that does that calculation:
This plugin is available on my GitHub repository …[Read more]
Wooohooo MySQL 8.0.22 has been released today !
As usual, this release contains contributions from our great Community and let me thanks all the contributors on behalf of the MySQL Team.
MySQL 8.0.22 includes contributions from Denis Yarkovoy, Gord Thomson, Andrey Turbanov, Javier Matos Odut, Kan Liyong, Xiaoyu Wang, Daniël van Eeden, Krunal Bauskar, Eric Beuque and Facebook.
Thank you all for your great contributions. MySQL is an Open Source project, GPL, and we accept contributions !
Here is the list of the contributions above:
- Update command.cs by Denis Yarkovoy
Yes, your read the title correctly: an unprivileged user can crash your MySQL Server. This applies for the default configuration of MySQL 8.0.21 (and it is probably the case for all MySQL 8 GA versions). Depending on your configuration, it might also be the case for MySQL 5.7. This needs malicious intent and a lot of determination, so no need to panic as this will not happen by accident. I am
If you are running MySQL on premise, it’s maybe the right time to think about migrating your lovely MySQL database somewhere where the MySQL Team prepared a comfortable place for it to stay running and safe.
One important word that should come to your mind when we talk about MDS is SECURITY !
Therefore, MDS endpoint can only be a private IP in OCI. This means you won’t be able to expose your MySQL …[Read more]
The Stack for that architecture is now available on my github: https://github.com/lefred/oci-wordpress-mds/releases/tag/0.0.1
To deploy it, it’s very easy. In OCI’s Dashboard, go on “Resource Manager” and then choose “Stacks“:
Create a new stack and just drop the …[Read more]
Today we will see how to use MySQL Database Service aka MDS with WordPress.
To achieve this easy task, we will use the architecture we already deployed in this article.
We have then two Compute Instances on OCI, 1 running WordPress (Apache and PHP) and one running MySQL 8.0.
This is how we will proceed to migrate to MDS with minimal maintenance time, we will:
- create a MDS instance
- verify if the database is ready to act as replication source
- dump the MySQL instance running on OCI for being migrated to MDS.
- load the dump in MDS
- create a user dedicated to the replication
- create a replication channel on MDS (from OCI to MDS)
- modify WordPress config to point to MDS
Create a MDS …[Read more]
In a recent article, I explained how to test MySQL Database Service (aka MDS) on OCI without having to setup a VPN.
A VPN is the recommended way and of course using some man-in-the-middle exposing the MySQL Classic and X Protocol port is something you should absolutely avoid !
So, in this article we will see another way to test or use MDS without VPN but using a more secure option.
The solution uses a SSH tunnel between your machine (laptop, etc..) and OCI.
How does it work ?
We have a MDS instance (10.0.1.3), and a compute instance (10.0.0.2). The compute instance is in the public subnet and has a public IP assigned to it.
Then we open a SSH tunnel to the compute instance’s public IP that forward all traffic to a certain port on localhost (we will use 3406) …[Read more]
As a Database Engineer in Mydbops. We tend to solve multiple complex problems for our esteemed customers. To control the System resources and scale up /down based on needed we are evaluating Dockers and Kubernetes.
Docker is a set of platform as a service products that uses OS-level virtualization to deliver software in packages called Containers. Containers are isolated from one another and bundle their own software, libraries and configuration files; they can communicate with each other through well-defined channels.It’s more lightweight than standard Containers and boots up in seconds.
Docker also is easy to use when you need a simple, single instance. What is great about Docker though is that it allows configuring multiple versions of MySQL.
Docker can be installed with yum repository or apt-get repository based on your linux …[Read more]
10 Older Entries »