This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"annotations": { | |
"list": [ | |
{ | |
"builtIn": 1, | |
"datasource": "-- Grafana --", | |
"enable": false, | |
"hide": false, | |
"iconColor": "#e0752d", | |
"limit": 100, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
The easiest method to do authentication will be to create a .my.cnf in your root user directory so run: | |
cd | |
vi .my.cnf | |
Give it the following contents: | |
[client] | |
user=root | |
password=<SET_PASSWORD> | |
Please use wget to download both scripts from here: http://percona.github.io/percona-consulting-scripts/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
if sysbench.cmdline.command == nil then | |
error("Command is required. Supported commands: run") | |
end | |
sysbench.cmdline.options = { | |
point_selects = {"Number of point SELECT queries to run", 5}, | |
skip_trx = {"Do not use BEGIN/COMMIT; Use global auto_commit value", false} | |
} | |
local page_types = { "actor", "character", "movie" } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# | |
# What is that | |
# ============ | |
# | |
# This script will help you setting up your digital ocean | |
# infrastructure with Ansible | |
# | |
# Usually, when working with DO, one is supposed to use digital_ocean.py | |
# inventory file, and spin up instances in a playbook. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[percona@client ~]$ cat sysbench.sh | |
#!/bin/bash | |
# Run small oltp read write test | |
sysbench \ | |
--threads=1 \ | |
--events=0 \ | |
--time=0 \ | |
--rate=1 \ | |
--report-interval=1 \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[michael@Michaels-MacBook-Pro vagrant-percona-michaelcoburn]$vagrant destroy --force && vagrant up | |
==> ps1: Forcing shutdown of VM... | |
==> ps1: Destroying VM and associated drives... | |
==> ps1: Running cleanup tasks for 'hostmanager' provisioner... | |
==> ps1: Running cleanup tasks for 'puppet' provisioner... | |
Bringing machine 'ps1' up with 'virtualbox' provider... | |
==> ps1: Importing base box 'perconajayj/centos-x86_64'... | |
==> ps1: Matching MAC address for NAT networking... | |
==> ps1: Checking if box 'perconajayj/centos-x86_64' is up to date... | |
==> ps1: Setting the name of the VM: ps1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[michael@Michaels-MacBook-Pro vagrant-percona-michaelcoburn]$vagrant up | |
Bringing machine 'ps1' up with 'virtualbox' provider... | |
==> ps1: Importing base box 'perconajayj/centos-x86_64'... | |
==> ps1: Matching MAC address for NAT networking... | |
==> ps1: Checking if box 'perconajayj/centos-x86_64' is up to date... | |
A VirtualBox machine with the name 'ps1' already exists. | |
Please use another name or delete the machine with the existing | |
name, and try again. | |
[michael@Michaels-MacBook-Pro vagrant-percona-michaelcoburn]$vagrant up | |
Bringing machine 'ps1' up with 'virtualbox' provider... |