Strategical Shell Scripting For MySql Replication Post: 302514858

Sponsored Content

Top Forums Shell Programming and Scripting Strategical Shell Scripting For MySql Replication Post 302514858 by kgrvamsi on Monday 18th of April 2011 09:53:06 AM

04-18-2011

Registered User

Hmm actually i'm building up a inteligent monitoring system which checks the architecture every 5secs through cron job......now the script checks up for the slave having up the recent and last log position of the master in to the slave and then we will make that slave as the new master and the other slaves should route up to the new master.the fetching up of the rite slave will be done with the interface of the database.now i want to make other slave ip's to route out to the new master ip.here i want to write a looping statement to check the ip's present in the table and execute some commands on the slave machines

kgrvamsi

View Public Profile for kgrvamsi

Find all posts by kgrvamsi

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell scripting on unix/mysql problems

Hi, I have written a shell script for oracle on unix that does a df for specific files, and then will display the size, Avail, % used and the difference from yesterday to today. I have been asked to place it on some MySql databases that run onn unix and linux also, but when I try to run them I...

2. Web Development

MySQL Replication Issues: Duplicate Key Error

Lately my attention has been focused on distributed MySQL database replication to other web servers. All was going well, but then I noticed the replication would stop and there were there "Duplicate Primary Key" errors in SHOW SLAVE STATUS; I started to trace these down and noticed that this...

3. Shell Programming and Scripting

ERROR in executing mysql querys in shell scripting

Hi All, Please see the below script for mysql 3 commands. Its giving me the right output for all three commands but showing some errors in first two commands , i guess there might be an issue with date. Can anyone help me . #! /bin/bash TABLE_NAME=testingddatabase USER_NAME=root...

4. Linux

Mysql replication

Need to recover a replication broken error on the mysql slave server. I want to force it to resend the binlog file from the begining. What is the correct value for the: MASTER_LOG_POS ? 0, 1 or 107 ?

5. UNIX Desktop Questions & Answers

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database. For this I have created two...

LEARN ABOUT CENTOS

pppoe-setup

PPPOE-SETUP(8)						      System Manager's Manual						    PPPOE-SETUP(8)

NAME

       pppoe-setup - Shell script to configure Roaring Penguin PPPoE client

SYNOPSIS

       pppoe-setup

DESCRIPTION

       pppoe-setup  is a shell script which prompts you for various pieces of information and sets up an /etc/sysconfig/network-scripts/ifcfg-ppp0
       configuration script for the pppoe-start, pppoe-stop and +pppoe-connect scripts.

AUTHOR

       pppoe-setup was written by David F. Skoll <dfs@roaringpenguin.com>.

       The pppoe home page is http://www.roaringpenguin.com/pppoe/.

SEE ALSO

       pppoe(8), pppoe-start(8), pppoe-stop(8), pppoe-connect(8), pppd(8), pppoe.conf(5), pppoe-status(8), pppoe-sniff(8), pppoe-relay(8),  pppoe-
       server(8)

4th Berkeley Distribution					 21 February 2000						    PPPOE-SETUP(8)