Percona announces the GA release of Percona XtraBackup 2.4.9 on November 29, 2017. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, it drives down …
[Read more]In my preview blog posts, I have written about this exam topics and this blog post will cover remaining topics.
Let start with it,
MySQL Security
This MySQL Security section covers general MySQL server inbuild option plus enterprise tools offered by MySQL enterprise edition.
Reference doc: MySQL privilege and access control
Explore for password_validation plugin and Password Expiration policies for MySQL USER.
[Read more]
SUDOKU is an interesting problem. Using SQL to solve this
problem is not anything magical.
An interesting twitter post from
https://twitter.com/VadimTk/status/916734787557064704
Thanks to Vadim Tkachenko
The following SQL with MySQL 8.0.3 RC1, the New Feature
"Recursive Common Table Expression/CTE" enables the easy way of
this SUDOKU solver.
select
@myproblem:='..41..2.3........12.....8..82.6.43.....8.9.....67.2.48..5.....64........3.7..69..';
WITH RECURSIVE
my19(n) AS (
SELECT 1 AS n
UNION ALL
SELECT 1+n FROM my19
WHERE n<9
)
select substr(@myproblem,(n-1)*9+1,9) as sud from my19;
…
In this blog post I’ll look at the performance of Percona XtraDB Cluster on AWS using different service instances, and recommend some best practices for maximizing performance.
You can use Percona XtraDB Cluster in AWS environments. We often get questions about how best to deploy it, and how to optimize both performance and spend when doing so. I decided to look into it with some benchmark testing.
For these benchmark tests, I used the following configuration:
We …
[Read more]Percona announces the release of Percona Monitoring and Management 1.5.0 on November 28, 2017.
This release focuses on the following features:
And here we go again: here is another term. We are still debating
about the real meaning of Cloud and if a database fits in IaaS, PaaS, SaaS or in a combination
of all three, and now we experience another wave of change. To be
fair, the term Fog
Computing has been around for quite some time, but it has
never enjoyed the popularity of its buddy “the Cloud”.
Is Fog Computing another pointless renaming of well known
technologies and IT infrastructures? Or is it a real new thing
that Systems and Database Administrators should look at, study
and embrace? My intent here is not to support one side or the
other, but simply to instil a few thoughts that may turn handy in
understanding where the IT market is going, and more specifically
where MySQL can be a good fit in some of the new …
In a previous post, I talked about the existence of a CREATE TABLE that is crashing MySQL up to versions 5.5.58, 5.6.38 and 5.7.20, and MariaDB up to version 5.5.57, 10.0.32, 10.1.26 and 10.2.7. I hope you upgraded (or can mitigate this problem in another way) as I am now publishing the CREATE TABLE of death.
The first thing to clarify about the CREATE TABLE of death is that it is not a bug in
As last year, we will take advantage of the mass presence of our engineers during FOSDEM to organize a MySQL Day once again.
The Agenda is not yet known, but save the date and schedule your trip to Brussels keeping in mind that Friday February 2nd 2018, there will be a full day dedicated to MySQL !
More to come soon but don’t forget to register !
Dear MySQL users,
I’m glad to announce that MySQL X DevAPI extension for PHP 8.0.3 has been recently released!
If for some reason you don’t know what this is all about, then in short the MySQL X DevAPI for PHP add support for the new X DevAPI in PHP, and it’s released as an extension to the language. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models –MySQL as a Document Store– using a modern NoSQL-like syntax that does not assume previous experience writing traditional SQL.
For general documentation about how to get started using MySQL as a document store, see “Using MySQL as a Document Store”.
Download the extension.
…
[Read more]Sometimes it can be useful to take a step back and look at the world from a bit larger distance than usual. So in this blog, I will take a look at the high level architecture of MySQL Server.
Info This is meant as a simplified overview and does not include all details. Overview of the MySQL Server Architecture
For the discussion I will be referring to the the following figure that shows some of the features and plugins of MySQL. Orange boxes are available both for the community version and the commercial (enterprise) version, whereas red means the plugin is exclusive for the commercial version. Ellipsoid elements are plugins, …
[Read more]
