Reader small image

You're reading from  MariaDB Cookbook

Product typeBook
Published inMar 2014
Reading LevelBeginner
Publisher
ISBN-139781783284399
Edition1st Edition
Languages
Tools
Concepts
Right arrow
Author (1)
Daniel Bartholomew
Daniel Bartholomew
author image
Daniel Bartholomew

Daniel Bartholomew has been using Linux since 1997 and databases since 1998. In addition to this book, he has also written MariaDB Cookbook, Packt Publishing, and dozens of articles for various magazines, including The Linux Journal, Linux Pro, Ubuntu User, and Tux. He became involved with the MariaDB project shortly after it began in early 2009 and continues to be involved to this day. He currently works for MariaDB, Inc. and splits his time between managing MariaDB releases, documentation, and maintaining various bits and pieces that keep the MariaDB project running smoothly.
Read more about Daniel Bartholomew

Right arrow

Installing the CONNECT storage engine


The CONNECT storage engine is not installed by default. So, the first thing that we have to do is to install and enable it.

How to do it...

  1. On Fedora, CentOS, or Red Hat systems, we can run the following command line:

    sudo yum install MariaDB-connect-engine
    

    On Debian, Ubuntu, or Linux Mint systems, we can run the following command line:

    sudo apt-get install mariadb-connect-engine-10.0
    
  2. On all systems, launch the mysql command-line client and connect it to our MariaDB server with a user that has the SUPER privilege.

  3. Enable the CONNECT storage engine by running the following command line:

    INSTALL SONAME 'ha_connect'; 
    
  4. Verify the installation by running the following two commands and look for CONNECT in the output:

    SHOW ENGINES;
    SHOW PLUGINS;
    

How it works...

On Windows and MacOS, the CONNECT storage engine is included but not active. On Linux, we need to install the CONNECT package before we can enable it using the mysql command-line client.

See also

  • The full...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
MariaDB Cookbook
Published in: Mar 2014Publisher: ISBN-13: 9781783284399

Author (1)

author image
Daniel Bartholomew

Daniel Bartholomew has been using Linux since 1997 and databases since 1998. In addition to this book, he has also written MariaDB Cookbook, Packt Publishing, and dozens of articles for various magazines, including The Linux Journal, Linux Pro, Ubuntu User, and Tux. He became involved with the MariaDB project shortly after it began in early 2009 and continues to be involved to this day. He currently works for MariaDB, Inc. and splits his time between managing MariaDB releases, documentation, and maintaining various bits and pieces that keep the MariaDB project running smoothly.
Read more about Daniel Bartholomew