Ref: http://www.howtoforge.com/mysql_master_master_replication
a) Create user name and password for replication on both servers by using this command
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO noslave@’host-name’ IDENTIFIED BY ’some-pass’;
b) Configuration for Server 1 To make it primary Server for Server2
vi /etc/my.cnf
log-bin=mysql-bin
binlog-do-db=fosiul # which Database to replicate
binlog-do-db=hesk # Which Database to replicate
binlog-ignore-db=mysql # Which Database to ignore
binlog-ignore-db=test # [...]
Archive for November, 2009
Mysql server master master active active replication
Tuesday, November 24th, 2009How to install innotop
Thursday, November 19th, 2009a)Download innotop from http://code.google.com/p/innotop/
b)cd /tmp
c) tar -xvzf innotop-1.7.2.tar.gz
d) cd innotop-1.7.2
e) perl per Makefile.PL
f) Make install
NOte : if you see error like this :
Looks good
Warning: prerequisite DBD::mysql 1 not found.
Warning: prerequisite DBI 1.13 not found.
Warning: prerequisite Term::ReadKey 2.1 not found.
Writing Makefile for innotop
Solution :
yum install perl-DBD-MySQL
yum install perl-TermReadKey
Run innotop : perl /usr/bin/innotop –password “your password”
How to install chkrootkit/rootkit hunter
Thursday, November 19th, 2009a) Download latest rootkithunter from http://www.chkrootkit.org/download/ (latest version is chkrootkit-0.49 but its has bugs)
mv chkrootkit.tar.gz /usr/local/
cd /usr/local/
tar xvfz chkrootkit.tar.gz
ln -s chkrootkit-0.43/ chkrootkit (replace 0.43 with the right version number)
cd chkrootkit/
make sense
You will now find the chkrootkit program under /usr/local/chkrootkit. Run it by [...]
How to install portsentry
Thursday, November 19th, 2009Install PortsEntry
Portsentry is a tool to detect port scans and log it. Download the sorce package of portsentry from sourceforge.net
wget http://path/to/portsentry-1.2.tar.gz
tar zxf portsentry-1.2.tar.gz
make linux
make install
If you get errors like while compiling
make linux
SYSTYPE=linux
Making
gcc -O -Wall -DLINUX -DSUPPORT_STEALTH -o ./portsentry ./portsentry.c \
./portsentry_io.c ./portsentry_util.c
./portsentry.c: In function ‘PortSentryModeTCP’:
./portsentry.c:1187: warning: pointer targets in passing argument 3 of [...]
Invalid method in request \x80O\x01\x03
Wednesday, November 18th, 2009Make sure the IP of the server and the Ip in Virutal host (ssl configuraiton ) are same.
<VirtualHost xx.xx.xx.xx:443>
</VirtualHost>
How to configure nagios to work with apache source install(/usr/local/apache)
Monday, November 16th, 2009Ref:http://nagios.sourceforge.net/docs/3_0/quickstart-fedora.html
Basic nagios setup works well if you install apache server by yum. But if you install and configure Apache from source to run different directory(i.e /usr/local/apache) other then /etc/httpd/conf then then the default nagios web interface would not work because , by default nagios creates nagios.conf file in /etc/httpd/conf.d directory for fedora.
So if you have [...]
Apache performace tunning
Monday, November 16th, 2009Ref: http://httpd.apache.org/docs/2.2/mod/prefork.html
Ref:http://www.devside.net/articles/apache-performance-tuning
Ref:http://en.wikipedia.org/wiki/Slowloris
Sample Configuration for prefork setting
<IfModule mpm_prefork_module>
StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 150
MaxRequestsPerChild 0
</IfModule>
StartServers :
The StartServers directive sets the number of child [...]
How to compile php for GD library
Friday, November 13th, 2009Install necessary software by yum or from source
yum install gd gd-devel yum install zlib zlib-devel
then
a) Download the php source from here : http://www.php.net/downloads.php
b) Download the source file in to /tmp directory
c) Here I am gussing the php version is php-5.3.0.tar.gz
d) Tar –xvzf php-5.3.0.tar.gz
e) Cd php-5.3.0
f)
./configure –with-apxs2=/usr/local/apache/bin/apxs –with-mysql=/usr/local/mysql –enable-mbstring –-with-gd –-with-zlib –-with-jpeg-dir –-with-png-dir
g) make
h) make install
i) setup your [...]