Before we can use the Cassandra storage engine, we need to enable it.
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
Open the
mysql
command-line client, connect to our MariaDB server as a user with theSUPER
privilege and run the following command:INSTALL SONAME 'ha_cassandra';
Still connected to our MariaDB server, run the following command:
SHOW VARIABLES LIKE "Cassandra%";
Add the following code to the
[mysqld]
section of ourmy.cnf
file:optimizer_switch = 'join_cache_hashed=on' join_cache_level = 7