In this blog, we’ll look at how to manually build Percona Server for MySQL RPM packages.

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

percona-server.spec

 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 …

Let’s finish this pre-FOSDEM MySQL Day Sessions review week with Norvald Ryeng‘s talk on MySQL 8.0 and GIS.

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.
If …

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

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.

The post Monitoring ProxySQL using Datadog appeared first on ovais.tariq.

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.

ProxySQL is becoming more flexible, solid, performant and used every day (http://www.proxysql.com/ and recent http://www.proxysql.com/compare). You can use ProxySQL for high availability.

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 …

Today I will present the unique ProxySQL session of the pre-FOSDEM MySQL Day. Alkin Tezuysal will share with the audience ProxySQL Use Case Scenarios

Alkin is Senior Technical Manager at Percona and has extensive experience in enterprise relational databases working in various sectors for large corporations. With more then 20 years of industry experience he has acquired skills for managing large projects from ground up to production. For the past six years he’s been focusing on e-commerce, SaaS and MySQL technologies. He managed and architected database topologies for high volume site at eBay Intl. He has several years of experience on 24X7 support and operational tasks as well as improving …

Hi dear MySQL Community,

I would like to start this post by saying thanks to our sponsors:

Unfortunately, we are missing one sponsor and to not increase the ticket price but at the same time keep the level of quality for food then promised and the same diversity for our world famous Belgian beer patrimony, we are still looking for one …

In a last post, I wrote the two following sentences:

please do not ignore warnings always investigate/fix warnings

I realized that without context, this might be hard to understand.  In this post, I want to give more background about these two sentences.

In my work, I have seen problems solved (wrongly) by ignoring warnings.  Some example that comes to my mind:

upgrading to a new MySQL

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.21, MariaDB 10.0.29, MariaDB Galera Cluster 10.0.29, MariaDB Connector/J 1.5.7, MariaDB Connector/C 2.3.2, and MariaDB Connector/C 3.0.1 Beta. Apart from the Connector/C 3.0.1 Beta these are all stable (GA) releases. See the release notes and changelogs for details. Download MariaDB 10.1.21 Release Notes […]

The post MariaDB 10.1.21 and other releases now available appeared first on MariaDB.org.

CentOS 7 Systemd issue with Percona Cluster is that SST fails to sync the nodes, unable to join cluster group and giving the misleading broken pipe 32 SIG errors.

The post How to Resolve Systemd Issue with Percona XtraDB Cluster on CentOS 7 appeared first on Datavail.