In my previous post I've presented a list of bugs reported by famous MySQL developers, DBAs, users and support engineers who used oprofile to find the problem or root cause of the problem they studied. I assume that some of my readers would like to follow their steps and try to use this tool while working on MySQL performance problems. Bug reports I mentioned contain outputs and, rarely, just some commands used. That's why I decided to write a kind of a basic "Howto" document. The tool does have a detailed enough manual, but few basic steps for quick use of oprofile to study MySQL-related problems should still help. At least I had always considered …[Read more]
10 Older Entries »
In my previous post, we saw the usage of MySQL Group Replication (MGR) in single-primary mode. We know that Oracle does not recommends using MGR in multi-primary mode, but there is so much in the documentation and in presentations about MGR behavior in multi-primary, that I feel I should really give it a try, and especially compare this technology with the already existing multiple master solution introduced in 5.7: multi-source replication.
To this extent, I will set up two clusters using MySQL-Sandbox. The instructions for MGR in …[Read more]
Users had to identify the reasons for MySQL performance problems
somehow well before famous Performance Schema appeared in MySQL 5.5.3,
and even before Domas invented his Poor Man's Profiler. Poor users had
to use some OS-level tools, and among these tools the most
important one was, probably, oprofile.
oprofile is a system-wide statistical profiling tool for Linux available since 2001 and 2.4.x kernels. It was applied to MySQL for many …
Several customers and other people from the open source community have asked us how they could make their own Percona Server for MySQL RPM binaries from scratch.
This request is often made by companies that want to add custom patches to our release. To do this, you need to make some modifications to the
file in the source tree, and some preparation is necessary.
This post covers how you can make your own RPMs from GIT or source tarball so that you can build RPMs from your own modified branch, or by applying patches. In this example, we’ll build Percona Server 5.7.16-10.
Making your own RPMs is not a recommended practice, and should rarely be …[Read more]
Monitoring MariaDB with the All New Monyog v7.0 julienfritsch Fri, 01/20/2017 - 11:02
MariaDB monitoring tool, Monyog, provides insights into server performance with a customizable dashboard. Webyog just announced the launch of the new Monyog v7.0! With this new release, MariaDB customers will get access to a completely revamped Monyog user interface and industry-leading feature additions to uncover valuable server performance insights, including:
- Monitor Top 10 Queries Across All Servers – Save time and resources with an extensive view of the state of MariaDB servers under one roof.
- Customizable Dashboard and Enhanced Chart Performance – Choose to create and customize monitoring dashboards, and enable or disable MySQL and system charts, to best analyze your server performance.
- Replication Topology View – Gain visibility into the replication hierarchy of servers along with the details of each …
As you know pre-FOSDEM MySQL Day will take place on Friday February 3rd in Brussels. During this day dedicated to MySQL and focusing on 8.0, Norvald will be on stage at 16.50 to check if you are ready for MySQL 8.0’s GIS implementation.
Many great things are happening to GIS in MySQL 8.0. But in order to move forward, we also have to break legacy behavior. What will change? How? Why? And what can I do to avoid problems when I upgrade?
Join Norvald for a tour of changes and recommendations that you
can start following today to make your data and applications
ready for the future.
This post is part of the series "please do not ignore warnings in MySQL/MariaDB". The previous post of the series can be found here.
In this post, I will present why ignoring warnings made me lose time in upgrading MariaDB Server. I think this war story is entertaining to read and it is also worth presenting to people claiming that ignoring warnings is no big deal.
A few months ago, I was in
With the recent release of ClusterControl 1.4.0, we added a bunch of new features to better support MySQL replication users. In this blog post, we’ll give you a quick overview of the new features.
Enhanced multi-master deployment
A simple master-slave replication setup is usually good enough in a lot of cases, but sometimes, you might need a more complex topology with multiple masters. With 1.4.0, ClusterControl can help provision such setups. You are now able to deploy a multi-master replication setup in active - standby mode. One of the masters will actively take writes, while the other one is ready to take over writes should the active master fail. You can also easily add slaves under each master, right from the UI.
Enhanced flexibility in replication topology management
With support for multi-master setups comes improved support for managing replication topology changes. Do you want to re-slave a slave off …[Read more]
ProxySQL is a high performance proxy for MySQL and its forks. One of the key features is its ability to handle hundreds of thousands of connections with very low overhead. Datadog is a monitoring service for cloud-scale applications, bringing together data from servers, databases, tools, and services to present a unified view of an entire stack.
Datadog does not yet provide an integration for ProxySQL. So I decided to write an integration by forking the Datadog agent. Read my detailed blog post on TwinDB Blog to learn how to use the ProxySQL-Datadog integration.
In this blog post, we’ll look at how to set up ProxySQL for high availability.
During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting MySQL: ProxySQL.
The tool is a winner when compared to similar ones, and we should all have a clear(er) idea of how to integrate it in our architectures in order to achieve the best results.
The first thing to keep in mind is that ProxySQL doesn’t natively support any high availability solution. We can setup a cluster of …[Read more]
10 Older Entries »