Please join Percona’s Senior Consultant, Jervin Real, as he presents Migrating to AWS Aurora: A Checklist for Success. The event will take place on Tuesday, September 11th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).
In the last few weeks, we have shown you how to successfully migrate from on-premise MySQL installations to AWS Aurora. What comes next is how to successfully ensure that your Aurora cluster performs and operates as you expect it to.
While …
[Read more]The MySQL database is used in thousands of third-party applications, but what can you do when you want to use MySQL with an application, but that application’s queries or data doesn’t match MySQL’s data type or SQL format?
This post will show you three ways to alter a query or mismatched data when you don’t have control of the application’s source code. Of course, there are hundreds of different ways to do what I am about to show you. In this example, I will show you how to use the MySQL Query Rewrite Plugin along with a trigger to alter the non-conforming data. I will also show you an example of manipulating data with a stored procedure.
A customer emailed me with a problem. They wanted to use …
[Read more]Introduction to resource groups in MySQL 8 and dynamical allocation to threads
The post MySQL 8 Resource Group – introduction and dynamic allocation first appeared on Change Is Inevitable.
I wrote MySQL and JSON: A Practical Programming Guide
to help developers find their way around the MySQL JSON data type
and the supporting functions. The MySQL Documentation on the
subject is very good but I had to puzzle through the examples to
see how things worked. I might be a bit 'thick' but good
examples always make things easier. Others seem to have
similar difficulties.
| MySQL and JSON a Practical Programming Guide should be on your desk as a handy reference to MySQL's JSON data type. |
There was a recent post on …
This is the same plugin that Alex Gorvachev created back in the day. I’ve simply modified it to be compatible with both 12c and 13c versions.
I created this in response to a comment on the blog about issues deploying the plugin in OEM 13c. There is also a note in MOS “EM 13c: Adding a MySQL Instance in Enterprise Manager 13c Fails with Error: oracle.sysman.emSDK.agent.client.exception.NoSuchMetricException: the Load metric does not exist (Doc ID 2160785.1)“.
This version has been tested with OEM 13cR2 and OEM 12cR3, so it should be working in all the versions in between except for bugs.
Caveats
During the …
[Read more]
Peter Zaitsev of Percona posted a Tweet about an interactive
book Select Star SQL which 'aims to be the best place
on the internet for learning SQL'. This interactive book
uses a data set that can be downloaded or you could work the
queries online. I showed the website to a neighbor who was
asking 'what is the best way to learn SQL'. The
neighbor wanted their own copy of the data and asked how do you
turn a raw CSV file into a table.
Well, that can get complicated.
CSV
CSV files use commas to designate each field in the file.
This is a great idea until someone plants a comma in the middle
of a field but it is sort of a least common denominator way of
passing data between systems.
But a CSV file does not directly fit into a relational
table. You could …
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible.
We’ve included a plethora of visual improvements in this release, including:
Do you need to modify the metrics collected from Linux by Percona Monitoring and Management (PMM)? In this blog post we will see how to enable, disable, and update collected metrics on PMM’s linux:metrics exporter.
We will assume that the PMM client packages are installed, and they are configured already.
Using a custom list of metrics
Let’s now suppose we are not yet collecting any metrics on our desired client server, and we want to enable only the following: diskstats, meminfo, netdev and vmstat. We can use the following …
[Read more]Please join Percona’s Chief Technology Officer, Vadim Tkachenko, as he presents Running MySQL in Kubernetes on Thursday, September 6th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).
Without question, Kubernetes is the most popular container orchestration platform. But can it handle databases? I think so, and in this webinar, I will show you how it does it. This talk presents a quick overview of the persistent storage options (the most critical part of data storage) and then what it takes to run highly available MySQL …
[Read more]In his excellent blog post, Pavel Trukhanov showed the value of S.M.A.R.T. metric collections, so I wondered how hard would it be to enable their collection in Percona Monitoring and Management (PMM)
A quick search led me to the text_collector plugin SmartMon, which can be easily integrated with any Prometheus Installation
For PMM, Vadim Yalovets recently showed how to do …
[Read more]
