October 7th, 2005, 04:03 PM
|
#1 (permalink)
| | Member
Join Date: Sep 2004 Location: Your living room...
Posts: 412
| Need assistance with data synchronization (not replication). . .
Hi all,
Briefly, is anyone familiar with efficient (preferably open source) data synchronization techniques for systems using Postgres, MySQL, etc. . . . Specificially the ability synchronize (not replicate) multiple databases across multiple machines regularly.
Thanks in advance!
__________________
I reserve the right to contradict myself. . .
| 
|  | |
October 10th, 2005, 09:42 PM
|
#2 (permalink)
| | Member
Join Date: Sep 2002
Posts: 364
|
A quick google search for "Postgres Replication" turned up many hits. It seems like there is stuff, or at least was stuff out there. I'm not sure about MySQL. But using open source databases will probably lead to less mature products than enterprise databases which have this functionality built in.
| |
| | |
October 11th, 2005, 01:18 PM
|
#3 (permalink)
| | Member
Join Date: Sep 2004 Location: Your living room...
Posts: 412
| Quote: |
Originally Posted by Creosote A quick google search for "Postgres Replication" turned up many hits. It seems like there is stuff, or at least was stuff out there. I'm not sure about MySQL. But using open source databases will probably lead to less mature products than enterprise databases which have this functionality built in. |
I appreciate your input. However, as I said, I'm looking for syncrhonization, not replication. I know some techniques involve doing "replication" both ways, and I suppose that's ok, but I need all that to be transparent (and 100% accurate). Currently I've considered doing something like diffing seperate binary logs then NOTing them and propagating the differences (via rsync, etc. . .), but this seems rather tedious and rsync despite some forum(s) claims is fundamentally one-way. I am interested in whether or not anyone else is familiar, and what techniques they recommend. Thanks again. 
Last edited by gberz3 : October 11th, 2005 at 06:24 PM.
| |
| | |
October 11th, 2005, 10:27 PM
|
#4 (permalink)
| | Member
Join Date: Sep 2002
Posts: 364
|
LOL. I can't read I guess. I would suggest to ask over at Tek-Tips.com forums. They have forums for both postgres and mysql. | |
| | |
October 12th, 2005, 10:54 PM
|
#5 (permalink)
| | Real gangstas sip on Yacc
Join Date: Oct 2001 Location: Suckas-ville
Posts: 4,549
|
If you want to keep sync, just write a wrapper for all SQL Executes which connects to and executes the command on both servers.
This would keep them in sync. Also you should be able to setup two way transactional replication which would do the same thing.
In either method you are going to need to watch out for record locking big time.
Jkrohn
__________________
Signatures blow hard
If your signature contains an ad of any kind, congratulations, you're on my ignore list.
| |
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | 
Posting Rules
| You may post new threads You may post replies You may not post attachments You may not edit your posts
HTML code is Off | | | |   Most Active Discussions  | | | | | Recent Discussions  | | | | | 
|
hardware
prices 
