Hi,
Are you sure that you have 3000 tx / per second on Oracle running on Linux ?
It's close to the TPCC results on high end machines :-)
What kind of hardware do you have?
How many CPUs?
Are you using RAC?
Will you like to try an intrusive solution eg. some kind of instrumentation
of your production Oracle database in order to support replication
for 3000 tx / per second ?
By the way, would you like to replicate all 3000 tx / per second or just part of
these transactions ? Data transformation during replication ?
What hardware are you using for MySQL (that should be at least equivalent
to your Oracle production hardware since MySQL with InnoDB is a little
bit slower on writes than Oracle (at least if you are going to
run with innodb_flush_log_at_trx_commit=1)
Do you have some budget allocated for these issues?
Regards,
David Gornshtein.
Oracle Certified DBA
Solaris Certified System Administrator
Cellular: +972 (54) 4636694
Email:
david@wisdomforce.com