{"id":2816,"date":"2013-11-11T11:33:22","date_gmt":"2013-11-11T16:33:22","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2816"},"modified":"2013-11-11T11:33:36","modified_gmt":"2013-11-11T16:33:36","slug":"mariadb-10-0-5-storage-engines-check-the-linux-packages","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages","title":{"rendered":"MariaDB 10.0.5 storage engines &#8211; check the Linux packages"},"content":{"rendered":"<p>Today before Ivan&#8217;s tutorial, he told me that in the 10.0.5 virtual machine images he created, he couldn&#8217;t find the Cassandra storage engine. I told him it had to be installed separately, and this is true &#8211; you have to install some engines separately!<\/p>\n<p>When you do a <tt>yum install MariaDB-server MariaDB-client<\/tt> like the <a href=\"https:\/\/mariadb.com\/kb\/en\/installing-mariadb-with-yum\/\">installation instructions<\/a> tell you to do, you don&#8217;t get all storage engines (so running <tt>SHOW ENGINES<\/tt> might have you wondering what happened to a bunch of engines). This can easily be seen by doing a <tt>yum search MariaDB<\/tt>. On a CentOS 6.4 server with the MariaDB 10.0 repository configured, you should see the following:<\/p>\n<pre>MariaDB-cassandra-engine.x86_64 : MariaDB: a very fast and robust SQL database server\nMariaDB-client.x86_64 : MariaDB: a very fast and robust SQL database server\nMariaDB-common.x86_64 : MariaDB: a very fast and robust SQL database server\nMariaDB-compat.x86_64 : MariaDB: a very fast and robust SQL database server\nMariaDB-connect-engine.x86_64 : MariaDB: a very fast and robust SQL database server\nMariaDB-devel.x86_64 : MariaDB: a very fast and robust SQL database server\nMariaDB-server.x86_64 : MariaDB: a very fast and robust SQL database server\nMariaDB-shared.x86_64 : MariaDB: a very fast and robust SQL database server\nMariaDB-test.x86_64 : MariaDB: a very fast and robust SQL database server\n<\/pre>\n<p>So to get Cassandra or CONNECT engine support, don&#8217;t forget to install <tt>MariaDB-cassandra-engine<\/tt> and <tt>MariaDB-connect-engine<\/tt>.<\/p>\n<p>Once you do that, don&#8217;t forget to actually load the engines &#8211; for example you do something like <tt>INSTALL SONAME 'ha_spider.so';<\/tt>.<\/p>\n<p>In fact, why not check out what plugins exist in \/usr\/lib64\/mysql\/plugin? You can also see this from the MariaDB monitor: <tt>SHOW PLUGINS SONAME;<\/tt>. This shows active and non-installed plugins as well. Read the documentation for <a href=\"https:\/\/mariadb.com\/kb\/en\/show-plugins-soname\/\">SHOW PLUGINS SONAME<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today before Ivan&#8217;s tutorial, he told me that in the 10.0.5 virtual machine images he created, he couldn&#8217;t find the Cassandra storage engine. I told him it had to be installed separately, and this is true &#8211; you have to install some engines separately! When you do a yum install MariaDB-server MariaDB-client like the installation [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1064,23],"tags":[1608,1609,1052,1607,65,116],"class_list":["post-2816","post","type-post","status-publish","format-standard","hentry","category-mariadb-databases","category-mysql","tag-cassandrase","tag-connect","tag-mariadb","tag-mariadb-10-0-5","tag-plugins","tag-storage-engine"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Jq","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2816"}],"version-history":[{"count":1,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2816\/revisions"}],"predecessor-version":[{"id":2817,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2816\/revisions\/2817"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}