In case you missed the Multimaster webinar recorded live on Thursday, March 28th, 2019:

Learn how NewVoiceMedia built a global, multi-region MySQL cloud back-end to support a high-volume cloud contact center. 

Agenda:

Find out how to deploy Multimaster MySQL / MariaDB / Percona with the following design criteria:

• Geographically distributed, low-latency data
• Fast local response times for read & write traffic
• Full ACID compliance – atomic operations, guaranteed consistency, isolation, and durability
• Local rapid-failover, automated high availability

Speaker:

Chris Parker

Director of Professional Services – EMEA/APAC, is based in the UK, and has over 20 …

We started hosting Percona University a few years back with the aim of sharing knowledge with the open source database community. The events are held in cities across the world. The next Percona University days will visiting Uruguay, Argentina, and Brazil, in a lightning tour at the end of April.

• Montevideo, Tuesday, April 23 2019 from 8.30am to 6.30pm
• Buenos Aires, Thursday, April 25 2019 from 1.30pm to 10.3pm
• São Paulo, Saturday, April 27 2019 from 9.30am to 7.30pm

What is Percona University?

It is a technical …

I strongly believe in the community.

Communities are the real strength of open source. Not just the theoretical ability to study, modify and share code – but the fact that other people out there are doing these things. Creating a base of knowledge and a network of relations.These can become work relationships, valuable discussions, open source tools, or even friendships.

That is why, when I heard that several people from the Percona support team will soon be in London, I badly wanted to organise an event.

Actually, there was an interesting coincidence. When I asked Sveta Smirnova if anyone from Percona lives in London, I already knew I wanted to organise an event with this new meetup group I’ve started: …

For those of you who missed the webinar, “Geo-Scale MySQL in AWS,” recorded live on Thursday, March 14th, 2019:

Learn how to build a global, multi-region MySQL / MariaDB / Percona cloud back-end capable of serving hundreds of millions of online multiplayer game accounts.

Agenda:

Find out how Riot Games serves a globally distributed audience with low-latency, fast response times for read traffic, rapid-failover automated high availability, simple administration, system visibility, and stability.

Speaker:

Eric M. Stone

COO at Continuent, is a veteran of fast-paced, large-scale enterprise environments with 35 years of Information Technology experience. With a focus on HA/DR, from building data centers and trading floors to world-wide deployments, Eric has …

MariaDB OpenWorks happened February 25 – 27, 2019 in New York City. It was filled with plenty of activity.

The keynote by Michael Howard, C.E.O. of MariaDB, is an interesting watch, one with many quoted articles especially around “strip-mining open-source technologies and companies,” and “abusing the license and privilege, and not giving back to the community.” Many articles were written about this topic, and it’s clear that open-source has arrived considering all of the success around the IBM acquisition of Red Hat, the Elastic I.P.O., the Microsoft acquisition of GitHub, the SalesForce acquisition fo MuleSoft and the MongoDB I.P.O.

Seppo Jaakola, the C.E.O. of Codership, talked about …

The much anticipated release of Galera 4 makes its way first in the latest release of MariaDB Server 10.4.3 Release Candidate which you can download now. Congratulations to MariaDB Corporation and MariaDB Foundation on this release candidate — please get testing Galera 4, and share your feedback with us via our Google Group discussion list! Do not forget that you can always reach us via email: mailto:info@galeracluster.com and via our contact us form.

The feature we are excited about the most, is a feature request from many users. This is none other than huge transaction …

I wanted to take a moment to write up a post on MariaDB MaxScale’s masking basics and include some real-world examples.

We have nice documentation on the subject, and Dipti wrote a nice blog post on it as well. I just wanted to provide my take on it, and hopefully build upon what is already there and offer some additional insights.

To provide a 50-foot overview, the masking filter makes it possible to obfuscate the returned value of a particular column.

3 quite common columns where this would be very beneficial: Social Security Number (“SSN”), Date of Birth (“DOB”), and Credit Card Number (“CCNUM”).

To use masking, it assumes you already have a MaxScale service up and running. For instance, the readwrite …

Recently, I had to work on an emergency for a customer who was having a problem restarting a MariaDB Galera Cluster. After a failure in the cluster they decided to restart the cluster entirely following the right path: bootstrapping the first node, and then adding the rest of the members, one by one. Everything went fine until one of the nodes rejected the request to join the cluster.

Given this problem, the customer decided to ask us to help with the problematic node because none of the tests they did worked, and the same symptom repeated over and over: SST started, copied few gigs of data and then it just hanged (apparently) while the node remained out of the cluster.

Identifying the issue…

Once onboard with the issue, initially I just checked that the cluster was trying a SST: given the whole dataset was about 31GB I decided to go directly to a healthy solution: to clean up the whole datadir and start afresh. No luck …

Those of you who know me know that I don’t travel often.

So it’s kind of a big deal, at least for me, that I will be at OpenWorks in NYC later this month!!!

If you’re planning on attending, please stop by and say “hi”! I’ll be helping in the Security Workshop on Monday, or you can find me at one of the Expert Bars Tuesday and Wednesday.

If you’re on the fence about attending, please message (or email) me for a significant discount code (if that might help you decide or help persuade your manager!).

Anyway, I’m excited to be going, and I hope to see you there!

MariaDB OpenWorks

Dates: February 25th – February 27th

While the PMM team works hard on our PMM 2.0 release, we have been working on a few things in the background which we’d like to show off !  In particular we have developed a new dashboard that displays metrics related to memory usage on Linux systems. The dashboard leverages information collected by node_exporter. The graphs take advantage of  /proc filesystem files, specifically:

• meminfo: Provides information about distribution and utilization of memory. This varies by architecture and compile options.
• vmstat: Provides information about block IO and CPU activity in addition to memory.

…