Percona announces the release of Percona Monitoring and Management 1.3.1. This release only contains bug fixes related to usability.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
Bug fixes
I just wanted to provide quick tutorial on using MariaDB’s Connector C.
I downloaded the latest Connector C (3.0.2), running MariaDB 10.1.28, and was able to get it to work fine with a simple C program using the following commands:
1. Downloaded the Connector C .msi file (32-bit, since my VS is 32-bit), extracted, and installed, which placed it at:
C:\Program Files (x86)\MariaDB\MariaDB Connector C\lib
2. You need to add the directory that contains libmaria.dll to your $PATH Environment LIB PATH variable. In my case, it was:
Control Panel -> System -> Advanced System Settings -> Environment Variables -> Choose "LIB" from under "System variables" -> then add the Connector C lib path, like:
C:\Program Files (x86)\MariaDB\MariaDB Connector C\lib
3. Then just run the following command, where my c/c++ program name is “mysql1.c”:
cl /I "C:\Program Files …[Read more]
Thanks to everyone who joined us this week as we broadcast our MySQL on Docker webinar live from the Percona Live Conference in Dublin!
Our colleague Ashraf Sharif discussed how Docker containers work through to running a simple MySQL container as well as the ClusterControl Docker image (amongst other things)
If you missed the session or would like to watch it again, it’s now online for viewing.
Related resources
Here’s the full …
[Read more]In this post, we are going to see how we can backup encrypted tables using Xtrabackup. InnoDB supports data encryption for InnoDB tables stored in file per table tablespaces. For the application to access encrypted tablespace, InnoDB will use master encryption key to decrypt the tablespace key. The master encryption key is stored in a keyring file in the location specified by the key_ring_file_data configuration option. We have already discussed on enabling encrypted tablespace. Here, we will try full and incremental backups of encrypted tablespace.
Percona xtrabackup supports encrypted innodb tablespace backups. While taking backup, we have to add options –keyring-file-data and –server-id. After the completion of the backup, we have to use the same options to prepare the backup. Below is an example of encrypted table,
Backup can be taken without using –keyring-file-data and …
[Read more]
Notes/errata/updates for Chapter 5:
See the official book errata at http://tahaghoghi.com/LearningMySQL/errata.php –
Chapter 5 is pages 135-177.
Notes:
If you did not load the sample databases in Chapter 3 as per page
102, you can download the file to import from http://tahaghoghi.com/LearningMySQL/Downloads/Files/Data/SQL_files_with_foreign_key_references/music.sql
On page 162, it says “In Chapter 6, we’ll discuss how to load data from existing tables or from external data sources.” but this content is in Chapter 8.
On page 169, it has an example of “DELETE FROM played;” which deletes all the rows of a table. This will not work if safe_updates are enabled. I always advise that if you …
[Read more]One of the widely discussed technologies at Percona Live Europe was the logistics of running MySQL in containers. Containers – particularly Docker – have become a hot topic, so there was a good-sized crowd on day one of the conference for Ashraf Sharif, Senior Support Engineer with Severalnines. He presented his talk “MySQL on Docker: Containerizing the Dolphin”.
During his presentation, Ashraf shared some recommendations for best practices when setting out on containerizing MySQL. He sees the trend of moving to containers as a progression from the use of virtual hosts.
After his talk on day one of the Percona Live Europe conference, I caught up with Ashraf and asked about his presentation. I was interested in which concepts are most important for …
[Read more]
MySQL Connector/Node.js is a new Node.js driver for use with the
X
DevAPI. This release, v8.0.8, is the second development release
of the
MySQL Connector/Node.js 8.0 series.
The X DevAPI 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.
MySQL Connector/Node.js can be downloaded through npm (see
https://www.npmjs.com/package/@mysql/xdevapi for
details) or from
https://dev.mysql.com/downloads/connector/nodejs/.
To learn more about how to write applications using the X DevAPI,
see
…
Dear MySQL users,
MySQL Connector/J 8.0.8 Development Release is a development
milestone
release for the 8.0.x series.
This release includes the following new features and changes,
also
described in more detail on
https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html
MySQL Connectors and other MySQL client tools and applications
now
synchronize the first digit of their version number with the
(highest)
MySQL server version they support.
This change makes it easy and intuitive to decide which client
version
to use for which server version.
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.
To download MySQL Connector/J …
[Read more]Dear MySQL users,
MySQL Connector/Net 8.0.9 is the sixth development release that
expands
cross-platform support to Linux and macOS when using Microsoft’s
.NET Core
framework. Now, .NET developers can use the X DevAPI with .NET
Core and
Entity Framework Core (EF Core) 1.0 to create server applications
that run
on Windows, Linux and macOS. We are very excited about this
change and
really look forward to your feedback on it!
MySQL Connector/Net 8.0.9 is also the eighth development release
of MySQL
Connector/Net to add support for the new X DevAPI. The X
DevAPI 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 X DevAPI,
see
…
Dear MySQL users,
MySQL Connector/Python 8.0.5 dmr is the sixth development release
of the
MySQL Connector Python 8.0 series. This series adds support for
the new X
DevAPI. The X DevAPI 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 X DevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/.
For more information about how the X DevAPI is implemented
in
MySQL Connector/Python, and its usage, see
http://dev.mysql.com/doc/dev/connector-python
Please note that the X DevAPI requires MySQL …
[Read more]