Local and Remote Integration

[redjim]

I have a clothing store and we have our oscommerce hosted remotely.

I am working on making a POS front end for us to use in our store.

I would like for the pos to integrate to the remote oscommerce site

then if I sell something in the store, it is removed from stock on the oscommerce site and vice-a-versa.

 

here is my dilema, I have dsl, and there is only one ISP where I live and they are flakey. My webhosting seems to get kind of busy in the evenings.

 

How can I run a backup store locally and when my connection to the internet goes up again, it syncronizes.

 

I am not sure if this is even reasonably possible.

 

Any suggestions would be appreciated.

 

Thanks, james

[♥Vger]

It's not easy to do. The problem will be connecting to your remote database to keep the two in sync, or to run the local site using the remote database.

 

It's doubtful that your hosting company would allow you to connect to the remote database without your website being on a dedicated IP address and also having a dedicated IP address for your local install (which you don't share with anyone else on your DSL) - purely for security reasons.

 

Vger

[Guest]

You would require a local copy of the mysql database, point your pos software at the local copy and a program to update your changes to the website.

 

I am working on a program in .NET that would achive this, keep watching the contribs !

[BillChurch]

I have a clothing store and we have our oscommerce hosted remotely.?

I am working on making a POS front end for us to use in our store.

I would like for the pos to integrate to the remote oscommerce site

then if I sell something in the store, it is removed from stock on the oscommerce site and vice-a-versa.

 

here is my dilema,? I have dsl, and there is only one ISP where I live and they are flakey.? My webhosting seems to get kind of busy in the evenings.?

 

How can I run a backup store locally and when my connection to the internet goes up again, it syncronizes.?

 

I am not sure if this is even reasonably possible.

 

Any suggestions would be appreciated.

 

Thanks, james

<{POST_SNAPBACK}>

 

The best way to do this is with MySQL replication, you can do this bi-directional but it gets kind of tricky. If you break the connection, both sides still have the database. No need to make any manual imports/exports or write any scripts to move data around. We use this in production on several servers for tons of stuff. We have 3 servers synchronizing together that are seperated by 1,000's of miles. Smooth as silk. Check out MySQL Replication for more information.

 

-Bill

[redjim]

Thanks a ton, that is exactly what we need.

 

THanks, James