Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

The basics of installation and configuration


In this section, we will discuss the basics of the installation and configuration. As there are a lot of options and things to understand, we'll concentrate first on how to get something working in a simple way. Then, we'll see configuration options in more detail.

Note

To avoid confusion, we'll use InnoDB exclusively in this configuration.

Installation

If you want to test it with Vagrant, you can use the following Vagrantfile here:

# -*- mode: ruby -*-
# vi: set ft=ruby :
# Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
#
VAGRANTFILE_API_VERSION = "2"

# Insert all your Vms with configs
boxes = [
    { :name => :galera1, :role => 'gc', :ip => '192.168.33.31' }, # galera cluster node 1
    { :name => :galera2, :role => 'gc', :ip => '192.168.33.32' }, # galera cluster node 2
    { :name => :galera3, :role => 'gc', :ip => '192.168.33.33' }, # galera cluster node 3
    { :name => :garb,   ...