Linux

File Operation & Sudo Operations

Add the Linux groups to your server: [root@jit.co.in tmp]# groupadd parents [root@jit.co.in tmp]# groupadd children [root@jit.co.in tmp]# groupadd soho Add the Linux users and assign them to their respective groups root@jit.co.in tmp]# useradd -g parents ram [root@jit.co.in tmp]# useradd -g parents jagmohan [root@jit.co.in tmp]# useradd -g children ramesh [root@jit.co.in tmp]# useradd -g children hema [root@jit.co.in tmp]# useradd -g soho accounts…

Continue Reading

MySQL

Common Replication Administration Tasks

Common Replication Administration tasks : 1. Checking the Replication Status. The most common task when managing a replication process is to ensure that replication is taking place and that there has been no errors between the slave and the master. On Slave Server (192.168.36.2) mysql>     Show slave statusG The key fields from the status report to examine are: Slave_io_state: indicates…

Continue Reading

MySQL

MySQL Replication

Implementing Master-Slave Replication: Master-Slave replication is mainly for scale-out solutions- spreading the load among the multiple slaves to improve the performance. And for Analytics – while the analysis of the information can take place on the slave without affecting the performance of the master. The target uses for Replication in MySQL include: Scale-out solutions: spreading the load among multiple slaves…

Continue Reading

Linux, MySQL

MySQL Performance

MySQL Performance: Replication, Partition and Memcached 3 main step to increase mysql performance: Split Read and Write Horizontally partition Implement Memchache Setup Replication You can spread your reads with replication, and that helps a lot, but you can’t spread writes (they have to process on all machines) and they’ll eventually consume all your resources. You’ll find yourself adding replicated slaves…

Continue Reading

Linux, MySQL

MySQL Step-by-Step Installations

If you are on Fedora or Red Hat Box $ setenforce 0 #disbles selinux temporarily $ yum install mysql If you have a rpm then $ rpm -i /mysqlSRC_RPM_Folder/MySQL* You can download rpm’s from http://www.mysql.org $ restorecon -R /var/lib/mysql/ #restore selinux labels $ setenforce 1 #enable selinux again Now, I successfully installed MySQL. Now I wanted to change the location…

Continue Reading

MySQL

MySQL’s FEDERATED storage engine

One of the most exciting features introduced in MySQL 5 is the federated engine. The ability to access data from a remote server without the constraints of replication tickles every programmer’s fancy. The Federated engine allows a DBA to create logical pointers to tables that exist on other MySQL servers and thereby link together separate data islands to form one…

Continue Reading

MySQL, PHP

FullText Search Solutions

Types of FullText Search Solutions Special Database Features MySQL Full Text Search, Sienna Solutions exists for PostgreSQL, Oracle and many others Home baked database based solutions Using stored procedures or set of queries and keyword tables for search External Full Text Search Solutions Lucene, Sphinx, Mnogosearch etc. My Thoughts on Performance Lucene and Sphinx both can handle large data sizes…

Continue Reading

PHP

PHP and ASP.net

Ever since Microsoft has come up with ASP.net, there has been a widespread debate among programmers as to whether it is any better than the existing open source programming language of PHP. If we were to make a search on the Internet on how loyalists of both PHP and ASP.net are doing almost everything by biting each other’s heads off,…

Continue Reading

PHP

PHP: MVC Based Popular Framworks

PHP on Trax Strictly follows Ruby on Rails syntax and functionality but written in php5. Originally called PHP on Rails. It is a web-application and persistance framework that is based on Ruby on Rails and includes everything needed to create database-backed web-applications according to the Model-View-Control pattern of separation. This pattern splits the view (also called the presentation) into “dumb”…

Continue Reading

Apache, Linux, MySQL, PHP

LAMP

LAMP is the combination of Linux + Apache + MySQL + PHP (PHP/PERL/Python). Linux is a free Unix-type operating system originally created by Linus Torvalds with the assistance of developers around the world. Developed under the GNU General Public License , the source code for Linux is freely available to everyone. Apache is the most popular web server on the…

Continue Reading