[MDEV-4538] Cassandra Storage Engine Missing from 10.0.2 mariadb-10.0.2-linux-x86_64.tar.gz Created: 2013-05-16  Updated: 2014-04-15  Resolved: 2013-05-30

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.2
Fix Version/s: 10.0.2

Type: Bug Priority: Major
Reporter: Robert Wagner Assignee: Daniel Bartholomew
Resolution: Fixed Votes: 0
Labels: cassandra
Environment:

Linux x86_64

Issue Links:
Relates
relates to MDEV-4534 Cassandra Storage Engine Missing from... Closed

 Description   

Documentation says the Cassandra Storage Engine has been part of MariaDB since 10.0.1. However, 10.0.2 Linux tar.gz file does not contain the Cassandra Storange Engine.

From:
https://kb.askmonty.org/en/cassandra-storage-engine/
Where to get it

Cassandra storage engine is a part of [what-is-mariadb-100|MariaDB 10.0], starting from MariaDB 10.0.1.

Output of Show Engines:

mysql> show engines;
 
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
 
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
 
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
 
| FEDERATED          | YES     | FederatedX pluggable storage engine                            | YES          | NO   | YES        |
 
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
 
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
 
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
 
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
 
| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
 
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
 
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
 
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
 
| Aria               | YES     | Crash-safe tables with MyISAM heritage                         | NO           | NO   | NO         |
 
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
 
10 rows in set (0.00 sec)

Please fix documentation to identify exactly which file include the Cassandra Storage Engine and/or what is needed to have it working.

 Comments   
Comment by Elena Stepanova [ 2013-05-16 ]

Hi,

We have two pairs of binary tarballs – "mariadb-10.0.2-linux-x86_64.tar.gz" and "mariadb-10.0.2-linux-x86_64.tar.gz (requires GLIBC_2.14+)".
You need to use the latter one, which has the note "GLIBC_2.14+".
And indeed, it should be documented.

Please also note that Cassandra engine comes as a plugin (ha_cassandra.so), so you need to install it either with INSTALL PLUGIN / INSTALL SONAME, or with --plugin-load on startup.

MariaDB [(none)]> install soname 'ha_cassandra.so';
Query OK, 0 rows affected (0.31 sec)

MariaDB [(none)]> show engines;
-------------------------------------------------------------------------------------------------------------------+

Engine Support Comment Transactions XA Savepoints

-------------------------------------------------------------------------------------------------------------------+

InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES
CSV YES CSV storage engine NO NO NO
MyISAM YES MyISAM storage engine NO NO NO
BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO
FEDERATED YES FederatedX pluggable storage engine YES NO YES
MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO
ARCHIVE YES Archive storage engine NO NO NO
MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO
PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
Aria YES Crash-safe tables with MyISAM heritage NO NO NO
CASSANDRA YES Cassandra storage engine NO NO NO

-------------------------------------------------------------------------------------------------------------------+
11 rows in set (0.00 sec)

MariaDB [(none)]> select @@version;
----------------

@@version

----------------

10.0.2-MariaDB

----------------
1 row in set (0.00 sec)

Comment by Daniel Bartholomew [ 2013-05-30 ]

Issue fixed AFAIK, so closing.

Comment by Dmytro Andriychenko [ 2014-04-15 ]

This is not fixed at all! This plugin is still missing event in the most recent 10.0.10... I have tried Windows, Fedora 20, Centos - no luck on any of the installations, all the same.

Please Please Please let me know how to get hold of this elusive plugin, I really want to try this feature!

Thank you very much in advance,

Dmytro

Comment by Elena Stepanova [ 2014-04-15 ]

The plugin exists on Centos 6, Fedora 19, Fedora 20 and can be installed via yum or downloaded as a separate RPM package (MariaDB-10.0.10-fedora20-x86_64-cassandra-engine.rpm)

It is also included in Squeeze, Wheezy, Lucid, Precise, Saucy, Trusty deb packages as a library.

Regarding the binary tarball, at some point this bug was fixed, but now the plugin is missing there again due to some build problems. It will be fixed in future releases.

Comment by Dmytro Andriychenko [ 2014-04-15 ]

Thank you ever so much for taking your time to reply. Is there any hope of getting a binary for Cassandra engine for Windows? There does not appear to be a separate download for windows and the dll for Cassandra engine plugin is missing, too?

For the benefit of other Linux users, you can download appropriate Cassandra engine binary for your Linux clone here: https://downloads.skysql.com/files/MariaDB/mariadb-10.0.10/yum/

Comment by Dmytro Andriychenko [ 2014-04-15 ]

Dear Elena,

Thank you ever so much for your help resolving the problem of missing
Cassandra SE plugin binary in MariaDB release 10.0.10 for Linux.

Is there any chance at all I can get Cassandra SE plugin for Windows? I
tried a few versions back - the binary is missing for all versions for
windows that I have tried…

I need to make sure this feature is present in both Windows and Linux
installation as we have a case for both environments.

Thank you ever so much in advance,

Kindest regards,

Dmytro

Dmytro Andriychenko

Senior SQL Server Consultant

Tel: 07758781262

*Dmytro@data-united.co.uk
<Dmytro@data-united.co.uk> | www.data-united.co.uk
<http://www.data-united.co.uk/>*

On 15 April 2014 12:00, Elena Stepanova (JIRA)

Comment by Elena Stepanova [ 2014-04-15 ]

Hi Dmytro,

Please see the comment from Cassandra SE developer to MDEV-4535:

Comment by Dmytro Andriychenko [ 2014-04-15 ]

Thank you, that explains it, much appreciated. I take it there are no current plans to implement windows support since there is no userbase.

Kindest regards,

Dmytro

Generated at Thu Feb 08 06:57:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.