Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
26-Feb-10
Schema and Data Comparison and Synchronization Tools for MySQL Offer Command
Line Mode and Comparison Reports
MySQL database
manually apply
bin-logs from one site to other, but this is little complicated and need
precise scripting taking care of all the bin-log position.
regards
anandkl
On Jan 25, 2008 4:17 AM, C K [EMAIL PROTECTED] wrote:
I have a problem related with 2 mysql database synchronization. We are
using
I have a problem related with 2 mysql database synchronization. We are using
a 256kbps internet at our mfg. site and a 2mbps internet connection at our
HO. We are using MySQL5.0.45 for our ERP application. We want to work from
both locations at a time through ERP software. For this we are trying
Hi
We have a mySQL database which is being used by a restaurant ordering
system, in which many of the tables
are being used to store menu item information, pricing etc.
The restaurant started off as a single outlet, but is now about to open
some more new premises.
We would like to have ordering
experiences and opinions.
Thanks
Chris
For your master-to-copy synchronization, MySQL already has the
facilities for this. Check the section of the manual for replication
http://dev.mysql.com/doc/refman/4.1/en/replication.html
For the situation where you store transactions in each
-
From: Chris Cowen [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, March 20, 2006 10:34 AM
Subject: multiple DB copies with periodic synchronization
Hi
We have a mySQL database which is being used by a restaurant ordering
system, in which many of the tables
are being used
address, and my machine at work is
behind a firewall, and we use DHCP. So I do not know if I can use sja? Anyone
know? Upon reading, it looks like there is a need to use an IP on both ends.
2). Do ISPs allow this type of synchronization?
3). Is there a way to do a simple backup in the interim
know? Upon reading, it looks like there is a
need to use an IP on both ends.
2). Do ISPs allow this type of synchronization?
3). Is there a way to do a simple backup in the interim (copy the
data to removable media) and copy to other machine until I get this
all worked out? I see some
with.
1). My home box does not have a static IP address,
and my machine at work is behind a firewall, and we
use DHCP. So I do not know if I can use sja? Anyone
know? Upon reading, it looks like there is a need to
use an IP on both ends.
2). Do ISPs allow this type of synchronization?
3
Hello,
I am developing a web application in which I have been working between home and
an away office. Anyway, up to lately, most of my efforts have been writing the
queries, etc for the backend. So I have a text file that dumps the database and
repopulates them. And up until now, it has been
You require SQLyog's Data Sync Tool. Download it from
http://www.webyog.com
You can find an article on it at:
http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent
Karam
--- Scott Purcell [EMAIL PROTECTED] wrote:
Hello,
I am developing a web application in which I have
been working
I have two MySQL databases that are networked together. If changes can be
made independently to each of the databases - what is the best way to
synchronize them? How can I synchronize them in real time? If the network
link goes down, can the synchronizations be placed upon a queue until the
Dear friends
We have our application with data tier as mysql database in our office running on
windows platform which we need to synchronize with the same database on a remote
system at data centre on Linux.
Awaiting your reply at the earliest,
Thanks Regards,
Prashant A
Dear friends
We have our application with data tier as mysql database in our office
running on windows platform which we need to synchronize with the same
database on a remote system at data centre on Linux.
Awaiting your reply at the earliest,
Thanks Regards,
Prashant A
--
MySQL
Prashant Akerkar [EMAIL PROTECTED] wrote:
We have our application with data tier as mysql database in our office
running on windows platform which we need to synchronize with the same
database on a remote system at data centre on Linux.
Look at the replication:
Try SQLyog Job Agent at http://www.webyog.com
Karam
--- Prashant Akerkar [EMAIL PROTECTED]
wrote:
Dear friends
We have our application with data tier as mysql
database in our office
running on windows platform which we need to
synchronize with the same
database on a remote system at
We are replicating our database server in the interests of
having a hot spare with a fully up to date dataset.
Every so often, I'll get a page from a watchdog script[1] telling
me that the slave has fallen out of sync. Perhaps every 10 days
this occurs.
I notice there's always a coincidence
I have a MySQL master server; it has some tables from a database that needed to be
replicated once a day by some slave server, through a dial-in connection.
How do you think is the best way to do that? Is the replication scheme in MySQL manual
safe enough to do this?
Anybody want to share some
Hi,
I have a setup that consists of two MySql Database
Server.
Server A(WEB DB) is in web hosting location , runs
behind a websever.
Server B(LAN DB) is in my LAN.
My requirment is synchronize both(WEB DB and LAN DB)
databases over the internet.
I am thinking of the following approaches.
1)
Hi all,
i have a mysql database on my local machine , the same
database is my server
i want to synchronize the datbases both side.
is there any login or tool or mysql support for
database synchronization
thanks in advance.
=
---
Dream Team Network Solutions Pvt. Ltd.,
C-97
On Tue, Oct 29, 2002 at 01:02:51AM -0800, Lalit Chandwani wrote:
Hi all,
i have a mysql database on my local machine , the same database is
my server i want to synchronize the datbases both side.
is there any login or tool or mysql support for database
synchronization
How about MySQL's
...synchronization (replication) is done automaticaly
the question two is what if this master is running Windows 98 with
MySQL-win for example? Is that possible to make also in windows?
I will try to post this also to mysql list
--
Best regards,
Martinmailto:corwin
---
-Original Message-
From: Martin Hudec [mailto:corwin;corwin.sk]
Sent: 29 October 2002 09:18
To: Peter Lovatt
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re[4]: [PHP-DB] database synchronization
Hello Peter,
okay :)))so far I understand...buthmmm let me
Hello,
see below...
--
Best regards,
Martinmailto:corwin;corwin.sk
Tuesday, October 29, 2002, 10:51:17 AM, you wrote:
PL Hi
PL If the records are all independant - ie travel agent (TA) A has their own
PL records and so does TA B then REPLACE INTO MainDB SELECT *
/SET_TRANSACTION.html
http://www.mysql.com/doc/I/n/InnoDB_transaction_model.html
SN Son Nguyen
SN --- Egor Egorov [EMAIL PROTECTED] wrote:
Son,
Saturday, March 02, 2002, 6:34:37 AM, you wrote:
SN Does mySQL synchronization between queries? How does mySQL
handle the
SN
Son,
Saturday, March 02, 2002, 6:34:37 AM, you wrote:
SN Does mySQL synchronization between queries? How does mySQL handle the
SN query synchronization. Does anyone know?
What do you mean query synchronization ?
--
For technical support contracts, goto https://order.mysql.com
Does mySQL synchronization between queries? How does mySQL
handle the
SN query synchronization. Does anyone know?
What do you mean query synchronization ?
__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
Does mySQL synchronization between queries? How does mySQL handle the
query synchronization. Does anyone know?
__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote:
I'd like to connect a local sql server to a remote server and get 1
database synchronized between them. For various reasons, I need to
try to run this from within the sql protocol (i.e. no ftp, etc.).
Okay.
Replication is not the
In Re: Database synchronization, [EMAIL PROTECTED] wrote:
On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote:
I'd like to connect a local sql server to a remote server and get 1
database synchronized between them. For various reasons, I need to
try to run this from within the sql
I'd like to connect a local sql server to a remote server and get 1
database synchronized between them. For various reasons, I need to
try to run this from within the sql protocol (i.e. no ftp, etc.).
Replication is not the answer, and I can only work with one database
at a time, so a SELECT is
Hi All
I am New Subscriber to this mailing List.
This is Pragneshkumar from India.
I have one Application Which are wriitten in java/jsp and
using mysql as db.
Now this application is running on net as well as in my
intranet meand it is running on remote server as well as
local server
On Fri, 7 Dec 2001 03:07:56 -0800 (PST), Pragneshkumar
Gandhi [EMAIL PROTECTED] wrote:
| Hi All
| I am New Subscriber to this mailing List.
| This is Pragneshkumar from India.
|
| I have one Application Which are wriitten in java/jsp and
| using mysql as db.
|
| Now this application is running
Hi
Is it possible to synchronize databases. Let me tell you the scenario. The
client lives out of town and wants to do point-of-sale at their place of
business. Internet connection is not very reliable. They already have a
comprehensive database that runs at an ISP in town.
I would like to
Hello guru,
It is not appropriate to me to use standard replication mechanism of
MySQL. because the interactions between master server and slave server
will be too busy.
Is any possibility
1. to replicate data over certain period of time ( I need period
24hours)
2. some how to replicate
On Wed, Oct 31, 2001 at 04:28:27PM +0200, Vyacheslav I. Raytsin wrote:
Hello guru,
It is not appropriate to me to use standard replication mechanism of
MySQL. because the interactions between master server and slave
server will be too busy.
Is any possibility
1. to replicate data over
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to
: synchronization of database between two mysql servers
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both
Yes, Thanks. I was looking for wrong Keyword.
"Jeremy D . Zawodny" wrote:
On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote:
I have two mySQL servers, one is in office, and other at home. I
need to synchronize then via DialUp TCP/IP connection (not Internet
DialUp). Can
I have two mySQL servers, one is in office, and other at home. I need to
synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can
somebody help me ?
--
Martin Jeremic - JSoft
http://jsoft.webjump.com/
mailto:[EMAIL PROTECTED]
On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote:
I have two mySQL servers, one is in office, and other at home. I
need to synchronize then via DialUp TCP/IP connection (not Internet
DialUp). Can somebody help me ?
Does MySQL replication suit your needs?
Jeremy
--
Jeremy D.
Hi,
The short version:
Does anyone know an automated way of keeping two MySQL db's (located on
different machines) in sync? A small window of non-sync could be acceptable.
The long version:
I'm working on a project which basically is about capturing a lot of data
from different places and
h 28, 2001 3:27 PM
Subject: Reg. Synchronization between MySQL DBs
Hi,
The short version:
Does anyone know an automated way of keeping two MySQL db's (located on
different machines) in sync? A small window of non-sync could be
acceptable.
The long version:
I'm working on a project which
Hi,
Does anyone know an automated way of keeping two MySQL db's (located on
different machines) in sync? A small window of non-sync could be acceptable.
Read about "replication" in the corresponding chapters in the online manual
of mySQL (http://www.mysql.com/) - Documentation.
Regards
...
On Wed, 28 Mar 2001, Aigars Grins wrote:
Hi,
The short version:
Does anyone know an automated way of keeping two MySQL db's (located on
different machines) in sync? A small window of non-sync could be acceptable.
The long version:
snip
The important question is how much availability
From: "Ralph Graulich" [EMAIL PROTECTED]
Read about "replication" in the corresponding chapters in the online
manual
of mySQL (http://www.mysql.com/) - Documentation.
From: "Mat Murdock" [EMAIL PROTECTED]
Did you look at doing something with replication?
Thanks for the quick reply. I hadn't
Tnx for the answer.
From: "nigel wood" [EMAIL PROTECTED]
The important question is how much availability ( the ability to survive
network partitions) your looking for:
1) Is simple master -- slave replication good enough for your application
?
all inserts updates going onto the Master the
50 matches
Mail list logo
