Installation

10 Steps: MySQL Monitoring through Nagios: Install & Configure

Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL Database Server. Let’s unleash the power step by step: Installing and configuring Nagios Step-1 : Install required stuff: yum install httpd yum install gcc yum install glibc* yum install gd* Step-2 :Create Nagios user account and group useradd nagios passwd nagios groupadd nagcmd usermod -G nagcmd nagios usermod -G nagcmd apache Step-3: Downloads: Create directory: mkdir NagiosSetup cd NagiosSetup Download nagios wget -X Get “http://sourceforge.net/projects/nagios/files/nagios-3.x/nagios-3.2.1/nagios-3.2.1.tar.gz/download” Download Nagios Plugins: wget -X...

Installing MySQL On Mac OS X (Darwin Kernel)

Recently I happen to install MySQL on Mac OS X (Darvin Kernel).  Below are the quick 5 steps to accomplish the task. Step 1: Check Mac Version Very first step is to verify the Mac OS X’s current version to decide MySQL Installation file to be downloaded. For example for Mac version: 10.4 you should download “Mac OS X 10.4 (x86, 32-bit), Compressed TAR Archive (mysql-5.1.51-osx10.4-i686.tar.gz)” How to Check Mac Version: cat /System/Library/CoreServices/SystemVersion.plist <?xml version=”1.0″ encoding=”UTF-8″?> <!DOCTYPE plist PUBLIC “-//Apple Computer//DTD PLIST 1.0//EN” “http://www.apple.com/DTDs/PropertyList-1.0.dtd”> </p> <plist version=”1.0″> <dict> <key>ProductBuildVersion</key>  <string>8S2169</string> <key>ProductCopyright</key><string>1983-2007 Apple Inc.</string> <key>ProductName</key> <string>Mac OS X</string> <key>ProductUserVisibleVersion</key> <string>10.4.11</string> <key>ProductVersion</key>...

Quick Multi MySQL Server Installation with Master-Master Replication on Same Windows Box

This article is a brief step-by-step tutorial on the subject task which is divided into the following main parts: Installing two MySQL Server Instances Setting up master-slave replication Setting up slave-master replication Let’s begin covering those points… Installing Two MySQL Server Instances on Windows: 1. Install MySQL: Download MySQL Binaries from dev.mysql.com. Install normal MSI Package of mysql. (I used: mysql-essential-5.0.83-win32). * Following MSI Installation is quite easy, proceed and finish the installation. This server will be installed on default 3306 port with all windows default settings. 2. Register/Install another MySQL instance: To have two servers we make sure to...