[CentOS] MySQL max clustering package?
JohnS
jses27 at gmail.com
Wed Mar 17 17:21:17 UTC 2010
On Wed, 2010-03-17 at 12:07 -0500, 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.
--
I am just curious is this a hack around some specific problem? It just
does not merge in my head.
John
More information about the CentOS
mailing list