(Krzysztof Ksiazek) For years, MySQL replication used to be based on binary log events – all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from a master may have ended in different binary logs, and in different positions in these logs.
Tag: Open Source
Running Percona XtraDB Cluster on Windows … in Docker
(Vadim Tkachenko) In this blog post, we’ll look at how to run Percona XtraDB Cluster on Windows using Docker.
Video: MySQL Replication & ClusterControl Product Demonstration
(Art van Scheppingen) The video below details the features and functions that are available in ClusterControl for MySQL Replication. Included in the video are…
MySQL Group Replication: who is the primary master ??
(Frederic Descamps) As you know, MySQL Group Replication runs by default in single primary mode.
Multi-Source Replication
(Ankush Mahajan) A basic MySQL or MariaDB replication arrangement uses a simple method to perform replication. Any changes to schema or data on the master are recorded in its binary log. The slave regularly asks the master for any new entries to its binary log, based on position numbers in that log.
How to setup three nodes MariaDB Galera Cluster on Single server with MySQL sandbox
(Nilnandan Joshi) For the production environment, it’s recommended that we should use separate server for each Galera Cluster node but sometimes, for the testing purpose we have to setup it on one server with different ports.
MySQL InnoDB Cluster – Real-World Cluster Tutorial for OEL, Fedora, RHEL and CentOS
(Francisco Tirado) In this tutorial, we are going to guide you through the process of preparing and configuring RPM based distributions, such as OEL, Fedora or CentOS, for InnoDB cluster usage. We will address the steps from the initial configurations, to the cluster creation, and finally the MySQL
How to Secure MySQL/MariaDB Servers
(Ashraf Sharif) After attacks on MongoDB databases, we have recently also seen that MySQL servers are being targeted by ransomware. This should not come as a surprise, given the increasing adoption of public and private clouds. Running a poorly configured database in the cloud can become a major lia
MySQL InnoDB Cluster – Real-World Cluster Tutorial for Ubuntu and Debian
(Francisco Tirado) In this tutorial, we are going to guide you through the whole process of configuring Debian based distributions for InnoDB cluster usage; the most popular being Ubuntu.
Network attacks on MySQL, Part 3: What do you trust?
(Daniel van Eeden) In my previous blogs I told you to enable SSL/TLS and force the connection to be secured. So I followed my advice and did forced SSL. Great!
