This content has been marked as final. Show 2 replies
A 2 node-RAC with 1 processor on each node ..... I very much doubt if this can support 6000 sessions.
RAC and DataGuard are not "either/or". They are for two different purposes. RAC is more for scalability (and less about HA) while DataGuard is about Site Failure and DR. However, DG can be setup such that a DG site/server is used as a Reporting environment.
You do need to licence the processors / users on the DG instance.
Hemant K Chitale
The two most critical components for RAC are:
b) Shared Storage
This determines fundamental scalability (and performance). Does not matter how many more CPUs and GBs of RAM are thrown at the cluster.
Interconnect should consists of 2 x 40Gb/QDR Inifiband switches (or 2 x 10Gb GigEthernet switches). Cost depends on number of nodes in the cluster and the number of ports per switch (a cluster node will have a dual port card connecting it to both switches).
The Shared Storage is relatively expensive when bought off-the-shelf. Rolling that on your own - complex, risky and without vendor support.
RAC is not cheap. It is not meant to be cheap. Cheap is a mickey mouse share-little-to-nothing mySQL based cluster. Like comparing a souped up production car with a F1GP car - very little compare besides the fact that both have an engine, 4 tires, and a steering wheel.
Going cheap RAC is shooting yourself in both feet. With a 12 gauge shotgun. Until only bloody stumps remain. ;-)
This however does not mean that RAC is horrible expensive. A good option that compares very favourable to building a custom RAC with the right kit, is Oracle's Database Appliance. If you want to do cluster h/w certified for RAC at an excellent price, use it with little effort and no clustering experience, and basically wheel in the cluster and an hour later start using your database - then Database Appliance is IMO the best choice.