With MySQL 8.0, the error logging subsystem has been redesigned to use the new component architecture.
Thanks to this new redesign, now the log events can be filtered, the output can be sent to multiple destinations (different formats like JSON). All that is controlled by system variables.
This work gives the possibility for a log event to become the raw material for log processing by more modern and automated systems like filebeat for beats, …
[Read more]
Windowing Functions are new to MySQL with Version 8. I have
been very lucky in the past few days to find two excellent
resources that I want to share with you. Both are worth the
time and effort to study.
At the Southern California Linux Expo last week, Bruce Momjian of
EnterpriseDB and PostgreSQL fame gave an amazing tutorial on
Common Table Expressions and Windowing Functions (slides for both
at https://momjian.us/main/presentations/sql.html).
Bruce is an amazing presenter and I highly recommend going to his
sessions at conferences. So, what can a MySQL-er learn from a
Postrgrestian?
Plenty.
In this case the two databases are using SQL and the features
that turn that language from descriptive to imperative. But
showing how these features is very hard. Bruce said it took
him six years to finish …
This presentation was made at LSPE event in Bangalore (India) held at Walmart labs on 10-03-2018. This presentation focuses how we have harnessed the power of Ansible at Mydbops.
MySQL has various kinds of password policy enforcement tools: a password can expire (even automatically), can be forced to be of a certain length, contain amounts of various types of characters and be checked against a dictionary of common passwords or the user account name itself.…
Dear MySQL Users,
MySQL Connector/J 5.1.46, a maintenance release of the production
5.1
branch has been released. Connector/J is the Type-IV pure-Java
JDBC
driver for MySQL.
MySQL Connector Java is available in source and binary form from
the
Connector/J download pages at
http://dev.mysql.com/downloads/connector/j/5.1.html
and mirror sites as well as Maven-2 repositories.
MySQL Connector Java (Commercial) is already available for
download on the
My Oracle Support (MOS) website. This release will shortly be
available on
eDelivery (OSDC).
As always, we recommend that you check the “CHANGES” file in
the
download archive to be aware of changes in behavior that might
affect
your application.
MySQL Connector/J 5.1.46 includes the following general bug fixes
and
improvements, also available in more detail on
…
In MySQL 8.0, the engineers have added useful
meta-data to the table SETUP_INSTRUMENT. This table
lists the classes of instrumented objects for which events can be
collected.
To the NAME, ENABLES and
TIMED columns, were added PROPERTIES,
VOLATILITY and DOCUMENTATION.
Let’s have a quick look at these new columns:
PROPERTIES can have the following values
memory/performance_schema/metadata_locks that
return the memory used for table
performance_schema.metadata_locks
The latest release of dbdeployer is possibly the last one with a leading 0. If no serious bugs are found in the next two weeks, the next release will bear a glorious 1.0.
Latest news
The decision to get out of the stream of pre-releases that were published until now comes because I have implemented all the features that I wanted to add: mainly, all the ones that I wished to add to MySQL-Sandbox but it would have been …
[Read more]In this post, We will learn how to handle online schema change if the table has triggers.
In PXC, an alter can be made directly ( TOI ) on tables with less than a 1G ( by default) , but on a 20GB or 200GB table we need some downtime to do ( RSU ).
Pt-osc is a good choice for Percona Cluster/Galera. By default percona toolkit’s pt-online-schema-change will create After “insert / update / delete” triggers for maintaining the sync between the shadow and the original table.
pt-online-schema-change process flow:
Check out the complete slides for effective MySQL administration here
If the tables has triggers already then pt-osc wont work well in …
[Read more]
Version 0.3.0 of dbdeployer has gained the ability of deploying
multiple sandboxes concurrently. Whenever we deploy a group of
sandboxes (replication, multiple) we can use
the --concurrent flag, telling dbdeployer that it
should run operations concurrently.
What happens when a single sandbox gets deployed? There are six sets of operations:
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Have you been following the Meltdown/Spectre performance regressions? Some of the best blog posts have been coming from Brendan Gregg, who’s keynoting at Percona Live this year. We’ve also got Scott Simpson from Upwork giving a keynote about how and why they use MongoDB. This is in addition to all the other fun talks we have, so please register now. Don’t forget to also book your hotel room!
Even though the Percona Live conference now covers much more …
[Read more]
