Details
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.
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-4534 Cassandra Storage Engine Missing from 10.0.2 Centos 5 rpms
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Issue fixed AFAIK, so closing.
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
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.
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/
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)
Hi Dmytro,
Please see the comment from Cassandra SE developer to MDEV-4535:
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
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;
-------------------
------------------------------------------------------------------------------------------------+-------------------
------------------------------------------------------------------------------------------------+-------------------
------------------------------------------------------------------------------------------------+11 rows in set (0.00 sec)
MariaDB [(none)]> select @@version;
----------------
----------------
----------------
1 row in set (0.00 sec)