跨多个服务器的库存控制..想法？
我们目前拥有内部构建的库存管理系统。 它效果很好，我们正在不断创新。
去年秋天，我们开始通过购物车结帐直接在我们的一个网站上销售产品。
显然，我们的库存管理系统在办公室的一台服务器上运行，而我们目前拥有的三个网站（只有一个实际上卖东西）则在外部来源运行。
看到我的问题了吗？ 基本上，我正在尝试想办法创建一个中央库存控制系统，允许内部软件和外部网站进行通信，以便库存始终是最新的，并且我们不会出售我们没有的东西。
我们的内部库存跟踪运行良好且流程良好，但我不知道如何实现可以在两者之间进行通信的可靠跟踪系统。
该软件都是用 Python 编写的，但这并不重要，因为我主要是在寻找如何实现这一点的想法和方法。
预先感谢您的任何答案，我希望这是有道理的..我可以详细说明。
We currently have an inventory management system that was built in-house. It works great, and we are constantly innovating it.
This past Fall, we began selling products directly on one of our websites via a Shopping Cart checkout.
Our inventory management system runs off a server in the office, while the three websites we currently have (only one actually sells things) runs off an outside source, obviously.
See my problem here? Basically, I am trying to think of ways I can create a central inventory control system that allows both the internal software and external websites to communicate so that inventory is always up to date and we are not selling something we don't have.
Our internal inventory tracking works great and flows well, but I have no idea on how I would implement a solid tracking system that can communicate between the two.
The software is all written in Python, but it does not matter as I am mostly looking for ideas and methods on how would this be implemented.
Thanks in advance for any answers, and I hope that made sense .. I can elaborate.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
一种可能性是在库存管理系统上公开一个 Web 服务接口，允许远程访问 Web 店面使用的交易。 通过相当安全的 VPN 链接或 ssh 隧道类型安排，网络店面可以获取库存水平、下订单或根据库存系统执行搜索。
注意：
您仍然需要向库存服务添加合理的安全层，以防网络店面受到威胁。
您必须确保您的库存管理应用程序和服务器足够大，能够处理负载，或者可以合理地轻松扩展，以便能够做到这一点。
库存应用程序的 SLA 需要足够好才能支持网络店面。 这可能意味着某种热故障转移安排。
One possibility would be to expose a web service interface on your inventory management system that allows the transactions used by the web shopfront to be accessed remotely. With a reasonably secure VPN link or ssh tunnel type arrangement, the web shopfront could get stock levels, place orders or execute searches against the inventory system.
Notes:
You would still have to add a reasonable security layer to the inventory service in case the web shopfront was compromised.
You would have to make sure your inventory management application and server was big enough to handle the load, or could be reasonably easily scaled so it could do so.
Your SLA for the inventory application would need to be good enough to support the web shopfront. This probably means some sort of hot failover arrangement.
我没有看到问题...您有一个应用程序在一台本地管理数据库的服务器上运行。 远程服务器没有理由不能与该数据库通信。
当然，如果您没有数据库，而是使用自行开发的应用程序充当某种人造数据库，我建议您尽早重构以使用某种实际的数据库。
I don't see the problem... You have an application running on one server that manages your database locally. There's no reason a remote server can't also talk to that database.
Of course, if you don't have a database and are instead using a homegrown app to act as some sort of faux-database, I recommend that you refactor to use something sort of actual DB sooner rather than later.
我不确定是否有任何一种真正好的解决方案可以解决您的问题。 我认为你现在的做法很好，但如果你不同意，那么我不知道该告诉你什么。
I'm not sure if there is any one really good solution for your problem. I think the way you are doing it now works fine, but if you don't agree then I don't know what to tell you.