1 / 36

Optimizing Database with Policy-Managed Oracle RAC Databases

Learn how to optimize your database using policy-managed Oracle Real Application Clusters (RAC) databases at Oracle OpenWorld Latin America 2010.

abnerr
Download Presentation

Optimizing Database with Policy-Managed Oracle RAC Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle OpenWorldLatin America 2010 December 7–9, 2010

  2. S317075 - Optimize your database using policy-managed Oracle Real Application Clusters (RAC) Databases Markus Michalewicz Principal Product Manager Oracle RAC & Oracle Clusterware

  3. Agenda Introduction Grid Computing and virtualization Grid Concept: Server Pools Policy-Managed Databases What management style to use? Transition to Policy-Managed Databases Step 1 & 2: Behavior Mapping and Consolidation Level Step 3 & 4: Increasing the Number of Servers and Policies Step 5: Using Uniform Services as much as possible Summary and giving the stage to PayPal <Insert Picture Here>

  4. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  5. Grid Computing Virtualize pools and resources

  6. Oracle Grid Infrastructure Siebel PSFT RAC DB1 Oracle RAC DBs RAC DB2 RAC One FREE New Grid Concept: Server Pools Foundation for a dynamic cluster partitioning • Logical division of a cluster into pools of servers. • Hosts applications (which could be databases or applications) Why Use Server Pools? • Easy allocation of resources to workload • Easy management of Oracle RAC • Just define instance requirements (# of nodes – no fixed assignment) • Facilitates Consolidation of Applications and Databases on Clusters

  7. Oracle Grid Infrastructure RAC DB1 Oracle RAC DBs RAC DB2 RAC One FREE Policy-based Database Management A new way of managing your Oracle RAC • Policy-managed cluster management can be applied to Oracle Real Application Clusters (RAC) • Two management styles available now: • Administrator Managed • Specifically define where the database should run with a list of servers names (“traditional way”) • Define where services should run within the DB • Policy Managed • Define resource requirements for expected workload • Ensure enough instances are started to support expected workload, if enough node in the cluster • Goal: remove hard coding of service to instance FREE

  8. What Management Style to use? Policy managed is the future • Administrator Managed • Allows and requires maximum control • Failover management is pre-set • Existing systems have worked well using it • Slows down dynamic addition of nodes to the cluster • Suitable for smaller clusters or rather static systems • Policy Managed • Control is based on policies • Additional capacity will be used instantaneously in accordance to the policies defined • Optimizes bigger clusters (> 4 nodes) • Enables dynamic cluster environments • Useful for future projects and when planning ahead

  9. OLTP_P MAIL_P OLTP_A MAIL_A DB Instance 2 DB Instance 1 Decide on Policy-managed Databases - I Consider your system - an unfavorable example • 2 big machines • 1 database • 2 instances • 2 Services: • OLTP • MAIL • Both services run as Preferred (P) and Available (A) • Each service utilizes the machine to 50% • Average utilization = 50%

  10. Decide on Policy-managed Databases - II The entities Oracle Clusterware can work on • Server pools and servers • A particular server is always part of one server pool at any point in time • Databases and database instances • A cluster can host more than one database • A particular database can run on more than one server pool • More than one database can run on one particular server • But there is only one instance of a particular RAC database on a specific server at any point in time (no instance failover in RAC) • Services • Services come as “singletons” or “uniform” • They either run on one server or on all servers in a specific server pool • A particular service is bound to the database it runs one • A particular service is bound to the server pool it runs in

  11. MAIL MAIL_P OLTP_P OLTP_A MAIL_A OLTP Carpool DB Instance 1 Videos DB Instance 2 DB Instance 1 DB Instance 2 Decide on Policy-managed Databases - III The golden rule: The more (entities), the merrier. Oracle Clusterware operates on 3 entities: • Server pools and servers • Databases and database instances • Services (use uniform over singleton) Increasing the number of any or all of these entities helps to achieve the following goals: • Increase level of consolidation • Increase utilization per server • Enable manageable entity sizes

  12. Transition Steps 1 & 2

  13. DB Instance 2 Transition to Policy-managed Databases Step 1 Start with a direct behavior mapping • 2 big machines • 1 database • 2 instances • 2 Services: • OLTP • MAIL • Both services run as Singletons in the same pool • Each service utilizes the machine to 50% • Average utilization = 50% MAIL OLTP DB Instance 1 MyServerPool

  14. Videos Carpool DB Instance 2 DB Instance 1 MAIL OLTP DB Instance 1 DB Instance 2 MyServerPool Transition to Policy-managed Databases Step 2 Increase the level of consolidation • 2 big machines • 2 database • 2 instances each • 4 Services: • OLTP, MAIL • Videos, Carpool • All services run as Singletons in the same pool • Increased utilization due to multiple databases and services

  15. Videos Carpool DB Instance 2 DB Instance 1 shutdown MAIL OLTP DB Instance 1 DB Instance 2 MyServerPool Increase Level of ConsolidationHow do I benefit in case of a failure? • Databasesrunning workload of minor importancecan be stopped. • Note: stopping particular databases in the same server pool on failure requires customization and reaction to events sent out in the cluster.

  16. Carpool DB Instance 2 DB Instance 1 MAIL MAIL OLTP DB Instance 2 MyServerPool Increase Level of ConsolidationHow do I benefit in case of a failure? • Databasesrunning workload of minor importancecan be stopped. • Note: stopping particular databases in the same server pool on failure requires customization and reaction to events sent out in the cluster.

  17. Transition Steps 3 & 4

  18. Videos Carpool DB Instance 2 DB Instance 1 MAIL OLTP DB Instance 1 DB Instance 2 MyServerPool Transition to Policy-managed Databases Step 3 Increase the number of servers to optimize • Databasesrunning workload of minor importancecan be stopped. • Automated cancellation of work can be enabled using server pools.

  19. Carpool Videos MAIL OLTP Transition to Policy-managed Databases Step 3 Increase the number of servers to optimize • Databasesrunning workload of minor importancecan be stopped. • Automated cancellation of work can be enabled using server pools. Note: Instantaneous addition of servers to server pools! Note: Instantaneous addition of servers to server pools! TakeAwayPool MyServerPool

  20. Carpool Videos TakeAwayPool MAIL OLTP MyServerPool Increase the number of servers to optimizeHow do I benefit in case of a failure? • Automated cancellation of work can be enabled using server pools. • More workload can remain in the cluster • More user request remain to be served

  21. Carpool Videos TakeAwayPool MAIL OLTP MyServerPool Increase the number of servers to optimizeHow do I benefit in case of a failure? • Automated cancellation of work can be enabled using server pools. • More workload can remain in the cluster • More user request remain to be served

  22. Carpool Videos TakeAwayPool MAIL OLTP MyServerPool Increase the number of servers to optimizeHow do I benefit in case of a failure? • Automated cancellation of work can be enabled using server pools. • More workload can remain in the cluster • More user request remain to be served

  23. Videos TakeAwayPool MAIL OLTP MyServerPool Increase the number of servers to optimizeHow do I benefit in case of a failure? • Automated cancellation of work can be enabled using server pools. • More workload can remain in the cluster • More user request remain to be served

  24. Carpool Videos TakeAwayPool MAIL OLTP MyServerPool Transition to Policy-managed Databases Step 4 Define policies • Automated cancellation of work can be enabled using server pools. • A Server Pool is defined by its name, MIN, MAX, and Importance • TakeAwayPool • MIN = 0 (default) • MAX = 2 • Importance = 0 (default) • MyServerPool • MIN = 2 • MAX = 2 • Importance = 1

  25. Transition Step 5

  26. Carpool Videos TakeAwayPool MAIL OLTP MyServerPool Transition to Policy-managed Databases Step 5 Use uniform services as much as possible • Uniform services run on all nodes in a particular server pool. • Uniform services assume that the application will scale on a SMP machine. • Uniform services allow for smaller servers, since loadis distributed over more thanone server. • The more servers, the less“headroom” is required foreach server in case of afailure.

  27. OLTP_P MAIL_P OLTP_A MAIL_A Carpool Videos DB Instance 2 DB Instance 1 OLTP MAIL TakeAwayPool MyServerPool Use uniform servicesHow do I benefit during normal operations? • Uniform services allow for smaller servers, since load is distributed over more than one server. • The more servers, the less “headroom” is required for each server in case of a failure. • Final system: • 66% utilization per server • 34% “headroom” per server • 1 more database is served • Original system: • 50% utilization per server • 50% “headroom” per server

  28. Summary

  29. Grid Computing Virtualize pools and resources

  30. OLTP_P MAIL_P OLTP_A MAIL_A Carpool Videos DB Instance 2 DB Instance 1 OLTP MAIL TakeAwayPool MyServerPool Summary Using policy-managed databases is the future… • In 5 steps of transitioning to server pools and policy-managed databases • Utilization was increased by 32% • “Headroom” per server was decreased by 28% • One more database is served • System protects against 2 server failures instead of one

  31. <Insert Picture Here> WelcomePayPal

  32. More Information • www.oracle.com/goto/rac • www.oracle.com/goto/clusterware • Oracle Open World Virtual Collateral • For Oracle Real Application Clusters Demo • Demo booth W40 in Moscone West • S317072 - Configure Oracle Grid Infrastructure For a Dynamic Data Center • WED, Sept. 22nd, Moscone South, Room 308

  33. <Insert Picture Here> Questions and Answers

More Related