The encrypted binary log file format introduced in MySQL version 8.0.14 was designed to allow a “manual” decryption of the file data when the value of the key that encrypted its file password is known.
Each encrypted binary (or relay) log file is composed by an encrypted binary log file header and the encrypted binary log content (the file data).…
Starting in version 8.0.14, MySQL server can encrypt all new binary and relay
log files on disk. In order to do so, you just need to enable
the new binlog_encryption option (and also
ensure that you have a keyring).…
The MySQL Track for the Southern California Linux Expo
17x has been published! On Friday march 9th you can learn about
the MySQL Document Store, How to Deploy MySQL in Kubernetes, lean
how Facebook achieves consistency with MySQL, MySQL Query
Optimization, Analytics with MySQL, and MySQL
Security.
There are actually four days of the expo but the MySQL Track is
on Friday, but you should stay around for the full weekend.
And MySQL is a sponsor and we will have a big booth with lots of
swag, Be sure to stop by to say hello!
A common challenge with continuously deployed applications is that new and modified SQL queries are constantly being introduced to the application. Many companies choose to use a database monitoring system (such as PMM) to identify those slow queries. But identifying slow queries is only the start – what about actually optimizing them?
In this post we’ll demonstrate a new way to both identify and optimize slow queries, by utilizing the recent integration of Percona Monitoring and Management with EverSQL Query Optimizer via Chrome browser extension. This integration allows you to identify slow queries using PMM, and optimize them automatically using EverSQL Query Optimizer.
Optimizing queries with PMM & EverSQL
We’re using PMM to monitor our MySQL …
[Read more]This log buffer edition overs cloud, Oracle, PostgreSQL and MySQL.
Cloud
On December 4, 2018 Microsoft’s Azure Database for Open Sources announced the general availability of MariaDB. This blog intends to share some guidance and best practices for alerting on the most commonly monitored metrics for the service.
Technology allows manufacturers to generate more data than traditional systems and users can digest. Predictive analytics, enabled by big data and cloud technologies, can take advantage of this data and provide new and unique insights into the health of manufacturing equipment and processes.
…
[Read more]As listed in the release announcement of the latest MySQL InnoDB Cluster release, 8.0.14 brings exciting new features! This blog post is the first of a series detailing every single new feature added, starting by: “Changing cluster topology modes ‘live‘”.…
The MySQL X DevAPI is the new API that provides a uniform API across the supported programming languages. It has from the beginning supported that you can specify a default schema, when you connect. Originally it was not used for SQL statements. Starting with MySQL 8.0.14 the feature has been extended, so SQL statements take the default schema into consideration as well. This blog will explore how this works using MySQL Connector/Python. If you use a different programming language, the change will work in a similar way.
In order to explore the feature, a sample program is needed. A
simple program that prints the MySQL Connector/Python version,
queries the city
Dear MySQL users,
MySQL Connector/NET 8.0.14 is the second version to support
Entity Framework Core 2.1 and the fourth general availability
release
of MySQL Connector/NET to add support for the new XDevAPI,
which
enables application developers to write code that combines
the
strengths of the relational and document models using a
modern,
NoSQL-like syntax that does not assume previous experience
writing traditional SQL.
To learn more about how to write applications using the XDevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/index.html.
For more
information about how the XDevAPI is implemented in
Connector/NET, see
http://dev.mysql.com/doc/dev/connector-net. NuGet
packages provide …
I have been asked the MySQL Shell handles BSON and now with
today's release of version 8.0.,14, it does. Version 8.0.13
added a very hand and blazing fast JSON bulk loader you get the
ability to map and how the data is converted. The details are
at the Conversions for representations of BSON data
types page
From the 8.0.14 release notes:
* The MySQL Shell JSON import utility can now process
BSON
(binary JSON) data types that are
represented in JSON
documents. The data types used in
BSON documents are not
all natively supported by JSON, but
can be represented
using extensions to the JSON
format. The import utility
…
The MySQL Development team is proud to announce a new version of the MySQL Shell which includes the following features:
…
