July 2013
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  

Categories

July 2013
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  

Mysql Master Slave Replication

Setting the Replication Master Configuration

On a replication master, you must enable binary logging and establish a unique server ID.

Binary logging must be enabled on the master because the binary log is the basis for sending data changes from the master to its slaves.

If binary logging is not enabled, replication will not be […]

Mysqlslap for mysql load testing

Mysqlslap is a Load Emulation Client. mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server. mysqlslap is available as of MySQL 5.1.4.

mysqlslap runs in three stages:

1. Create schema, table, and […]

DRBD MYSQL

DRBD is a block device which is designed to build high availability clusters.

This is done by mirroring a whole block device via (a dedicated) network. DRBD takes over the data, writes it to the local disk and sends it to the other host. On the other host, it takes it to the disk there. […]

Mysql Master-Slave Replication after slave fails

1. From slave if we run mysql> mysql slave status; it will show last bin file slave reads from master and all,so start from that bin file to sink with master to slave.

2. Set Master configuration on the Slave. Execute the following command on a MySQL prompt to sink slave with master:

mysql > […]

CPU architecture information under Linux operating

You can use /proc/cpuinfo file or use the lscpu command to get info about CPU architecture. It will display information like: Number of CPUs Threads Cores Sockets NUMA nodes Information about CPU caches, CPU family, model and stepping. in human-readable format. Alternatively, it can print out in parsable format including how different caches are shared […]

Add disk on Rhel 6

There are two ways to configure a new disk drive into a Red Hat Enterprise Linux 6 system. One very simple method is to create one or more Linux partitions on the new drive, create Linux file systems on those partitions and then mount them at specific mount points so that they can be accessed. […]

iostat, vmstat and mpstat examples

This article provides a total of 24 examples on iostat, vmstat, and mpstat commands. iostat reports CPU, disk I/O, and NFS statistics. vmstat reports virtual memory statistics. mpstat reports processors statictics. This article is part of our ongoing Linux performance monitoring series. Please note that iostat and vmstat are part of the sar utility. You […]

Mysql backup using samba

#!/bin/bash # This script creates a copy of the /opt/zimbra folder and then compress # it localy before sending it over the nework so make sure there is enough space # left on your local hard drive ($parentfold variable). # A samba share is used in this script, fill the ## NETWORKING ## section # […]

Bash Profile Tips

If you’ve been learning the command-line and you have the basics down (you should be, as the most effective way to use a computer is a combination of a GUI and command-line), the next step is to customize your environment.

Beginner’s Tip: “command-line” and “shell” are often used synonymously. In unix, technically speaking, the shell […]

List last modified – shell Script

SHORT_HOSTNAME=`hostname -s` LOCATION=”/home” # DESTINATION=”$1″ if [ -z “$1″ ] then DESTINATION=”$LOCATION” fi # EMAIL_TO=”test@rmohan.com” EMAIL_SUBJECT=”List Last Modified files from $SHORT_HOSTNAME” EMAIL_BODY_Line1=”Below is the list of last modified files:” # MOD_FILES=`find $DESTINATION -type f -mmin -10 -ls` # if [ -n “$MOD_FILES” ] then printf “$EMAIL_BODY_Line1\n\n$MOD_FILES\n” | mail -s “$EMAIL_SUBJECT” $EMAIL_TO fi # […]