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

Configuring Spider


As in other chapters, Vagrantfile is included to create an architecture sample to help you test different scenarios in this chapter:

# -*- 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 => :spider1, :role => 'db', :ip => '192.168.33.31' }, # spider node 1
    { :name => :backend1,  :role => 'db', :ip => '192.168.33.41' }, # shard 1
    { :name => :backend2,  :role => 'db', :ip => '192.168.33.42' }, # shard 2
]

$install_common = <<INSTALL
aptitude update
DEBIAN_FRONTEND=noninteractive aptitude -y -o Dpkg::Options::="--force-confdef" -o Dpkg::Options::="--force-confold" install python-software-properties openntpd
INSTALL

$install = <<INSTALL
mkfs.ext4 -F /dev/sdb
mkdir -p /var/lib/mysql
echo "/dev/sdb    /var/lib/mysql           ext4    noatime,nodiratime,discard        0   ...