Using INSTALL SONAME

The INSTALL SONAME command is used to install plugins in MariaDB. In this recipe, we'll install the Cassandra storage engine.

How to do it...

1. Connect to MariaDB using the mysql command-line client with a user that has the INSERT privilege on the mysql.plugins table. The root user has this privilege, but other users might as well.

2. Install the Cassandra storage engine plugin using the following command line:

   INSTALL SONAME 'ha_cassandra';
   

3. Issue the SHOW plugins; command and look for the following text:

   | CASSANDRA | ACTIVE | STORAGE ENGINE | ha_cassandra.so | GPL | 
   

4. Next, issue the SHOW STORAGE ENGINES; command and look for the following text:

   | CASSANDRA | YES | Cassandra storage engine| NO | NO | NO | 
   

5. The preceding output indicates that the Cassandra storage engine is installed and ready to go. The three NO columns are about transactions, distributed XA transactions, and savepoints, respectively. All three are features that the Cassandra storage engine does not support...