advertise
« Is premature scalation a real disease? | Main | Report from OpenSocial Meetup at Google »
Wednesday
Dec122007

Oracle Can Do Read/Write Splitting Too

People sometimes wonder why Oracle isn't mentioned on this site more. Maybe it will now as Michael Nygard reports Oracle 11g now does read/write splitting with their Active Data Guard product. Average replication latency was 1 second and it's accomplished with standard Oracle JDBC drivers. They see a 250% increase in transactions per service for read-write service. And a 110% improvement in tps for read-only service was found. You see a change in hardware architecture with the new setup. They now recommend using a primary and multiple standby servers, a single controller per server, and a single set of disks in RAID1. Previously the recommendation was to have a primary and secondary server with two controllers per server and a set of mirrored disks per controller. The changes increase performance, availability, and hardware utilization. They also have a useful looking best practices document for High Availability called Maximum Availability Architecture (MAA).

Reader Comments (2)

All for the low, low, bargain price of $40,000 per CPU! :)

November 29, 1990 | Unregistered CommenterAnonymous

You know, Oracle certainly has a place, but it's just so.. klunky in some ways. And I'm talking about the entire Oracle stack here. If they would ever just sit back and make everything consistent. Sure, it's a million acquisitions rolled up into the "Oracle stack", but still.. I can dream. ;)

--
Dustin Puryear
Author, Best Practices for Managing Linux and UNIX Servers
http://www.puryear-it.com/pubs/linux-unix-best-practices

November 29, 1990 | Unregistered CommenterDustin Puryear

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>