MySQL highly available solutions, InnoDB Cluster (it uses InnoDB storage engine and is based on Group Replication plugin) and NDB Cluster (NDB storage engine), offer high scalability and redundant topologies.
Whenever application security is mentioned, people think of securing applications against some of the most frequent attacks such as injection, broken authentication, sensitive data exposure, and the like. However, while these attacks are prevalent, knowing how to protect your application from them alone will not be sufficient - especially when you’re running MySQL. Today we are going to look at a different side of security - we are going to look into how to properly secure MySQL.
As MySQL security is a pretty big thing, treat this post as the start of a series of posts regarding MySQL security measures. We will not cover everything, but this post should provide the foundation of some of MySQL’s security measures.
Why Do You Need to Secure MySQL? …
[Read more]The MySQL team is excited to announce that MySQL Database Service now supports the Oracle Cloud Infrastructure Compute E3 shapes. These shapes are built on the 2nd Gen AMD EPYC 7742 processor, with a base clock frequency of 2.25 GHz and max boost of up to 3.4 GHz, and have better networking and more RAM. MySQL Database Service customers can start to use them today and enjoy higher performance and flexibility for diverse MySQL workloads.
The MySQL Database Service E3 offers up to 64 OCPUs (128 virtual cores) and 1 TB of RAM. This is the highest core count and memory for a single fully managed MySQL instance on any public cloud.
The new E3 shapes for MySQL Database Service are available in eight commercial regions: Brazil East (Sao Paulo), Canada Southeast (Toronto), Germany Central (Frankfurt), India West (Mumbai), Japan East (Tokyo), UK South (London), …
[Read more]The MySQL team is excited to announce that MySQL Database Service now supports the Oracle Cloud Infrastructure Compute E3 shapes. These shapes are built on the 2nd Gen AMD EPYC 7742 processor, with a base clock frequency of 2.25 GHz and max boost of up to 3.4 GHz, and have better networking and more...
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() …
Recently the MySQL Database Service (MDS) was launched in Oracle Cloud Infrastructure (OCI). As Cloud is about automation you don't have to use the Web Console to configure your instances, but can do it via API, for instance with the oci command line tool or your favorite programming language. However often it is nice to define the world in a declarative way ("I want a network, like this, and a MySQL database like that") and let the tool figure out how to align the reality in the cloud with your wish. A tool doing this is Terraform.
With Terraform you can declare the state in description files, the tool creates a dependency graph and then applies what has to be applied and of course it supports OCI and as part of the default OCI Provider, there is even directly …
[Read more]The Challenge Often with sensitive information, you need to have an audit log. Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc. In a prior blog I discussed how to audit the selection of classified data.… Facebook Twitter LinkedIn
Kubernetes has been a big trend for a while now, particularly well-suited for microservices. Running your main databases on Kubernetes is probably NOT what you are looking for. However, there’s a niche market for them. My colleague Stephen Thorn did a great job explaining this in The Criticality of a Kubernetes Operator for Databases. If you are considering running your database on Kubernetes, have a look at it first. And, if after reading it you start wondering how the Operator works, Stephen also wrote an Introduction to Percona Kubernetes Operator for Percona XtraDB Cluster (PXC), which presents the Kubernetes architecture and how the Percona Operator simplifies the deployment of a …
[Read more]In this blog post, we are going to look into some key metrics and status when monitoring a Percona Server for MySQL to help us fine-tune the MySQL server configuration for a long run. Just for the heads up, Percona Server has some monitoring metrics that are only available on this build. When comparing on version 8.0.20, the following 51 statuses are only available on Percona Server for MySQL, which are not available in the upstream Oracle's MySQL Community Server:
It’s now more than two months since MDS, the managed MySQL Server solution by Oracle MySQL team, hosted on Oracle Cloud Infrastructure (OCI), became available in several regions on the 1st of September. You can find online several resources online, such as:
If you haven’t tried it for free, time to do so with the …
[Read more]