The news that the latest MySQL 8.0.4 RC (release candidate) is available is indeed exciting. Unfortunately for users of the auth_socket plugin, dangers lie in wait!
Back in November 2015, I reported Failure of auth_socket authentication with sha256_password as default. This prevents users that identify with the
auth_socket
plugin from logging in after SHA256 authentication has been made the default authentication method. With the …
[Read more]Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Troubleshooting MySQL Crashes on January 25, 2018, at 10:00 am PST (UTC -8) / 1:00 pm EST (UTC -5).
This webinar is for every MySQL user! In this talk, I won’t focus on how to analyze core files, read the source code or set breakpoints. Instead, I will focus on techniques that are available to anyone, even a novice.
Many tutorials, including my own, written based on Roel Van de Paar’s video, suggest how to create and analyze core files created at the time of a crash. While this …
[Read more]Use the opportunity to talk to Galera Cluster developers and experts. Visit Galera Cluster booth at Conrad Hotel, New York City February 26-27. We will be happy to answer your questions and verify your Galera deployment plans.
There are many Galera Cluster presentations at the conference.
Under the Hood: Galera Cluster
Seppo Jaakola, CEO Codership
Tuesday 27th, 8:40 am – 9:30 am
This session will provide attendees with common use cases for clustering, a comprehensive explanation of how clustering works with Galera and introduce new features and improvements available in Galera Cluster 4.
Global Data Replication with Galera for Ansell Guardian
Greg Henderson and Louis Zircher
Monday 26th, 4:00 pm – 4:50 pm
In early 2017, we seamlessly replaced the global geo-distributed data synchronization …
[Read more]This tutorial shows the installation of a Nginx web server on Debian 9 together with MySQL or MariaDB as database, PHP 7 and free Let's encrypt SSL certificate. Nginx web server is known for its stability, rich feature set, simple configuration, and low resource consumption.
MySQL 8 second release candidate is out (MySQL 8.0.4). Besides fixes to replication issues we have also delivered a couple of enhancements in this release. Let me quickly summarize them.
…
Changing configuration settings in MySQL wasn’t always easy. Of course it’s possible to change things (hopefully), but keeping track of everything is not always obvious. This is where configuration management systems like puppet, chef, ansible, … excels in making our life easier.
/etc/my.cnf
With MySQL 8.0, we worked in making your life easier (and the life of configuration management systems easier too).
Let’s first illustrate the problematic very naively:
As you can see, we can modify this configuration variable, but
after a restart of MySQL, this change is lost, this behavior, of
course is something known by all MySQL DBAs. The usual solution
is then to also modify the configuration file
(/etc/my.cnf in most cases).
SET PERSIST …
[Read more]
Yesterday MySQL 8.0.4-rc came out. The Release Notes are quite long.
But caution: Do a BACKUP before upgrading...
I experienced some nice surprises. First I have to admit that I did not read the Release Notes or anything else. Reading manuals is for Girlies! Possibly something is written in there which is of importance. But I expect that it just works as usual...
I downloaded MySQL 8.0.4-rc and just want to upgrade my MySQL 8.0.3-rc testing system, where we did the 1M tables test.
First I got:
[MY-011096] No data dictionary version number found. [MY-010020] Data Dictionary initialization failed. [MY-010119] Aborting
Hmmm... Maybe something was not clean with the old system. So downgrade again:
[ERROR] [000000] InnoDB: Unsupported redo log format. The redo log was …[Read more]
Yesterday MySQL 8.0.4-rc came out. The Release Notes are quite long.
But caution: Do a BACKUP before upgrading...
I experienced some nice surprises. First I have to admit that I did not read the Release Notes or anything else. Reading manuals is for Girlies! Possibly something is written in there which is of importance. But I expect that it just works as usual...
I downloaded MySQL 8.0.4-rc and just want to upgrade my MySQL 8.0.3-rc testing system, where we did the 1M tables test.
First I got:
[MY-011096] No data dictionary version number found. [MY-010020] Data Dictionary initialization failed. [MY-010119] Aborting
Hmmm... Maybe something was not clean with the old system. So downgrade again:
[ERROR] [000000] InnoDB: Unsupported redo log format. The redo log was …[Read more]
Starting with the MySQL Community 8.0.4-RC we are unifying on OpenSSL as the default TLS/SSL library for both MySQL Enterprise Edition and MySQL Community Edition. Previously, MySQL Community Edition used YaSSL.
Why make this change?
…
