alastori

#!/bin/bash

#Bash script to restore a full backup in MySQL 5.7 using MySQL Enterprise Backup 4.x
#You need to privide the source of your backup (full path) as an argument
#Source can be a directory or a TAR file with the backup files created by MySQL Enterprise Backup
#MEB must be already installed
#You can find the binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
MEB_HOME=/opt/mysql/meb-4.0

alastori

@ECHO OFF
REM ## Windows batch script to upload of one file passed as parameter using Windows FTP client

REM ## Modify the following variables as you wish
SET FTP_SERVER=
SET FTP_USER=
SET FTP_PASSWORD=

REM ## Test if can proceed
SET FILE_NAME=%1

alastori

#!/bin/bash

#Bash script to provision Unzip via local RPMs in Enterprise Linux 7.x
#Copy the unzip*.rpm file into the $PACKAGES_DIR and run this script as root
#You can find the binaries at https://rpmfind.net/linux/RPM/centos

#Modify these variables as you wish
PACKAGES_DIR=/home/vagrant/packages  #This folder already contains RPMs

set -e    # stop script execution on any error

alastori

#!/bin/bash

#Bash script to provision MySQL 5.7 Community via local RPMs in Enterprise Linux 7.x
#Copy the TAR with mysql* RPMs into the $PACKAGES_DIR and run this script as root
#You can find the community binaries in http://dev.mysql.com/downloads 

#Modify these variables as you wish
DIR_TO_UNPACK=/tmp/packages
PACKAGES_DIR=/home/vagrant/packages  #This folder already contains RPMs
MYSQL_PWD="Root#123"

alastori

#!/bin/bash

#Bash script to provision MySQL 5.7 Commercial via local RPMs in Enterprise Linux 7.x
#Copy the ZIP file with mysql* RPMs into the $PACKAGES_DIR and run this script as root
#You can find the commercial binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
DIR_TO_UNPACK=/tmp/packages
PACKAGES_DIR=/home/vagrant/packages  #This folder already contains RPMs
MYSQL_PWD="Root#123"

alastori

#!/bin/bash

#Bash script to provision MySQL 5.7 Commercial via local RPMs in Enterprise Linux 7.x
#Copy the TAR with mysql* RPMs into the $PACKAGES_DIR and run this script as root
#You can find the commercial binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
DIR_TO_UNPACK=/tmp/packages
PACKAGES_DIR=/home/vagrant/packages  #This folder already contains RPMs
MYSQL_PWD="Root#123"

alastori

#!/bin/bash
#This script updates /etc/hosts with the list of Hosts and IPs bellow
#Run it as root

## Edit the list of host names and IPs as you wish
## Tip: you can check IPv4 with: ifconfig | grep "inet "
declare -A HOSTS
HOSTS[vmmysqltools]=172.28.128.250
HOSTS[vmmysqlserver1]=172.28.128.240
HOSTS[vmmysqlserver2]=172.28.128.241

alastori

#!/bin/bash
#This script updates ssh_host_rsa_key with a new one generated by ssh-keygen
#Run it as root

echo "Old ssh rsa key:"
ssh-keygen -l -f /etc/ssh/ssh_host_rsa_key.pub
echo -e 'y\n'|ssh-keygen -t rsa -N '' -f /etc/ssh/ssh_host_rsa_key
echo "New ssh rsa key:"
ssh-keygen -l -f /etc/ssh/ssh_host_rsa_key.pub

alastori

#!/bin/bash

#Bash script to provision MySQL 5.7 Community via mysql.com public yum repository in Enterprise Linux 7.x
#MySQL yum repository from http://dev.mysql.com/downloads/repo/yum/ must already be installed
#Run this script as root

#Modify these variables as you wish
DIR_TO_DOWNLOAD=/opt/mysql/packages
MYSQL_PWD="Root#123"
REMOTE_USER=remote

alastori

#!/bin/bash

#Bash script to provision MySQL public YUM repository in Enterprise Linux 7.x
#Check if $REPO_RPM_URL is updated at http://dev.mysql.com/downloads/repo/yum/

#Modify these variables as you wish
DIR_TO_DOWNLOAD=/opt/mysql/packages
REPO_RPM_URL=http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm 

set -e    # stop script execution on any error