
MariaDB Galera Cluster Installation
INTRODUCTION: In the last period we encounter a growing interest in MariaDB products (Galera Cluster, MaxScale for example) among our customers. Due to a number of projects related to this platform I would like to concentrate some prominent advantages of the platform and introduce a simple installation of Galera Cluster. Galera is a new kind of clustering engine which, unlike traditional MySQL master-slave replication, provides master-master replication and thus enables a new

Load from csv file into MySQL table
Client’s requirements: The R&D team decided to delete an old non-relevant data of customers in order to decrease database size. The marketing department send this data in CSV format only therefore we need to load these accounts into MySQL temporary table for the future deletes based on this table. Solution: Python scripts that loads an original csv file, remove duplicated accounts and non-relevant columns, loads a new data into another csv file in order to save the previous o

MySQL Server upgrade with minimum downtime
Pavel Zeger is an open - source data platform consultant at NAYA-Tech. MySQL server upgrade with minimum downtime (as a part of migration from Ubuntu to CentOS) We suggested to one of our client to migrate Linux servers from Ubuntu to CentOS and upgrade MySQL instances to new versions. The client’s requirement was minimum downtime of course. Here I’ll describe in-place upgrade process for MySQL 5.6 to MySQL 5.7.17 (last version at the time of upgrade). My preferable Linux dis