Win a copy of Modern JavaScript for the Impatient this week in the Server-Side JavaScript and NodeJS forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

MYSQL Synchronization

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I use mysqlyog for Synchronization.
We are looking for two way DB Synchronization mechanisim/feature. We have requirement that we have same copy fo DB @ N (5) number of remote locations. Each one updated with a local client applications which will be updating the data locally on thier local DB. At the end of day we would like to syncrhonize between all those DB's, so that all the DB has the same data after synch up.

We also would like to do real time if it is possible or with frequent scheduling.

We also have other requirement where we do want to changethe structure of DB(ongoing development) in one Maser DB and push those changes to across all these other remoted DB.
I appreciate all your time and effort in advising this.
---------------------------------------------------------------------------------------------------------------
Source1,Source2---->OF line Computer has local Data Base.Target[ Linux server ] -->on line server has it's local data base.All Data base are Same.
I set time 5.00 to synz between Source1 and Target and 5.20 between Source2 and Target
-----------------------------------------------------------------------------------------------------------
Source1 Target [Linux ] Source2
120 120 120

now I update the field of Source1 set 120 to 100 AND RUN synz with Source1 and Target
Source1       Target [Linux ]       Source2
100 <---synz[2 way]---> 100         120

then I run synz with Source2 and Target
Source1      Target [Linux ]         Source2
100         120 <-----synz[2 way]-----> 120

Problem : I can't found the update value in on my web server[ Linux]






 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
    Bookmark Topic Watch Topic
  • New Topic