The INSTALL SONAME
command is used to install plugins in MariaDB. In this recipe, we'll install the Cassandra storage engine.
Connect to MariaDB using the
mysql
command-line client with a user that has theINSERT
privilege on themysql.plugins
table. The root user has this privilege, but other users might as well.Install the Cassandra storage engine plugin using the following command line:
INSTALL SONAME 'ha_cassandra';
Issue the
SHOW plugins;
command and look for the following text:| CASSANDRA | ACTIVE | STORAGE ENGINE | ha_cassandra.so | GPL |
Next, issue the
SHOW STORAGE ENGINES;
command and look for the following text:| CASSANDRA | YES | Cassandra storage engine| NO | NO | NO |
The preceding output indicates that the Cassandra storage engine is installed and ready to go. The three
NO
columns are about transactions, distributedXA
transactions, andsavepoints
, respectively. All three are features that the Cassandra storage engine does not support...