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 …

The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions.

To view slides, go to the Percona Live agenda, and select the talk you want slides for from the schedule, and click through to the talk web page. The slides are available below the talk description. There is also a page with all the slides that is searchable by topic, talk title, speaker, company or keywords.

To view videos, go to the …