Category Archives: Mysql

Mysql.

Reset mysql root password

Reset mysql root password : If you set a root password previously, but have forgotten it, you can set a new password. The following sections provide instructions for Unix systems 1) Stop Mysql server. #sudo /etc/init.d/mysql stop OR #sudo kill … Continue reading

Posted in Mysql | Tagged | Leave a comment

Repair MySQL Replication

Repair MySQL Replication: If you have set up MySQL replication, you probably know this problem: sometimes there are invalid MySQL queries which cause the replication to not work anymore. 1) Check log entry, #tail -n100 /var/log/mysql/error.log 131127 18:10:46 [ERROR] Slave … Continue reading

Posted in Master Slave Replication, Mysql | Tagged | Leave a comment

Setup MySQL Master Slave Replication

Setup MySQL Master Slave Replication : Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive … Continue reading

Posted in Master Slave Replication, Mysql | Tagged | 1 Comment

Setup Lemp on ubuntu 12.04

I have seen some online guides about this but really was after one specific to Ubuntu 12.04. So here goes: Step 1 – Installing Nginx From Source , Install Prerequisites Begin by ensuring that your system’s package database and installed … Continue reading

Posted in Mysql, Nginx, Php | Tagged , , , | Leave a comment

Monitoring services with Monit

Monitoring services with Monit Check all running service on you machine with their port no, #netstat -atlpvn | grep LISTEN Get and install Monit, #sudo apt-get install monit OR #cd /home/ #wget http://mmonit.com/monit/dist/monit-5.5.tar.gz #tar -zxvf monit-5.5.tar.gz #cd monit-5.5 #./configure #make … Continue reading

Posted in Apache, Gearman, Memcached, MongoDB, Monit, Mysql, Node.js, Redis, Sphinx | Tagged , , , , , , , , | Leave a comment

Connect mysql with node.js

A Brief Intro to Async Programming In browsers, Javascript and the web page’s rendering engine share a single thread. The result of this is that only one thing can happen at a time. If a database query would be performed … Continue reading

Posted in Mysql, Node.js | Tagged , , | Leave a comment

Install Apache-Php-Mysql latest version on Centos

Install Apache-Php-Mysql latest version on Centos A) Install latest Apache Web Server: #cd /usr/local/src/ #wget http://apache.mirrors.pair.com//httpd/httpd-2.4.1.tar.bz2 #tar -jxf httpd-2.4.1.tar.bz2 #cd httpd-2.4.1 Install latest APR & APR-Utils version available (steps are given in Requirements).Unpack them into ./srclib/apr and ./srclib/apr-util (be sure … Continue reading

Posted in Apache, Mysql, Php, Web development | Tagged , , , | Leave a comment

Setup Lamp on ubuntu 12.04

Download Wubi. #sudo apt-get update #sudo apt-get upgrade #sudo apt-get install build-essential #sudo apt-get install apache2 #sudo apt-get install php5 #php /var/www/index.html #sudo apt-get install curl #curl http://localhost/ #sudo apt-get install mysql-server #sudo apt-get install phpmyadmin #sudo apt-get install subversion … Continue reading

Posted in Apache, Linux Operating System, Mysql, Php, Web development | Tagged , , , , | Leave a comment