MySQL Master Master Repliction Tutorial

This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the first one(…)

MySql backup script

First download the script from the following link http://bash.cyberciti.biz/backup/backup-mysql-database-server-2/ 1) To backup databases file /backup dir and later pick up by your script 2) You can skip few databases from backup! Open file backup.bash.txt and customize it: MyUSER=”YOUR-MYSQL-USER” # mysql username MyPASS=”YOUR-MYSQL-USER-PASSWORD” # mysql password MyHOST=”localhost” # mysql Hostname Optional setup the name of database(…)

HOW TO VERIFY HTTPD ,AFTER INSTALL

After installing apache server please use the below listed commands to verify your httpd installation : $ /usr/local/apache/bin/httpd -t output: Syntax OK $ /usr/local/apache/bin/httpd -v output: Server version: Apache/2.2.2 Server built: May 29 2006 12:40:55 $ /usr/local/apache/bin/httpd -V output: Server version: Apache/2.2.2 Server built: May 29 2006 12:40:55 Server’s Module Magic Number: 20051115:2 Server loaded:(…)

How To Set Up Database Replication In MySQL

1 Configure The Master First we have to edit /etc/mysql/my.cnf. We have to enable networking for MySQL, and MySQL should listen on all IP addresses, therefore we comment out these lines (if existant): #skip-networking #bind-address = 127.0.0.1 Furthermore we have to tell MySQL for which database it should write logs (these logs are used by(…)

HOW TO INSTALL SNMP ON LINUX

Run rpm commands query option to find out snmp server installed or not: # rpm -qa | grep snmp (a) Visit rpmfind.net to get snmp server and utilities rpms. If you are fedora user then use yum command as follows to install it: # yum install net-snmp-utils net-snmp (b) If you are RHEL subscriber then(…)

How to install MySQL from source on FreeBsd or Linux

On Linux: # groupadd mysql # useradd -g mysql mysql On FreeBsd: # groupadd mysql # adduser (mysql) To build MySql follow the next steps: # mkdir /usr/local/mysql/data # mkdir /usr/local/mysql/tmp # mkdir /usr/local/mysql/var # cd /usr/src # tar -vzxf mysql-3.23-51.tar.gz #cd /usr/src/mysql-3.23.51 # ./configure –prefix=/usr/local/mysql –localstatedir=/usr/local/mysql/data –with-unix-socket-path=/usr/local/mysql/tmp/mysql.socket # make # make install Change ownership(…)

How To Install Apache 2.0/PHP 4.3 and MySQL 5.0 on Redhat

• Uninstall previous versions of apache and mysql • rpm -e httpd mysql • Download and install RPM packages of MySQL’s server, client and dynamic shared libraries from mysql.com. do not opt to change the password on MySQL database unless you know what you’re doing (I don’t). If requested at first installation attempt, download the(…)

How to Create MySQL database on Windows system

1. Start the MySQL server by issuing the command mysqld-shareware –standalone at the prompt in c:\mysql\bin. Refer the previous session Installing MySQL on Windows for further details. 2. Now invoke the mysql client program by typing mysql at the prompt. 3. The prompt is changed to a mysql> prompt. Type: 4. create database employees; 5.(…)

How to Create MySQL database on Linux system

1. I assume that you are working from your account and not the root. Start a terminal session and become the superuser (Type su at the prompt and then enter the root password). 2.Now we’ll access the MySQL server. Type: mysql -u root -p The system prompts for the MySQL root password that you set(…)

How to Configure Awstats

AWStats is a free powerful and featureful tool that generates advanced web, streaming, ftp or mail server statistics, graphically. This log analyzer works as a CGI or from command line and shows you all possible information your log contains, in few graphical web pages. It uses a partial information file to be able to process large log files, often(…)

Change File Permissions on Linux

This is a very simple process. Although there are a few other ways of doing this, I am going to show you the most “macho” way. There are three permission “groups”, and each one has three types of permissions you can set. Each type of permission has a numerical value, and when you add up(…)

Add additional IPs to one NIC in Linux

Two commands: $ /sbin/ifconfig eth0:0 192.168.0.4 $ /sbin/route add -host 192.168.0.4 dev eth0:0 (replace that IP with the one you’d like to add) This change will no longer be in effect after rebooting. Therefor you must add the two commands to the bottom of your /etc/rc.local file. Your NIC should now be listening and responding(…)