Installing the Cassandra storage engine

Before we can use the Cassandra storage engine, we need to enable it.

How to do it...

1. On Red Hat, CentOS, and Fedora distributions, we may have to install a separate Cassandra storage engine package with the following command:

   sudo yum install MariaDB-cassandra-engine
   

2. Open the mysql command-line client, connect to our MariaDB server as a user with the SUPER privilege and run the following command:

   INSTALL SONAME 'ha_cassandra';
   

3. Still connected to our MariaDB server, run the following command:

   SHOW VARIABLES LIKE "Cassandra%";
   

4. Add the following code to the [mysqld] section of our my.cnf file:

   optimizer_switch = 'join_cache_hashed=on'
   join_cache_level = 7

How it works...

The Cassandra storage engine is included with MariaDB, but it is not enabled by default. To enable it, we will run the INSTALL SONAME command. This is a one-time operation.

The output of the SHOW VARIABLES command will look like the following screenshot:

These variables can be set the same...