- Daniël van Eeden (for the Community)
- Art van Scheppingen (for the Community)
- Giuseppe Maxia (for the Community)
- Aurélien Lequoy (for the Community)
- Tom de Cooman (for Percona)
This event is a real success story for the MySQL ecosystem; the content, the speakers and the attendees are growing every year.
The first big change for this 2019 edition is that the MariaDB Foundation (Ian) is joining my efforts to build this Devroom. Don’t forget that FOSDEM takes place in Belgium, and our motto is “l’Union fait la Force” [“Unity is Strength”].[Read more]
The FOSDEM organization just confirmed that again this year the ecosystem of your favorite database will have its Devroom !
More info to come soon, but save the day: 2 & 3rd February 2019 in Brussels !
It seems the MySQL & Friends Devroom (MariaDB, Percona, Oracle, and all tools in the ecosystem) will be held on Saturday (to be confirmed).
Stay tuned !
This blog will show how to install the Percona XtraDB Cluster on three CentOS 7.3 servers, using the packages from Percona repositories. This is a step-by-step installation and configuration blog, We recommend Percona XtraDB Cluster for maximum availability / reliability and scale-out READ/WRITE optimally. We are an private-label independent and vendor neutral consulting, support, managed services and education solutions provider for MySQL, MariaDB, Percona Server and ClickHouse with core expertise in performance, scalability, high availability and database reliability engineering. All our blog posts are purely focussed on education and research across open source database systems infrastructure operations. To engage us for building and managing web-scale database infrastructure operations, Please contact us on firstname.lastname@example.org
This cluster will be assembled of three servers/nodes:
ProxySQL is the most preferred and is widely used for load-balancing MySQL workload, thanks to Rene Cannon & Team for the great tool, and kudos on the recent release of ProxySQL 1.4.10, with a lot of bug fixes. ProxySQL is simple in design, lightweight, highly efficient and feature rich, We have been working with ProxySQL in production for our client quite a sometime, we have also shared some of our encounters/experience and use cases in the below blogs.[Read more]
I just posted an article on the Percona Community Blog. You can access it following this link:
A Nice Feature in MariaDB 10.3: no InnoDB Buffer Pool in Core Dumps
I do not know if I will stop publishing posts on my personal blog or use both, I will see how things go. In the rest of this post, I will share why I published there and how things went in the process.
So there is a Percona
This is the 5th blog in series of Maxscale blog, Below is the list of our previous blogs, Which provides deep insight for Maxscale and its use cases for different architectures.
- Scale with Maxscale part -1 (Intro & Galera Cluster)
- Scale with Maxscale part – 2 (Administration, Installation & operation)
- Scale with Maxscale part – 3 (Replication M-S)
So when it comes to routing your MySQL traffic several options
- MariaDB MaxScale
- MySQL Router
- You can even still get MySQL Proxy if you wanted it but it is EOF.
Now I have seen HAproxy used more often with clients, it is pretty straight forward to set up. Percona has an example for those interested:
Encryption is a very important form of security and It’s becoming a standard from a compliance perspective to ensure PCI, PII and HIPPA compliances. Encryption needs to be performed for Data at Rest, Data over Wire.
Data At Rest:
- Until 5.6, To encrypt the MySQL data files, Only disk level encryption possible (Gazzang, Luks)
- From 5.7.11 MySQL added a feature for tablespace encryption. Which encrypts only the …
In this blog post, We will be explaining about the timeouts in SST on systemd implementation which we faced recently in Percona XtraDB Cluster during our Consulting with a client. State Snapshot Transfers (SST) refers to complete data sync from one of the nodes from the cluster to the joining node.
SST will happen for one or more reasons listed below.
- Initial sync to join a node to cluster.
- Node is out of cluster and lost its ability to join back due to data corruption or inconsistencies and also when the node went far behind the node, …