Complete uninstallation of Mysql Server on centos

Step 1: Check list the mysql rpm which is installed on server rpm -qa | grep mysql or yum list installed | grep mysql Step 2 : Removing all mysql-related packages (with “yum command”) yum remove mysql-client mysql-server mysql-common mysql-devel Step 3: Delete the databases folder rm -rf /var/lib/mysql/ rm -rf /etc/my.cnf Congratulation’s!...

Read More

Finding and preventing ddos attack on Linux Server

A distributed denial-of-service (DDoS) attack occurs when multiple systems flood the bandwidth or resources of a targeted system, usually one or more web servers. Such an attack is often the result of multiple compromised systems flooding...

Read More

Tracing the execution of processes using strace

Strace is quite simply a tool that traces the execution of system calls. It can trace the execution of a binary from start to end, and output a line of text with the name of the system call, the arguments and the return value for every system call over the lifetime of the process.    1.Find out which config files a program reads on startup strace php...

Read More

SELinux mechanism in linux environment.

Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) security mechanism implemented in the kernel. SELinux was first introduced in CentOS 4 and significantly enhanced in later CentOS releases.  SELinux follows the...

Read More

Simple bash script's for managing mysql

1. Monitoring replication health #!/bin/bash sql_thread_running=$(mysql -e "show slave status\G" | awk -F":" '/Slave_SQL_Running/ { print $2 }' | tr -d ' ') io_thread_running=$(mysql -e "show slave status\G" | awk -F":" '/Slave_IO_Running/...

Read More

Running multiple mysql instance on single server(Centos&Red Hat)

 Follow Below Steps:- Step (1): Create a new MySQL data directory. mkdir -p /var/lib/mysql2 Step 2:  Give permission and ownership .Now we are taking ownership and permission reference from original /var/lib/mysql data directory chmod --reference /var/lib/mysql /var/lib/mysql2 chown --reference /var/lib/mysql /var/lib/mysql2 Step...

Read More

Mysql Installation using rpm package

    1.Download the required rpm filess MySQL-client-community-5.1.25-0.rhel5.i386.rpm MySQL-server-community-5.1.25-0.rhel5.i386.rpm MySQL-devel-community-5.1.25-0.rhel5.i386.rpm    2. Remove the existing...

Read More