In a perfect world, one would upgrade databases one version at a time and not let them get too old.  But our databases are where the “crown jewels” are.  They must stay up 24×7.  When performance is acceptable, it’s acceptable, and sometimes old versions stay around too long.  We don’t live in a perfect world.  This idea applies to so many things.  There’s almost never a perfect data model.  There is always some type of resource constraint be it storage, memory, CPU, IOPS, or just plain dollars.

I will bring this concept of not living in a perfect world into a discussion about upgrades.

Ideally there would be…

• …time to do two upgrades.  One upgrade to 5.6, the other to 5.7.   This is the way sane, normal people upgrade.
• …a lot of extra hardware.  It sure would be nice to maybe combine a maintenance like this with a hardware refresh so that …

Long time MySQL users will recognize that there are two varieties of utf8 support in MySQL; utf8mb3 and utf8mb4.  Let me dig a little bit deeper in explaining the history between the two:

• MySQL 4.1 (2004) was the first version to support character sets and collations.

…

Percona announces the release of Percona Toolkit 3.0.3 on May 19, 2017.

Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.

You download Percona Toolkit packages from the web site or install from official repositories.

This release includes the following changes:

New Features

• Added the --skip-check-slave-lag option for pt-table-checksum, …

MySQL Cloud Service is a new(ish) way to run MySQL in the cloud, without worrying about installing the server yourself and configuring security, performance, or monitoring, because that's all taken care of by the service. This makes it great for setting up quick throwaway instances that you can just as easily tear down, and it's ideal for developers who don't want to get in line to wait for their DBAs to set up a server for them.

If you've got an account with Oracle Public Cloud (or even a trial account) that has MySQL Cloud Service enabled, it's only a few clicks to get an instance set up. Here's a short overview.

When you've got your instance, you can connect to it with several different …

Today I presented MySQL InnoDB Cluster at the Helsinki MySQL User Group.

To demonstrate how easy it’s to deploy a cluster with MySQL Shell and used the prompt that will be part of a future release just because it’s beautiful.

If you also want to see how it looks like, just check the video below:

There were several MongoDB users in the audience and I got only very positive feedback, they were very surprised how easy it’s to deploy a MySQL InnoDB Cluster these days !

Doxygen is a standard tool used for generating software reference documentation. Since the documentation is written within the code, it is relatively easy to keep it up to date.

In MySQL 8.0.0, the MySQL source code was documented with Doxygen and now in MySQL 8.0.1, the MySQL Test Framework(MTR) documentation is moved from current infrastructure to Doxygen.…

What is the solution if I don’t want to give password in command line (i.e mysql -uroot -p ) OR don’t want to store password in files(in .my.cnf) and still can login into MySQL/MariaDB without password ? I was also bit curious to know but finally I found very easy solution called “unix_socket plugin” provided by MariaDB.

This plugin allows to use operating system user credentials while connecting to MariaDB via Unix socket. When we try to connect with OS user, it will retrieve uid of the process which has connected to the socket and allow it to connect to MariaDB with the same user.

You can simply install that plugin with command,

MariaDB [(none)]> INSTALL PLUGIN unix_socket SONAME 'auth_socket';
Query OK, 0 rows affected (0.02 sec)

After, then you need to identify the user which you want to use to login into MariaDB. Like for me,

It’s a well know fact that we could take backups with almost zero downtime with the “mysqldump” tool provided with the community edition of MySQL with a magical option --single-transaction on one  condition that all the tables are InnoDB. Myisam tables locked even with single transaction option.

Now let us talk about the MySQL Enterprise backup tool that is only available with the Enterprise edition. We are also offered a 30 day trial. It has been said that MEB(let us just call the MySQL Enterprise backup, MEB)  provides hot online backups with zero downtime.

So a hot backup is done online and doesn’t disrupt the normal operations of the database and it even captures the database operations happening during the backup process and applies it during the restoration process. This is applicable only to InnoDB tables.

When …

Brett Hesterberg (Google) delivers his talk, "Get to know Google Cloud SQL", on DAY 3 of the Percona Live Open Source Database Conference 2017, 4/27, at Santa Clara, CA.

This maintenance release of SQLyog, MySQL GUI introduces a new feature – REGEX search in Object Browser – and adds a few bug fixes.

Changes as compared to MySQL GUI 12.4.1 include:

Important notice:

* The tunneler file for HTTP-tunnel has been updated with this release and must be replaced on the server.  Earlier HTTP-tunnel required PCRE-support in the server-side PHP-environment. Now it does not.

Features:

* Search function in Object Browser now supports regular expressions.

Bug Fixes:

* Fixed a rare connection failure using SSH-tunnel to specific BSD systems.
* Removed unnecessary virtual column check for older servers with no support for this.
* Fixed a crash when a …