Tag: database

As I have written before, Racket is used for implementing most of our tooling and helper applications both for the Cryptoucan™ development and for other back-end tasks as well. You can rightfully guess that most of the bookkeeping programs need to access various databases and although accessing databases is super-convenient in Racket, with some databases on weird platforms, strange problems may arise. Read on to see one of the more interesting and also to see how to resolve such issues.

Striving for high-availability of some software systems requires ensuring their individual components are reliable and usually redundant. A typical example of such component is a SQL database - MariaDB being the case we had to handle this time.

We decided to go for MariaDB Galera cluster on CentOS and I would like to write about our experience here. We have chosen active-active (master-master) design with two nodes called nodeA and nodeB having IP addresses 192.168.0.1 and 192.168.0.2 respectively.