Re: transfering data

[David Gornshtein]

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.

Moreover, several months before we performed some tests to check
scalability of MySQL on n-way high end Sparc III SMP machines
Sorry to say that, but MySQL 4.0.xx scales up to 4-way SMP
and after 8 CPUs it's not scalable at all.

So, first I would like to be sure, that MySQL can handle this throughput.

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
and Your main Oracle server CPU capabilities too. Distributed XA
and two phase commit based transaction considerable increases load on
RDBMS server and requires much more work on client side too.

Let's assume that you are working with InnoDB which is only high performance
reliable storage engine You have in MySQL 4.0.xx.

If you are setting innodb_flush_log_at_trx_commit = 1, this means that
for 180000 tpmC, You might have up to 3000 IO sync/sec.

In addition, I would not seriously consider using Perl DBI as a client for 180000 tpmC
throughput.

Regards,
David.