Q: Validate an instance for MySQL InnoDB Cluster usage?
A: Use check_instance_configuration()
May
21
2019
May
21
2019
The world seems awash in unstructured, NoSQL data, mainly of the
JSON variety. While this has a great many benefits as far
as data mutability and not being locked into a rigid structure
there are some things missing that are common in the structured
world of SQL databases.
What if there was a way to take this unstructured NoSQL JSON data
and cast it, temporarily, into a structured table? Then you
could use all the processing functions and features found in a
relation database on you data. There is a way and it is the
JSON_TABLE function.
JSON_TABLE
You can find the documentation for JSON_TABLE here but there are some examples below
that may make learning this valuable function easier than the
simple RTFM.
I will be using the world_x dataset for the next example
If …
May
20
2019
Monitoring MySQL server has never been an easy task. Monitoring also needs to go through many Complex and difficult queries to get the details.
All these problems can be overcome by an excellent command line monitoring tool called “Innotop”. Innotop comes with many features and different types of modes/options, which helps to monitor different aspects of MySQL (InnoDB) performance and also helps database administrator to find out what’s wrong going with MySQL server. Innotop helps in monitoring user statistics, mysql replication status,query list, InnoDB I/O informations etc. Another important thing about innotop is it refreshes the data continuously , so we can view realtime statistics.
Innotop is one of the designed based on top utility for linux.
…[Read more]
May
20
2019
It's our pleasure to mention 2 shows we are supporting & attending this week. They are: PHPTek19, May 21-23, 2019, Atlanta, US. MySQL Community team is again a proud sponsor of this great event.
The second show is OpenSUSE, May 24-26, 2019 in Nuremberg, Germany where MySQL is a Silver sponsor with a MySQL booth in the expo area. We will be happy to hear feedback, answer your questions and have discussion with you @OpenSUSE.
May
18
2019
Introduction
We are well aware that ProxySQL is one of the leading SQL aware proxy for MySQL. In this blog I am going to explain the backup & restore strategies of the ProxySQL . I think, still there is not well structured blog about this topic .
If you are looking for other articles on our ProxySQL Series :
[Read more]
May
18
2019
ERROR 1040 (HY000): Too many connections
An application might face this issue when all the defined
max_connections parameter value is exhausted.
mysqld reserve a +1 connection (i.e., max_connections + 1)
for the user who is having the SUPER privilege.
When this issue appears, Only the user with the SUPER privileges
can be connected if any other user who has SUPER privileges is
not already connected to the database and we have reached
max_connections.
1. Always make sure to DON'T give the SUPER privilege to any application user or any user which is being used inside the scripts. Because if that user has …
[Read more]
May
17
2019
NOTE [2019-05-18]: Debian/Ubuntu
5.6.44-85.0-1 packages were replaced today in the
repositories with the 5.6.44-85.0-2 because they
would reset the root password to an empty string during the
upgrade on Debian/Ubuntu (bug #5640). If you upgraded packages on Debian/Ubuntu
to the 5.6.44-85.0-1 please upgrade to
5.6.44-85.0-2 and re-set your root password.
Percona announces the release of Percona Server for MySQL 5.6.44-85.0 on May 17, 2019. Download the latest version from the Percona web …
[Read more]
May
16
2019
So, typically, a Percona Live (or MySQL User) Conference blog
would start off with some mention of the fact that it’s great to
be meeting up again in Santa Clara, California, the birthplace of
the MySQL User Conference, and a continuous fixture on the yearly
MySQL community agenda.
But no, not this time!
On this occasion, the Percona Live Conference blog starts off by
pointing out that for the first time since its inception (as far
as I can recollect), the MySQL User Conference, i.e. Percona Live
Conference (in North America) doesn’t take place in Santa Clara,
but rather in Austin, Texas.
Never having been to Texas before myself, I’m looking forward to
that innovation, discovering the new surroundings and seeing
whether that changes anything or not to the familiar “feel” of a
Percona Live / MySQL User Conference.
By the way, there’s still time to …
May
16
2019
MySQL Router 8.0.16 Key features
- log-rotation via SIGHUP
- HTTP server plugin
- flexible support for single/multi-PRIMARY Group Replication
Logrotation via SIGHUP
Sending a SIGHUP signal to the router process will now close and reopen the logfile.
It allows the integration with the logrotate to rotate and compress the Router’s logfiles.…
Facebook Twitter LinkedIn
May
15
2019
To operate more easily a MySQL Group Replication (InnoDB Cluster), the Group Replication plugins provides some UDFs.
If you have read the recent article from Tiago Vale about the Group Replication Communication Protocol, you may have heard about two new UDFs allowing to get or set the communication protocol.
So what are all the UDFs provided with the Group Replication and what’s their purpose ?
SELECT UDF_NAME FROM performance_schema.user_defined_functions WHERE UDF_NAME LIKE 'group_repl%'; +-------------------------------------------------+ | UDF_NAME | +-------------------------------------------------+ | group_replication_get_communication_protocol | | group_replication_get_write_concurrency | | group_replication_set_as_primary | …[Read more]