# sysctl vm.swappiness
vm.swappiness = 60

With that setting the Linux kernel feels encouraged to use the available swap. On a dedicated MySQL server, swappiness should be set to zero to discourage kernel from swapping out application memory.

# sysctl -w vm.swappiness=0
vm.swappiness = 0

This changes the runtime setting. To allow the change to survive system restarts, just add vm.swappiness=0 as a separate line into /etc/sysctl.conf

We need to change DocumentRoot variable in the configuration file.

vi /etc/httpd/conf/httpd.conf

DocumentRoot /mnt
serverName rredis.mycompany.com
ErrorLog /var/log/httpd/error_log

Make sure serverName does not conflict and ErrorLog path exist.

Set up git:

yum install git-core
cd ~/.ssh
ssh-keygen -t rsa -C "shantanu.oak@gmail.com"

Contents of the file "id_rsa.pub" should be copied to gitHub site.
On the GitHub site Click “Account Settings” > Click “SSH Public Keys” > Click “Add another public key”

This will allow passwordless access to github site:
ssh -T git@github.com
_____

Global setup:

git config --global user.name "Shantanu Oak"
git config --global user.email shantanu.oak@gmail.com
_____

Next steps:

mkdir syllabalize_unicode
cd syllabalize_unicode
git init
touch README
git add README
git commit -m 'first commit'
git remote add origin git@github.com:shantanuo/syllabalize_unicode.git
git push -u origin master
_____

Existing Git Repo?

cd existing_git_repo
git remote add origin git@github.com:shantanuo/syllabalize_unicode.git
git push -u origin master
_____

clone (download) the source
git clone git@github.com:ahiguti/HandlerSocket-Plugin-for-MySQL.git
_____

Install MySQL

mkdir download
cd download
wget files.directadmin.com
wget files.directadmin.com
wget files.directadmin.com
wget files.directadmin.com

The commands are as follows:

rpm -iUh *

Tunneling an ssh connection through an ssh connection is completely lawful, but you need to pick unused ports for your forwarding listeners.

ssh user@100.100.100.100 -L 2201:192.168.25.100:22

then
ssh localhost -p 2201

You should end up on server B (unless something's already bound to local:2201, in which case, pick another port).
_____

There are times when you need to connect to a remote server through some other server. You can skip logging to an intermediate server and connect directly to remote server using SSH like this...

ssh -t -t root@192.168.1.1 "ssh -i /root/remote_server.pem ec2-1-2-3-4.compute-1.amazonaws.com"

To upload the cron job from a file to another user, combine it with -u option.

# crontab -u root /home/oracle/mycronjobs.txt

Divides the buffer pool into a user-specified number of separate regions, each with its own LRU list and related data structures, to reduce contention during concurrent memory read and write operations. The size specified by innodb_buffer_pool_size is divided among all the buffer pool instances. For best efficiency, specify a combination of innodb_buffer_pool_instances and innodb_buffer_pool_size so that each buffer pool instance is at least 1 gigabyte.

log a command to console and to 2 files separately stdout and stderr

# command > >(tee stdout.log) 2> >(tee stderr.log >&2)
_____

Real full backup copy of /etc folder
# rsync -a /etc /destination

If your repository is available on a server for e.g. 10.10.10.6, you need to point it to that server in your config file.

# cat /etc/yum.repos.d/rhel.repo
[base]
name=RHEL 5 $releasever - $basearch - Base
baseurl=http://10.10.10.6/yum/rhel/5/base/
enabled=1
gpgcheck=0

If the internet is not working from a server, you need to change one file.

cat /etc/resolove.conf

nameserver 8.8.8.8
nameserver 10.10.10.1
nameserver 10.10.10.6

/etc/init.d/network restart

The mail command will not work if the internet is down.

If you need fresh mysql installation you need to run script to create default mysql database and system tables. The script is called "mysql_install_db" and is either in the bin or in scripts directory of your mysql installation. Change the my.cnf to reflect new datadir and run mysql_install_db for it to create mysql database and system tables in the new datatir and then start mysqld_safe.