MySQL Replication I think!

5 pts.
Tags:
Access Database
MySQL
MySQL Replication
MySQL Restore
Hi,
I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves.
What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front end at this. The internet connection is not terribly reliable so don't really want to move all functions online.
I will then "replicate" the MySQL to a hosted install and use this to drive the online portion. Therefore any changes are replicated to each other. This I think is the best compromise with regard to them wanting "live" data given the flakey internet connection.
Am I thinking along the right lines. is this technically possible. My knowledge of MySQL is pretty limited at the moment.


Software/Hardware used:
MySQL

Answer Wiki

Thanks. We'll let you know when a new response is added.

Replication is almost certainly the way to go, although MySQL Replication is generally only one-way only unless you use a cluster, which is a little out of my comfort zone to talk about.

You could have a MySQL database which is accessible to your clients and also via a data source name via the access database. That way both update the same database, just with 2 different views.

Unless you go for a complicated MySQL cluster replication solution, remember that it’s only one way updates, so one will have to be the master copy and the other a slave (or replicated) copy, possibly used for heavy reporting or internal read only accessing.

In any case, if you internet connection is flakey then it’s highly likely that the replication will not function at it’s best and your local database and the online database will need to be communication with each other at any time when a change it made. It’s the flakey internet connection that will make this tricky and if that is taken out of the equation, it’s a simple master and slave scenario, one I use myself daily.

<a href=”http://dev.mysql.com/doc/refman/5.0/en/replication.html”>Link to Official MySQL 5.0 Replication</a>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following