By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,795 Members | 1,666 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,795 IT Pros & Developers. It's quick & easy.

MySQL Partial Replication over the internet

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a

"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

P: n/a

"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.