In the last couple of blogs, we covered how to run a Galera Cluster on Docker, whether on standalone Docker or on multi-host Docker Swarm with overlay network. In this blog post, we’ll look into running Galera Cluster on Kubernetes, an orchestration tool to run containers at scale. Some parts are different, such as how the application should connect to the cluster, how Kubernetes handles failover and how the load balancing works in Kubernetes.

Kubernetes vs Docker Swarm

Our ultimate target is to ensure Galera Cluster runs reliably in a container environment. We previously covered Docker Swarm, and it turned out that running Galera Cluster on it has a number of blockers, which prevent it from being production ready. Our journey now …

In this post, we’ll use a blog poll to find out what operating system you use to run your production database servers.

As databases grow to meet more challenges and expanding application demands, they must try and get the maximum amount of performance out of available resources. How they work with an operating system can affect many variables, and help or hinder performance. The operating system you use for your database can impact consumable choices (such as hardware and memory). The operation system you use can also impact your choice of database engine as well (or vice versa).

Please let us know what operating system you use to run your database. For this poll, we’re asking which operating system you use to actually run your production database server (not the base operating system).

If you’re running …

Recently I posted a blog on my time attending a DevOps event in Toronto.  In that blog I had intended to focus on the conference and highlight some of the topics that stood out for me.  In this blog though, I wanted to share what others were doing with containers like Docker, and particularly and… Read More »

We sat down with Severalnines Senior Support Engineer Krzysztof Książek to discuss the upcoming webinar MySQL Tutorial - Backup Tips for MySQL, MariaDB & Galera Cluster.

ClusterControl Single Console for Your Entire Database Infrastructure Find out what else is new in ClusterControl Install ClusterControl for FREE ClusterControl for MySQL Backup

ClusterControl provides you with sophisticated backup and failover features with a point-and-click interface to easily restore your data if something goes wrong. These advanced automated failover and backup technologies ensure your mission critical …

HopsFS that implements Hadoop HDFS on top of MySQL Cluster 7.5
won the IEEE Scale Challenge 2017.

HopsFS demonstrated a workload that scaled to more than 1 million
file operations per second. HopsFS is an application that uses
our native Java API called ClusterJ to implement Hadoop HDFS.

I recently attended DevOpsDays Toronto 2017, my first proper DevOpsDaysTO event.  I had the pleasure of attending and being able to immerse myself in this openly collaborative and supportive culture of IT professionals.  The variety of considerations expressed for delivering software features in a rapidly, frequently and reliable release focused manner was really intriguing….but not without its own complexities.… Read More »

In this blog post, I’ll look at how ProxySQL Admin behaves in some unusual and unexpected ways from a MySQL perspective.

ProxySQL allows you to connect to its admin interface using the MySQL protocol and use familiar tools, like the MySQL command line client, to manage its configuration as a set of configuration tables. This ability may trick you into thinking that you’re working with a stripped-down MySQL server – and expect it to behave like MySQL. 

It would be a mistake to think this! In fact, ProxySQL embeds the SQLite database to store its configuration. As such, it behaves much closer to SQLite!

Below, I’ll show you a few things that confused me at first. All of these are as of ProxySQL 1.3.6 (in case behavior changes in the future).

Fake support for Use command

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.31, MariaDB Connector/J 2.0.2, and MariaDB Connector/J 1.6.1. See the release notes and changelogs for details. Download MariaDB Galera Cluster 10.0.31 Release Notes Changelog What is MariaDB Galera Cluster? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/J 2.0.2 Release […]

The post MariaDB Galera Cluster 10.0.31 and Connector/Java 2.0.2 now available appeared first on MariaDB.org.

MySQL documentation has much improved code examples now: There's syntax highlighting in place, and code snippets can easily be copied to the clipboard. Highlighting is language-aware (including "languages" like the shell/command line). See, for example, this page from the X DevAPI documentation that contains a number of code examples for different programming languages.

Syntax highlighting is a project we planned a year ago, but it turned out to be more complex than we thought it would be. One of the major challenges was performance -- we didn't want the new function to slow down page loading, which is what many highlighting plugins do. Eventually, our striving Web team gave prism.js a try, which works like a charm and doesn't impact performance at all. The Web team also created a little …

MySQL documentation has greatly improved code examples now: There's syntax highlighting in place, and code snippets can easily be copied to the clipboard. Highlighting is language-aware (including "languages" like the shell/command line). See, for example, this page from the X DevAPI documentation that contains a number of code examples for different programming languages.

Syntax highlighting is a project we planned a year ago, but it turned out to be more complex than we thought it would be. One of the major challenges was performance -- we didn't want the new function to slow down page loading, which is what many highlighting plugins do. Eventually, our striving Web team gave prism.js a try, which works like a charm and doesn't impact performance at all. The Web team also created a little …