473,395 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

MySql database synchronization

11
Hi all,
My scenario goes like this:

We have two Mysql Databases in different servers.
The communication between these database servers is via low bandwidth internet (Again the internet may go down for some hours or some days).
Both databases are having the same structure.
We are not concerned to synchronize the database structure but we need to synchronize only the data stored in these databases.

(I googled to search some strategies that would work for this scenario but could not get it. All I got was about some commercial applications.)

I would be thankful if anyone can provide a solution or link to free php code (or modules) that can serve this purpose.

Thanks
Jan 24 '08 #1
2 1908
code green
1,726 Expert 1GB
We are not concerned to synchronize the database structure but we need to synchronize only the data stored in these databases.
What do you mean by synchronise.
Is one simply a copy of the other are are they continually changing independently
Jan 24 '08 #2
foss
11
Here,
Both databases(running on different servers) can be updated independently, i.e. if changes (inserting data, deleting data, modifying data ..) are made in Database1 then the Database2 should be updated accordingly. Again, if changes are made in Database2 then the Database1 should be updated accordingly. This is to say that neither of the database is master or slave. Changes can occur independently in any database BUT this should be reflected accordingly in the other database.
Jan 25 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

10
by: Yang Li Ke | last post by:
Hi guys! I have some datas that I must check everytime a visitor comes to my site What is better to do: 1- Read data from a file or 2- Read data from a mysql db Thank you
2
by: Vikas | last post by:
I'm thinking of embedding MySQL in a .NET application. The application will run on a Windows PC and also on a PocketPC handheld; it's to be a single-user application, holding up to a dozen tables...
2
by: Beda Christoph Hammerschmidt | last post by:
MySQL, Access, ODBC, Replication Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection...
7
by: phillip.s.powell | last post by:
We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I...
13
by: Jim Hubbard | last post by:
I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and the ability to continue to run locally even if the...
3
by: Alex | last post by:
Hello, I am running an Access 2003 database, quite modest in size, that is used by upwards of 5 users. I need to modify the database such that these users can work simultaneously and, in some...
1
by: khashkarara | last post by:
I am in a great problem. I need to understand cleaarly about Database Synchronization and Centralization For my thesis work. For this purpose i need some detailed documents on Database...
8
by: morleyc | last post by:
Hi, until recently i was quite happy to add data sources from mssql database in visual studio and drag the datasets directly onto the form this creating a directly editable form which worked well....
2
by: idealfellow | last post by:
Hi Guys, Please do let me know if there any "MYSQL GUI Synchronization Tool" exists. I have googled for some tool, but most of them are not Open Source. Let me know if any Free GUI...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.