earlybird Posted July 1, 2003 Posted July 1, 2003 The question is if OScommerce support multi-database?One is in website, the other one is in video store for handling customer and stock.The server has a static IP address and is connected to internet via ADSL. The other question is that does OScommerce have the featureof auto deduction from the stock.That means if somebody rent a movie while there is just one for that title in stock.will it show this title is not available?
Guest Posted July 1, 2003 Posted July 1, 2003 You mean two databases with the same information? You would have to keep them synchronized somehow. This would happen outside of OSC. Note: OSC uses its own database, so you might have to synchronize three (if you already have two, unless OSC makes one redundant). OSC can be set to auto-deduct from stock. Good luck, Matt
earlybird Posted July 1, 2003 Author Posted July 1, 2003 Thanks for reply.If two customer rent a video at the same time, One from store while the other one from website.But there just one left in stock. In this case the synchronize won't work well.It still need a while to synchronize
Guest Posted July 1, 2003 Posted July 1, 2003 Actually, if you are using MySQL replication, it should be almost simultaneous. However, if you are using MySQL, you could set the store as the database server (where it recommends saying localhost for the database server, you would give your store server's IP instead). Either of these would require that you use the same tables for the in and out of store purchases. OSC can do this, but you might have to do some custom coding. Good luck, Matt P.S. For future reference, cross posting (posting the same question in different forums) is against the forum rules.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.