O'Reilly logo

Mastering MariaDB by Federico Razzoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Starting the nodes

Starting a MariaDB Galera Cluster node means to start a MariaDB server so that we can call the mysqld binary or the mysqld_safe script.

Before starting a node for the first time, we should prepare the configuration file. The following example shows a minimal configuration:

wsrep_provider=/usr/lib/galera/libgalera_smm.so
default_storage_engine=InnoDB
binlog_format=ROW
innodb_autoinc_lock_mode=2
innodb_doublewrite=0
innodb_support_xa=0
query_cache_size=0

Here's an explanation of the options we set:

  • The wsrep_provider option is the most important. It tells Galera where the wsrep library is located. Its path depends on your system.
  • Since storage engines other than InnoDB should not be used, it is important to set default_storage_engine ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required