469,111 Members | 1,977 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

MySQL Partial Replication over the internet

QUESTION:
We are looking to migrate from a Microsoft Access database to MySQL
for our CRM application.
However one of our requirements is the ability to synchronize partial
replicas - both from a laptop on a LAN and also from a remote location
e.g. a branch over an internet server.

Our current solution handles the situation fine but falls down when
attempting to do a partial replica synchronisation over an internet
server.

The application is a CRM system (Customer Relationship Management)
with one central server at head office and several subsets of the
database sitting on sales reps notebooks. Eg the HO server database
contains all the customer data but each sales rep only has their own
customers and related data on the laptop. It is critical, that we can
give a sales person on his laptop only his section of the customers -
not the entire CRM database. The reps would need to synchronise their
laptops on the LAN.
Jul 19 '05 #1
2 4034

"Byron Cooke-Tonnesen" <by***@thirdwave.co.za> wrote in message
news:e1**************************@posting.google.c om...

(snip)
The application is a CRM system (Customer Relationship Management)
with one central server at head office and several subsets of the
database sitting on sales reps notebooks. Eg the HO server database
contains all the customer data but each sales rep only has their own
customers and related data on the laptop. It is critical, that we can
give a sales person on his laptop only his section of the customers -
not the entire CRM database. The reps would need to synchronise their
laptops on the LAN.


My company has done plenty work in the "briefcase data" realm. And it sounds
like your problem is better handled with a 3rd tier server application
designed specifically for the task of allocating each user the data they
need and subsequently synchronizing the data when they "return to base".

But, if your needs and your budget aren't that "intense", you could install
mysql on the laptops and use perl or python on the client to handle the
syncs or updates via xml-rpc. There's so many routes with this.
Jul 19 '05 #2

"Byron Cooke-Tonnesen" <by***@thirdwave.co.za> wrote in message
news:e1**************************@posting.google.c om...

(snip)
The application is a CRM system (Customer Relationship Management)
with one central server at head office and several subsets of the
database sitting on sales reps notebooks. Eg the HO server database
contains all the customer data but each sales rep only has their own
customers and related data on the laptop. It is critical, that we can
give a sales person on his laptop only his section of the customers -
not the entire CRM database. The reps would need to synchronise their
laptops on the LAN.


My company has done plenty work in the "briefcase data" realm. And it sounds
like your problem is better handled with a 3rd tier server application
designed specifically for the task of allocating each user the data they
need and subsequently synchronizing the data when they "return to base".

But, if your needs and your budget aren't that "intense", you could install
mysql on the laptops and use perl or python on the client to handle the
syncs or updates via xml-rpc. There's so many routes with this.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

39 posts views Thread by Mairhtin O'Feannag | last post: by
2 posts views Thread by Beda Christoph Hammerschmidt | last post: by
4 posts views Thread by Jeff Smith | last post: by
9 posts views Thread by David W. Fenton | last post: by
13 posts views Thread by Jim Hubbard | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.