[CentOS] MySQL max clustering package?
John R Pierce
pierce at hogranch.comWed Mar 17 18:57:39 UTC 2010
- Previous message: [CentOS] MySQL max clustering package?
- Next message: [CentOS] MySQL max clustering package?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Neil Aggarwal wrote: > There are a few things we do: > 1. When we place an order, we commit the order to the database in > a transaction. > 2. In a separate transaction, we reduce the qty available of the > product by the amounts ordered. This transaction may be > a conflict with other transactions. That is OK. > 3. The inventory management system keeps the master inventory > of the products. We have a continuous job that pulls the > latest updates to the inventory and feeds those updates > back to the web database. > > So, even if an inventory number is wrong for a short time, it will > be updated to an accurate number soon. > that may be OK for an order processing system, but it could be a serious problem for something like a banking system where you are dispersing cash.
- Previous message: [CentOS] MySQL max clustering package?
- Next message: [CentOS] MySQL max clustering package?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the CentOS mailing list