Rasma Bayu rasmabayu
rasmabayu
/ mysql-docker.sh
Created
July 4, 2022 15:13
— forked from spalladino/mysql-docker.sh
Backup and restore a mysql database from a running Docker mysql container
This file contains hidden or 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
| # Backup | |
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
| # Restore | |
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |
rasmabayu
/ run-xtrabackup.sh
Created
June 21, 2022 11:38
— forked from jmfederico/run-xtrabackup.sh
Script to create full/incremental backups with xtrabackup.
This file contains hidden or 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/sh | |
| TMPFILE="/tmp/xtrabackup-runner.$$.tmp" | |
| USEROPTIONS="--user=${MYSQL_USER} --password=${MYSQL_PASSWORD} --host=${MYSQL_HOST}" | |
| BACKDIR=/srv/mysql-bak | |
| BASEBACKDIR=$BACKDIR/base | |
| INCRBACKDIR=$BACKDIR/incr | |
| FULLBACKUPCYCLE=604800 # Create a new full backup every X seconds | |
| KEEP=1 # Number of additional backups cycles a backup should kept for. | |
| START=`date +%s` |
rasmabayu
/ my.cnf
Created
June 15, 2022 07:30
— forked from kanibaspinar/my.cnf
Mysql My.cnf Optimization - Best Performance For 1000 + Sites Web Server
This file contains hidden or 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
| # Optimized MySQL configuration for cPanel servers by Kani Baspinar - Updated June 2016 | |
| # | |
| # The settings provided below are a starting point for a 24GB RAM server with 8 CPU cores. | |
| # If you have less or more resources available you MUST adjust accordingly to save CPU, RAM and disk I/O usage. | |
| # To fine tune these settings for your system, use MySQL DB diagnostics tools like: | |
| # Test your configuration ; https://launchpad.net/mysql-tuning-primer | |
| # or | |
| # http://blog.mysqltuner.com/download/ | |
| # Note that if there is NO comment beside a setting, then you don't need to adjust it. | |
| # |