Skip to content

Instantly share code, notes, and snippets.

@dungmanh88
dungmanh88 / Use mysql advisor
Created September 26, 2016 18:10
Use mysql advisor
pt-variable-advisor localhost --user=root --ask-pass
perl mysqltuner.pl
@dungmanh88
dungmanh88 / Diff MySQL configuration files and server variables
Created September 26, 2016 18:12
Diff MySQL configuration files and server variables
Just compare in mysqld section
pt-config-diff /etc/my.cnf.d/server.cnf h=localhost --user=root --ask-pass
pt-config-diff /etc/my.cnf.d/server.cnf /etc/my.cnf.d/server1.cnf
@dungmanh88
dungmanh88 / Change password with encrypted home directory in Ubuntu
Created September 27, 2016 01:10
Change password with encrypted home directory in Ubuntu
sudo passwd username
ecryptfs-mount-private ### Enter old password
ecryptfs-rewrap-passphrase ~/.ecryptfs/wrapped-passphrase ### Enter new password
ecryptfs-unwrap-passphrase ### Recheck passphrase with new password. Passphrase is unchanged when you change your login password
Passwords and Keys > Change password of login keyring
@dungmanh88
dungmanh88 / Mount and umount an encrypted device
Created September 27, 2016 01:13
Mount/umount an encrypted device
sudo blkid ### Get device
sudo cryptsetup luksOpen <device> <map-name>
sudo mount /dev/mapper/<map-name> /mnt/
sudo umount /mnt
sudo cryptsetup luksClose <map-name>
@dungmanh88
dungmanh88 / Resolve e1000e
Last active September 27, 2016 03:46
Resolve e1000e
lspci | egrep -i 'ethernet|network'
if you are using Intel 82574L, you should upgrade module.
Follow https://elrepo.org/tiki/tiki-index.php
sudo rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org
sudo rpm -Uvh http://www.elrepo.org/elrepo-release-6-6.el6.elrepo.noarch.rpm
sudo lsmod|grep e1000e
Output:
e1000e 230782 0
@dungmanh88
dungmanh88 / Get hardware information
Created September 27, 2016 03:52
Get hardware information
dmidecode -t processor | grep -i version
dmidecode -t process | grep -i cache
dmidecode -t processor | grep -i count
dmidecode -t processor | grep -i capable
lscpu
uname -r
cat /etc/issue
cat /etc/redhat-*
free -m
dmidecode -t memory | grep -i "Number of devices"
@dungmanh88
dungmanh88 / Install repo
Created September 27, 2016 03:58
Install repo
ELREPO: https://elrepo.org/tiki/tiki-index.php
rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org
rpm -Uvh http://www.elrepo.org/elrepo-release-7.0-2.el7.elrepo.noarch.rpm
rpm -Uvh http://www.elrepo.org/elrepo-release-6-6.el6.elrepo.noarch.rpm
EPELREPO:
yum -y install epel-release
REMIREPO: http://rpms.famillecollet.com/
rpm --import http://rpms.remirepo.net/RPM-GPG-KEY-remi
@dungmanh88
dungmanh88 / Create sudo user with passwordless
Last active September 28, 2016 09:27
Create sudo user with passwordless
useradd test
groupadd sudo_passwdless
gpasswd -a test sudo_passwdless
groups test
test : test sudo_passwdless
vi /etc/sudoers
%sudo_passwdless ALL=(ALL) NOPASSWD: ALL
@dungmanh88
dungmanh88 / 1 - Backup using percona xtrabackup
Last active October 1, 2016 13:16
Local backup using percona xtrabackup
sudo vi /usr/local/bin/mysql_backup
#!/bin/bash
user_name=root
user_password="<pass>"
backup_name=<backup_name>
host="127.0.0.1"
parallel=4
backup_output="/data/local-backup"
temp_log="/var/log/mysql_backup.log.tmp"
@dungmanh88
dungmanh88 / Install docker-engine 1.11.2
Last active September 30, 2016 04:19
Install docker-engine 1.11.2
sudo tee /etc/yum.repos.d/docker.repo <<-'EOF'
[dockerrepo]
name=Docker Repository
baseurl=https://yum.dockerproject.org/repo/main/centos/7/
enabled=1
gpgcheck=1
gpgkey=https://yum.dockerproject.org/gpg
EOF
yum -y update && yum -y install docker-engine-1.11.2 && systemctl start docker && docker run hello-world