Skip to content

Instantly share code, notes, and snippets.

View raymadrona's full-sized avatar

Ray Anthony Madrona raymadrona

View GitHub Profile
@raymadrona
raymadrona / 01_install_xtrabackup.sh
Created January 23, 2018 08:17
Backup with Percona XtraBackup
#!/bin/bash
# Install xtrabackup package.
# https://www.percona.com/doc/percona-xtrabackup/LATEST/installation/apt_repo.html
# On production server must be installed in the slave.
wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb
@raymadrona
raymadrona / .dbs
Last active May 19, 2023 07:00
MySQL Replication Tuned for Laravel
simmfins
simmfins_trail
@raymadrona
raymadrona / 1_phpunit-api.md
Created November 20, 2017 12:20 — forked from loonies/1_phpunit-api.md
PHPUnit Cheat Sheet

PHPUnit API reference

  • version 3.6

TODO

Check those constraints:

$this->anything()
git config --global core.autocrlf input
git config --global core.eol lf\
Undo a commit and redo
http://stackoverflow.com/questions/927358/how-to-undo-last-commits-in-git
$ git commit -m "Something terribly misguided" (1)
$ git reset HEAD~ (2)
<< edit files as necessary >> (3)
$ git add ... (4)
@raymadrona
raymadrona / imagick-3.4.0-PHP7-forge.sh
Created February 1, 2017 07:29 — forked from pascalbaljet/imagick-3.4.0-PHP7-forge.sh
Install Imagick 3.4.0 on PHP 7.0 server (Laravel Forge)
#!/bin/bash
if [ "$EUID" -ne 0 ]
then echo "Please run as root"
exit
fi
apt-get install pkg-config libmagickwand-dev -y
cd /tmp
wget https://pecl.php.net/get/imagick-3.4.0.tgz
tar xvzf imagick-3.4.0.tgz
ps aux | grep php # show processes
grep CRON /var/log/syslog # show cron logs
pgrep <process_name> # show ids of process name
sudo dpkg-reconfigure tzdata # set the timezone in ubuntu
kill $(ps aux | grep '[p]ython csp_build.py' | awk '{print $2}') # kill processes based on grep
@raymadrona
raymadrona / socket-cheatsheet.js
Created January 20, 2017 12:55 — forked from alexpchin/socket-cheatsheet.js
A quick cheatsheet for socket.io
// sending to sender-client only
socket.emit('message', "this is a test");
// sending to all clients, include sender
io.emit('message', "this is a test");
// sending to all clients except sender
socket.broadcast.emit('message', "this is a test");
// sending to all clients in 'game' room(channel) except sender
mysqldump --single-transaction --skip-lock-tables simmfins | pv | gzip > simmfins_$(date +'%Y%m%d_%H%M%S').sql.gz
mysqldump -u root -p database_name | gzip > dump.gz
scp dump.gz user@other-host:/tmp
ssh user@other-host "gunzip /tmp/dump.gz | mysql -Ddatabase_name -B; rm /tmp/dump.gz"
zcat /path/to/file.sql.gz | mysql -u 'root' -p your_database
// Restore Database (gzip)
gzip -dc /path/to/file.sql.gz | mysql -u 'root' -p your_database
@raymadrona
raymadrona / a.md
Created December 15, 2016 07:58 — forked from danharper/a.md
Laravel Queue Supervisor

Install Supervisor with sudo apt-get install supervisor. Ensure it's started with sudo service supervisor restart.

In /etc/supervisord/conf.d/ create a .conf file. In this example, laravel_queue.conf (contents below). Give it execute permissions: chmod +x laravel_queue.conf.

This file points at /usr/local/bin/run_queue.sh, so create that file there. Give this execute permissions, too: chmod +x run_queue.sh.

Now update Supervisor with: sudo supervisorctl reread. And start using those changes with: sudo supervisorctl update.