LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 01-20-2004, 11:28 AM   #1
Passive
Member
 
Registered: Mar 2002
Posts: 51

Rep: Reputation: 15
Arrow MySQL non-realtime table-by-table mirroring


Hi all,

I've got a development server and production server.
I want all web site changes to be done on the development server, tested, and synched to the production server.
For the moment, MySQL is what I'm concerned with.

The problem is that while all changes done by company staff to the database will be done on the local server, there is much data that will need to be entered on the remote server.
By and large, I believe I can separate tables into ones that need to be edited locally, and ones that need to be edited remotely.

So what I want is a solution that will let me mirror a single table from one server to another.

About the only thing I've thought of so far is to have a list of each type of table, and a script that manipulates the mysql client and mysqldump to connect to each server individually and do the necessary mirroring.

Any advice would be appreciated.
 
Old 01-20-2004, 01:11 PM   #2
Pcghost
Senior Member
 
Registered: Feb 2003
Location: The Real Washington
Distribution: Ubuntu, Debian, SuSE, UnSlung, Android
Posts: 1,819

Rep: Reputation: 46
I did something like this recently. We used PHP scripts to grab the data and compare records. Then any records not in the outer table were Inserted, and records found to be modified were updated. It's not too tough to set up in PHP. The only thing to watch for is performance issues (on big tables).
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with mysql table name mitrship Programming 2 07-25-2005 08:12 AM
getting the most frequent value from mysql table niehls Programming 4 01-29-2005 07:49 AM
MySQL db table tommytomato Linux - General 10 08-24-2004 06:57 AM
MySQL: Can't use '(' or ')' in table name Mikessu Linux - Software 0 08-03-2004 04:59 AM
How to import MS ACCESS Table including OLE filed into the MySQL Table ? myunicom Linux - General 1 11-28-2003 12:30 PM


All times are GMT -5. The time now is 02:11 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration