[CentOS] MySQL max clustering package?
m.roth at 5-cent.us
m.roth at 5-cent.usWed Mar 17 19:05:37 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. True... but such a system would, by default, be RT. mark
- 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