server pools & policy managed rac - home: doag … · server pools & policy managed rac...

Experts for database solutions.

DOAG HA DAY

Server Pools & Policy Managed RAC

Marco Mischke, 13.07.2017


About me

Oracle DBA since 2000 and Version 7.3.4

Certified Professional 10g, 11g

RAC / Cluster Certified Expert 10g, 11g, 12c

Oracle ACE

@DBAMarco

dbamarco.wordpress.com


Facts and FiguresRobotron Datenbank-Software GmbH

Year of formation 1990

Legal form GmbH (Limited liability company, 9 associates)

Number of employees 374 (Status 05/2016)

Capital stock 2.4 million EUR

Turnover 2014 31.2 million EUR

Turnover 2015 32.8 million EUR

Oracle-Partner

ISO 9001 certified

Headquarters

Congress and Training center


The Robotron Company Group

Czech Rep.: Robotron Database Solutions s.r.o.

Switzerland: Robotron Schweiz GmbH

Austria: Robotron Austria GmbH

Russia: Robotron Rus GmbH

Germany: SASKIA® Informations-Systeme GmbH


The Range of Services of Robotronwith branch-specific Expertise

Methodical and technological responsibility

Comprehensive expertise of industry-specific business processes


Agenda

Classic Cluster / RAC

Server Pools

Policy Managed RAC

Summary


Classic Cluster

DWH1 DWH2 DWH3 OLTP1 OLTP2 TEST


Classic Cluster

X servers build up a cluster

Each database instance is hard-linked to servers

– Server down means instance down

– All configured servers down means database is down

Extending RAC means creating new instances manually

Increasing/Decreasing number of instances means manual intervention

Configuration is pretty static


Agenda


Server Pools

Policy Managed RAC

Summary


Server Pools

DWH Server Pool OLTP Server PoolTEST

Server Pool


Server Pools

Looks pretty similar to classic cluster

BUT

Server pools have

– Priorities

– Minimum amount of servers

– Maximum amount of servers

Server pools are not bound to servers by configuration

They get assigned to server pools dynamically based on

– Priority

– Minimum

– Maximum


Server Pools

DWH Server Pool

Priority: 5Min: 1Max: 3

OLTP Server Pool


TEST Server Pool



Server Pools

OLTP

Cluster Startup (1)


Server Pools

OLTP

Cluster Startup (2)

DWH


Server Pools

OLTP

Cluster Startup (3)

DWHTEST


Server Pools

OLTP

Cluster Startup (4)

DWHTEST OLTP


Server Pools

OLTP

Cluster Startup (5)

DWHTEST OLTPDWH


Server Pools

OLTP

Cluster Startup (6)

DWHTEST OLTPDWHDWH


Server Pools

Instances are created on demand

– At the end, there can be instances on ALL nodes even if cardinality is 1

– One has to do NOTHING, it just happens and creates

• New UNDO tablespace

• New REDO Thread

– Exception: Data Guard

• New Standby REDO Threads are NOT created automatically

Be careful with „MIN“ property for high priority pools

– When server in highest priority pool goes down, the pool is not automatically filled up with otherservers!

– Servers are added if number falls below „MIN“ propertyMIN=1 means potential outage!


Server Pools

That was 11.2


Server Pools

12.1+

Server Categories

– Assing servers to pools based on physical attributes

Policy Sets

– Define different configurations (policies) for server pools

– Dynamically switch between policies

• Re-configures the whole cluster if needed


Server Categories

crsctl status server node-1 -p

– NAME=node-1

– MEMORY_SIZE=32224

– CPU_COUNT=8

– CPU_CLOCK_RATE=2

– CPU_HYPERTHREADING=0

– CPU_EQUIVALENCY=1000

– DEPLOYMENT=other

– CONFIGURED_CSS_ROLE=hub

– RESOURCE_USE_ENABLED=1

– SERVER_LABEL=

– PHYSICAL_HOSTNAME=


Server Categories

Use the dynamic attributes

– crsctl add category hugeram -attr "EXPRESSION='(MEMORY_SIZE < 32250)' "

OR

Use static attributes like label to

– crsctl set server label computecenter1

• Needs CRS restart on that server

– crsctl add category compcenter1 -attr "EXPRESSION='(SERVER_LABEL = computecenter1)' "

Build serverpools from thosesrvctl modify serverpool -serverpool gold -category "hugeram“

Show and delete categories

– crsctl status category

– crsctl delete category <name>


Agenda


Server Pools

Policy Managed RAC

Summary


Policy Managed RAC

Different requirements for different timeframes

– Would require scripting to change serverpools

Solution: Policy Sets

– Different stored configurations for server pools

– Only one is active

– Change between policies manually


Policy Sets

Policy Sets

– Allow different server pool configurations

– Can be modified via

• Direct commands: crsctl modify policysetcrsctl add policycrsctl modify serverpool … -policy …

• Via Config Files:crsctl create policyset -file <filename>modify filecrsctl modify policyset -file <filename>

– Switch between policiescrsctl modify policyset -attr "LAST_ACTIVATED_POLICY=WeekEnd“

– Unfortunately there is no schedule within CRS stack use cron or EM


Policy Sets

Schedule via Enterprise Manager (13.2)

– „force“ option can‘t be specified not really useful


Agenda


Server Pools

Policy Managed RAC

Summary


Management in Enterprise Manager

Enterprise Manager 12.x

– Dynamic relocations where not recognized (except SCAN listeners)

Enterprise Manager 13.2

– Looks fine… Finally



– Adding and relocating of instances works fine

– Removing of instances does not (when serverpool is shrinked)


Summary

Policy Managed RAC It is cool

– Is highly flexible

– Reduces administrative actions

– Not (yet) possible on ExaData(?)

– Enterprise Manager (at least 13.2) can handle most of it (finally)

There are even Quality of Service features


Summary

Further Reading

– Utilizing Serverpools in Oracle Grid Infrastructurehttps://dbamarco.wordpress.com/2015/06/23/policy-management-in-oracle-grid-infrastructure/

– Using Server Categories in 12c Grid Infrastructurehttps://dbamarco.wordpress.com/2015/08/06/using-server-categories-in-12c-grid-infrastructure/

– Changing Serverpool Configuration with Policy Setshttps://dbamarco.wordpress.com/2016/01/07/changing-serverpool-configuration-with-policy-sets/

– Using Quality of Service to manage Server Pool Policieshttps://dbamarco.wordpress.com/2016/01/18/using-quality-of-service-to-manage-server-pool-policies/

– RAC SIG: Ensuring Your Oracle RAC Databases Meet Your Business Objectives at Runtimehttp://www.oracleracsig.org/events/ensuring-your-oracle-rac-databases-meet-your-business-objectives-at-runtime/

https://dbamarco.wordpress.com/2015/06/23/policy-management-in-oracle-grid-infrastructure/

https://dbamarco.wordpress.com/2015/08/06/using-server-categories-in-12c-grid-infrastructure/

https://dbamarco.wordpress.com/2016/01/07/changing-serverpool-configuration-with-policy-sets/

https://dbamarco.wordpress.com/2016/01/18/using-quality-of-service-to-manage-server-pool-policies/

http://www.oracleracsig.org/events/ensuring-your-oracle-rac-databases-meet-your-business-objectives-at-runtime/


Questions?

Marco MischkeLead Consultant Oracle Support

@DBAMarco

Phone: +49 351 [email protected]

www.robotron.de

dbamarco.wordpress.com

server pools & policy managed rac - home: doag … · server pools & policy managed rac...

Documents