Percona announces the release of Percona Monitoring and Management 1.2.2 on August 23, 2017.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
This release contains bug fixes related to performance and introduces various improvements. It also contains an updated version of Grafana.
Changes in PMM Server
We introduced the following changes in PMM Server 1.2.2:
Bug fixes¶
PMM-927: The error …
In this blog post, we’ll discuss migrating data from encrypted Amazon MySQL RDS to encrypted Amazon Aurora.
One of my customers wanted to migrate from an encrypted MySQL RDS instance to an encrypted Aurora instance. They have a pretty large database, therefore using mysqldump or a similar tool was not suitable for them. They also wanted to setup replication between old MySQL RDS and new Aurora instances.
Spoiler: this is possible without any logical dump.
At first, I checked Amazon’s documentation on encryption and found nothing about this type of …
[Read more]A MariaDB Support customer recently asked how they could automatically drop old partitions after 6 months. MariaDB and MySQL do not have a mechanism to do this automatically out-of-the-box, but it is not too difficult to create a custom stored procedure and an event to call the procedure on the desired schedule. In this blog post, I will show one ... Read More
Most of the PHP I write runs on Bluemix – it’s IBM self-service cloud, and since I work there, they pay for my accounts :) There are a bunch of databases you can use there, mostly open source offerings, and of course with PHP I like to use MySQL. Someone asked me for my connection code since it’s a bit tricky to grab the credentials that you need, so here it is. Bluemix Environment Variables
In Bluemix, you can simply create a MySQL database (look for “compose-for-mysql” in the catalog), create a set of credentials, and then bind it to your app. I should blog a few more of my PHP-on-Bluemix tricks but you can run a selection of PHP versions and it’s also possible to add extensions that you need, I have found it does have what I need once I figure out how to configure it!
Once the database is bound to the application, then your PHP code running on Bluemix will have an environment variable called …
[Read more]MySQL has thrown away the mysql.proc table for version 8.0 Development Releases.
The best explanation that I've seen is the one that Dmitry Lenev gave at a conference last October.
To summarize it: mysql.proc and its ilk are non-transactional, redundancy is bad, and MySQL can fix some known bugs by moving over to information_schema tables backed by InnoDB. Of course I approve for a separate reason: mysql.proc is non-standard and therefore it is a mistake.
On the other hand, programmers that have invested some time in using mysql.proc will have some trouble changing them to use information_schema.routines instead.
Table definition differences
I did a complex left join of the information_schema.columns
for
mysql.proc (P) and for information_schema.routines (R) in MySQL
5.7, and saw …
In this blog post, we’ll look at some of the MySQL high availability solution options.
In the previous post of this series, we looked at the MySQL high availability (HA) solutions that have been around for a long time. I called these solutions “the elders.” Some of these solutions (like replication) are heavily used today and have been improved from release to release of MySQL.
This post focuses on the MySQL high availability solutions that have appeared over the last five years and gained a fair amount of traction in the community. I chose to include this group only two solutions: Galera and RDS Aurora. I’ll use the term “Galera” generically: it covers Galera Cluster, MariaDB Cluster and Percona …
[Read more]Many organizations are shifting toward the cloud, but how much are they moving over? New post explains top five reasons to move your MySQL database to AWS EC2.
The post Top 5 Reasons to Move MySQL to AWS EC2 appeared first on Datavail.
The ConFoo Team is pleased to announce the opening of its call for paper for its Montreal event.
To celebrate its 15th anniversary, CooFoo will be focusing its 2018 Montreal edition on “Experiment & Learn”. Indeed, as Montreal is becoming one of the world emerging AI advanced research centers, disrupting the global innovation scene, we are particularly interested in gathering and exchanging with developers in the AI community.
If you live in Montreal you can be proud ambassadors of this innovative mindset that pervades the developers’ ecosystem. If you come from elsewhere you obviously have a passion for data learning, model development, and the various industries to apply your knowledge (healthcare, finance, automotive…)
Don’t miss this unique opportunity to share your experience with passionate developers. Whether in artificial intelligence or other …
[Read more]
Internet Protocol address is a special kind of data. This data
does not correspond directly to available MySQL built-in data
types. I have seen in many servers, the IP(Internet Protocol)
address is stored in CHAR(12), VARCHAR(15), TEXT and so
on.
The dotted-quad notation is just a way of writing for better
readability, it is not the original form of raw data. The IP
address is a UNSIGNED INTEGERS they are not strings.
So the question is how we can store the IP addresses with dot in
integer columns? The MySQL provides the built-it function to do
this operation. The functions are given below:
For IPv4 addresses:
INET_ATON()mysql> select inet_aton('127.0.0.1');
+------------------------+
| inet_aton('127.0.0.1') |
+------------------------+
| 2130706433 | …I think that very often we are so focus in analyzing internals, or specific behaviours/situations/anomalies that we tend to forget the simple things.
It happened to me that last week a couple of customers raise the
same question: "How ProxySQL manage the default schema,
or the ones declared inside a FROM/JOIN?"
I was a bit surprise because I was given that for granted, and my
first thought was, 'well read the documentation', but
then I realize we do not have a clear section in the
documentation about this.
Given that and also because I realize I had not done a full and
extensive test on how the SCHEMA is actually managed.
I decide to do a simple set of tests and write down few lines.
This blog is to answer that very simple question:"How
ProxySQL manage the default schema, or the ones declared inside a
FROM/JOIN?"
The blog is split in two parts, part 1 …