Skip to content

Instantly share code, notes, and snippets.

View michaelcoburn's full-sized avatar

Michael Coburn michaelcoburn

View GitHub Profile
@michaelcoburn
michaelcoburn / MySQL_Semi-Sync_Summary.json
Created June 29, 2021 03:38
MySQL Semi-Sync Summary Dashboard for Percona Monitoring and Management PMM
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": false,
"hide": false,
"iconColor": "#e0752d",
"limit": 100,
@michaelcoburn
michaelcoburn / PCS
Created October 20, 2020 18:30
How to configure PCS
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/
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" }
@michaelcoburn
michaelcoburn / do_boot.sh
Last active July 4, 2018 20:43 — forked from leucos/do_boot.sh
Bootstrap your DO infrastructure unsing Ansible without dynamic inventory
#!/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.
[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 \
[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
[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...