Packt+ | Advance your knowledge in tech

You're reading from MariaDB Cookbook Learn how to use the database that's growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily.

Product type Paperback

Published in Mar 2014

Publisher

ISBN-13 9781783284399

Length 282 pages

Edition Edition

Languages

SQL

Tools

MariaDB

Concepts

Databases

Author (1):

Daniel Bartholomew

MariaDB Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

1. Getting Started with MariaDB FREE CHAPTER

2. Diving Deep into MariaDB

3. Optimizing and Tuning MariaDB

4. The TokuDB Storage Engine

5. The CONNECT Storage Engine

6. Replication in MariaDB

7. Replication with MariaDB Galera Cluster

8. Performance and Usage Statistics

9. Searching Data Using Sphinx

10. Exploring Dynamic and Virtual Columns in MariaDB

11. NoSQL with HandlerSocket

12. NoSQL with the Cassandra Storage Engine

13. MariaDB Security

Index

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 the INSERT privilege on the mysql.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, distributed XA transactions, and savepoints, respectively. All three are features that the Cassandra storage engine does not support...