MySQL Forums
Forum List  »  Oracle

Re: transfering data
Posted by: David Gornshtein
Date: August 09, 2004 04:15AM


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




Options: ReplyQuote


Subject
Views
Written By
Posted
4541
July 12, 2004 11:02PM
2741
July 24, 2004 07:57AM
2729
August 01, 2004 08:26AM
2813
August 05, 2004 10:15PM
2676
August 06, 2004 02:00AM
Re: transfering data
2658
August 09, 2004 04:15AM
2655
November 11, 2004 10:15PM
2741
November 17, 2004 12:42AM
2525
November 16, 2004 07:30PM
3166
November 17, 2004 12:27AM
2992
November 17, 2004 12:31AM
3133
November 17, 2004 01:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.