David Gornshtein wrote:
> Josh,
>
> I think this issue is slightly more
> complicated.
> 3000 transactions per second = 180000 tpmC.
> MySQL has no even single TPCC 4/5/5.1 and so on
> certified benchmark dealing with such
> throughput.
>
I understand the point, but I believe the original poster meant actually 3000 transactions per second, not 3000 TPC-C style transactions which is not the common usage of "transaction". Its unlikely they meant 3000 TCP-C style transactions per your own analysis.
> In addition, You consider using client side TP
> monitor compatible software
> to perform DML via two RDBMS instances in
> parallel - it's nice
> but remember, that You will need to increase
> Your client CPU capabilities
Of course, but I also suggested a possible near real time batching system that does not do parallel connections at the client or middle tier layers. I gave various scenarios that Jafni might apply from queue building, export/import, to real time replication frameworks outside the database, and each of these methods have their pros and cons, and may be applicable to Jafni's real requirements.
Regards,
Josh
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting