porting to oracle?

Hello all,
As complete newbies we are looking for some advice - I hope this is the right place to come to.
We have a fairly high traffic web based system using a database server running MySQL. The server has a lot of transactions to process and cannot handle the load anymore, resulting in very long response times.
We now have two machines for our database, physically in different locations however and that cannot be changed. At this moment we are at the point where we need to consider the database system we will port to - if we will port at all.
What we need is a redundant system that will be able to support our (fast) expanding database, and we're thinking of Oracle 10g - mostly because we know it is the industry standard, not because we know WHY it is the industry standard.
So the question is, i guess, what kind of setup would we use for Oracle 10g running one database in two different locations, what would be the best way to keep them synchronized (it needs to be completely transaction safe) and how is such a system expected to perform? 

Evert Lammerts


--
http://www.freelists.org/webpage/oracle-l

Other related posts: