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() …
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
like COM_COMMIT
or HANDLER_COMMIT
, then
checking in innodb_metrics
… but this was not
accurate.
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
those values.
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
This post was first published on Oracle MySQL Blog.
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.
This awesome place is MySQL Database Service in OCI. For more information about what MDS is and what it provides, please check this blog from my colleague Airton Lastori.
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]During the MDS webinar on how to deploy WordPress on OCI using MDS (slides & video), I briefly explained how to deploy the full architecture on OCI using Resource Manager and Stacks.
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.
The Plan
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.
SSH
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 Installation:
Docker can be installed with yum repository or apt-get repository based on your linux …
[Read more]