« previous next »
Pages: [1]

Author Topic: Synchronising 2 databases  (Read 455 times)

0 Members and 1 Guest are viewing this topic.

Offline paragkalraTopic starter

  • Irregular
  • Posts: 29
  • Gender: Male
    • View Profile
    • paragkalra.com
Synchronising 2 databases
« on: January 01, 2009, 12:29:09 PM »
I have 2 exactly same MySQL databases. I am very lazy to keep both of them synchronised.

Is there a way through which I can automate the synchronisation process. That is to say if I make any change in one of the database like creating a table or adding a row or a column to a table of one of the database it should get reflected in other database.
Logged
Parag.A.Kalra, The Linux Man
http://www.paragkalra.com/
In this world without WALLS and GATES who need WINDOWS! USE LINUX! STOP PIRACY! GO OPEN SOURCE!

Offline mwasif

  • Enthusiast
  • Posts: 130
    • View Profile
    • PHP, MySQL, Apache
Re: Synchronising 2 databases
« Reply #1 on: January 01, 2009, 01:22:40 PM »
In MySQL replication you can update the changes from master to slave (one way).

Are these databases remotely located?
Logged

Offline paragkalraTopic starter

  • Irregular
  • Posts: 29
  • Gender: Male
    • View Profile
    • paragkalra.com
Re: Synchronising 2 databases
« Reply #2 on: January 01, 2009, 02:34:29 PM »
Yup databases are located remotely...
Logged
Parag.A.Kalra, The Linux Man
http://www.paragkalra.com/
In this world without WALLS and GATES who need WINDOWS! USE LINUX! STOP PIRACY! GO OPEN SOURCE!
Pages: [1]
« previous next »