{"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":"http:\/\/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<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MariaDB%2010.0.5%20storage%20engines%20-%20check%20the%20Linux%20packages&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2013%2F11%2F11%2Fmariadb-10-0-5-storage-engines-check-the-linux-packages&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"3159dd7afa\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2816\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-2816\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-2816\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","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<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MariaDB%2010.0.5%20storage%20engines%20-%20check%20the%20Linux%20packages&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2013%2F11%2F11%2Fmariadb-10-0-5-storage-engines-check-the-linux-packages&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"3159dd7afa\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2816\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-2816\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-2816\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[1064,23],"tags":[1608,1609,1052,1607,65,116],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Jq","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2744,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/06\/12\/mariadb-10-0-3-installing-the-additional-engines","url_meta":{"origin":2816,"position":0},"title":"MariaDB 10.0.3: installing the additional engines","date":"12\/6\/2013","format":false,"excerpt":"So MariaDB 10.0.3 Alpha is out. Download it\u00a0and remember to provide feedback. When you run SHOW ENGINES by default, you don't get CassandraSE or the CONNECT engine. Make sure you do a yum install MariaDB-cassandra-engine and a yum install MariaDB-connect-engine.\u00a0 You will run into conflicts if you had an older\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2838,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/12\/02\/upcoming-mariadb-10-0-7-will-have-more-engines-mroonga-oqgraph","url_meta":{"origin":2816,"position":1},"title":"Upcoming MariaDB 10.0.7 will have more engines &#8211; mroonga, OQGRAPH","date":"2\/12\/2013","format":false,"excerpt":"In recent time, MariaDB 10 has been getting many new storage engines. We've seen TokuDB, CONNECT, SEQUENCE, SPIDER, CassandraSE for various use cases. For a long time, MariaDB shipped OQGRAPH, but it was disabled in MariaDB 5.5. It will make a come back as OQGRAPH v3 has been worked on\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2938,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/06\/11\/rhel7-now-with-mariadb","url_meta":{"origin":2816,"position":2},"title":"RHEL7 now with MariaDB","date":"11\/6\/2014","format":false,"excerpt":"Congratulations to the entire team at Red Hat, for the release of Red Hat Enterprise Linux 7 (RHEL7). The release notes have something important, under Web Servers & Services: MariaDB 5.5 MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of\u2026","rel":"","context":"In &quot;Distributions&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2771,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/08\/19\/spider-in-mariadb","url_meta":{"origin":2816,"position":3},"title":"SPIDER in MariaDB","date":"19\/8\/2013","format":false,"excerpt":"One thing you might have missed from the MariaDB 10.0.4 Alpha release announcement is that SPIDER is finally in-tree, inside MariaDB. I've been watching the SPIDER engine for quite some years and fondly remember the time when Kentoku Shiba dressed up as spiderman at a MySQL Conference. There are many\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1728,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2010\/04\/02\/mariadb-5-1-44-released","url_meta":{"origin":2816,"position":4},"title":"MariaDB 5.1.44 released","date":"2\/4\/2010","format":false,"excerpt":"Dear MariaDB users, MariaDB 5.1.44, a new branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches, has been released. This release is based on MySQL 5.1.44. In includes performance improvements with Maria temporary tables, removal of mutexes and the\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2673,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/03\/15\/using-mariadb-on-centos-6","url_meta":{"origin":2816,"position":5},"title":"Using MariaDB on CentOS 6","date":"15\/3\/2013","format":false,"excerpt":"This is just for testing purposes, but you might want to play around with MariaDB 5.5.29 coming via the CentOS 6 repositories as mentioned in this post. Please test it out and report bugs if required. The process was simple on a fresh install: yum update cd \/etc\/yum.repos.d\/ wget http:\/\/dev.centos.org\/centos\/6\/mariadb\/mariadb.repo\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2816"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2816"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2816\/revisions"}],"predecessor-version":[{"id":2817,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2816\/revisions\/2817"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2816"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}