Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Synchronize DataBase Table Between Machines Via SSH?
Top Forums UNIX for Advanced & Expert Users Synchronize DataBase Table Between Machines Via SSH? Post 302444729 by kettlewell on Thursday 12th of August 2010 03:44:06 PM
Old 08-12-2010
Question Synchronize DataBase Table Between Machines Via SSH?
Hello

I have 2 servers that need a database table to be one way synchronized (server A needs to push the table to server B)

I considered using a FEDERATED DB, but decided against it for my particular application (Server B has several apps that would be calling the table repeatedly, and a local DB to server B makes more sense).

So thinking out loud.... when the DB on server A changes, a mysqldump is performed of the table, is ssh'd to server B, and then mysqldump'd into the table.

This table will change infrequently (monthly perhaps), but would need to be done on demand, so that when the change is made, it is propagated to server B nearly instantly.

My real question is: Is my line of thinking right, or is there a better way to do this?


Any thoughts or input would be greatly welcomed.

Matt
 

10 More Discussions You Might Find Interesting

1. Red Hat

X11 forwarding problem between 2 RHEL4 machines with SSH

X11 forwarding problem between 2 RHEL4 machines with SSH Already configured the following on both machines under /etc/ssh Under sshd_config: UsePAM no AllowTcpForwarding yes Under ssh_config: ForwardAgent yes ForwardX11 yes ForwardX11Trusted yes ----------------------------- Using... (1 Reply)
Discussion started by: panggou
1 Replies

2. Linux

How to receive results from processes spawned on external machines using SSH

I am trying to get the number of cpus on a farm of linux boxes (about 100 of them) by 'sshing' to each of them and checking their /proc/cpuinfo file. So I have a local script localscript.sh on each of those 100 machines which retrieves the number of cpus in it by using its /proc/cpuinfo file.... (1 Reply)
Discussion started by: waavman
1 Replies

3. UNIX for Advanced & Expert Users

stagger ssh command to multiple machines

Good day, I am extracting information from Apache log files from 41 servers. Every day I have 7 cronjobs scheduled to do this for me and it works beautifully :D... only problem is that it takes about 6-9 hours to run through, as the script runs about 6 ssh commands for each box then goes to the... (3 Replies)
Discussion started by: msullivan
3 Replies

4. Shell Programming and Scripting

how to ssh to remote unix machines using private/public key

hello, iam able to ssh to a linux server from a linux server called "machine1" using the private/public key method, so I dont need to enter any password when I run my script but iam not able to ssh from machine1 to a UNIX server, access is denied. note that I am using an application id which is... (6 Replies)
Discussion started by: wydadi
6 Replies

5. UNIX for Advanced & Expert Users

SSH connectivity between two machines with private key

Hi I have two machines Mac1 and Mac2 logging in with same user id and same private key. can anyone let me know how to connect these two machine using ssh . or SCP files to other machine :wall: (1 Reply)
Discussion started by: madankumar
1 Replies

6. UNIX for Dummies Questions & Answers

run script accross machines using ssh

Hi all I have to run certain set of commands on two machines, the two machines see the same home, it's mounted from the same place. The problem is that i have to ssh to a certain machine "which is slow unfortunately" that has the license to run a tool and i want to return to the original machine... (3 Replies)
Discussion started by: amr elhosiny
3 Replies

7. UNIX for Dummies Questions & Answers

ssh autologin issue when both machines are having same ~home directory

Hi, I have two machines. M1 and M2 and having a generic id catadm, these two machines having common mount of /u/catadm directory. with this setup, ssh autologin is failing for me and asking me to enter password when i try autologin using this generc id from M1 to M2 catadm-M1$ ssh... (3 Replies)
Discussion started by: rbalaj16
3 Replies

8. What is on Your Mind?

What's your favorite SSH client to connect to UNIX/Linux machines?

I am curious about the most popular ssh client on Windows environment. Talking about me, I use PuTTY most of the time coupled with WinSCP to transfer files. But, I like Tera Term too. It has great drag-drop feature where you can drag a file/folder and drop on the window and it will transfer the... (14 Replies)
Discussion started by: admin_xor
14 Replies

9. AIX

Passwordless SSH problem with AIX machines

Hello, I am trying to setup passwordless nophrase ssh between two machines for the user id: oraprod here is what I did for a non-root user: oraprod whoami: oraprod Machine A: ssh-keygen -t dsa cat ~/.ssh/id_rsa.pub # GO TO MACHINE B create (16 Replies)
Discussion started by: filosophizer
16 Replies

10. Shell Programming and Scripting

Load different lib paths for different machines during ssh.

Greetings to every one, I have to access different clusters for computing. But the problem is their lib paths are different. :eek: How can i export some particular library paths for a particular machine ? For example Like cluster_1 (ip : 10.169.85.47) export LD_libPATH="/opt/CUDA" Like... (2 Replies)
Discussion started by: admax
2 Replies

LEARN ABOUT REDHAT

mysqlshow

MYSQLSHOW(1)						      General Commands Manual						      MYSQLSHOW(1)

NAME

       mysqlshow
	- Shows the structure of a mysql database (databases,tables and columns)

USAGE

       shell> mysqlshow [OPTIONS] [database [table [column]]]

SYNOPSIS

       mysqlshow   [-#|--debug=...]    [-?|--help]   [-c|--character-sets-dir=...]   [-C|--compress]  [-h|--host=...]	[-i|--status]  [-k|--keys]
       [-p|--password[=...]]  [-P|--port=...]  [-S|--socket=...]  [-u|--user=#] [-V|--version]

DESCRIPTION

       -#|--debug=...
	      output debug log. Often this is 'd:t:o,filename`

       -?|--help
	      display help and exit

       -c|--character-sets-dir=...
	      Directory where character sets are

       -C|--compress
	      Use compression in server/client protocol

       -h|--host=...
	      connect to host

       -i|--status
	      Shows a lot of extra information about each table

       -k|--keys
	      show keys for table

       -p|--password[=...]
	      password to use when connecting to server If password is not given it's asked from the tty.

       -P|--port=...
	      Port number to use for connection

       -S|--socket=...
	      Socket file to use for connection

       -u|--user=#
	      user for login if not current user

       -V|--version
	      output version information and exit

NOTE

       If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown.  If no database is  given
       then  all matching databases are shown.	If no table is given then all matching tables in database are shown If no column is given then all
       matching columns and columntypes in table are shown

SEE ALSO

       isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql  (1),  perror
       (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR

       Ver  1.0,  distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).  This software comes with
       no warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mer-
       curmedia.com)

								 19 December 2000						      MYSQLSHOW(1)
All times are GMT -4. The time now is 06:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy