Events about SPARC, Solaris, ZFS and ... Q3/Q4 2020

ONLINE: Oracle Systems Engineering Forum: Oracle Servers
09/29/2020  9:00am PT 

https://go.oracle.com/LP=99024?src1=:ow:lp:cpo:::LPD400085579&intcmp=WWMK200707P00014:ow:lp:cpo:::LPD400085579

 

 

ONSITE: DOAG 2020 Conference in Nuremberg Germany
11/17/2020 - 11/19/2020

https://2020.doag.org/de/home/

11/17/2020 12:00

Einsatz der Recovery Appliance - Ist es wirklich so einfach?

11/19/2020 12:00

Oracle Database on Solaris ZFS done right

Why we are using SPARC LDoms

Oracle and Fujitsu SPARC Servers include the LDoms Technology. There are no additional costs.
If you see the "Marketing" name 'Oracle VM Server for SPARC'. That is exactly this LDoms Technology.

You can create individual Domains with dedicated CPU and RAM resources running
different Solaris Releases. Use of CPU and RAM is very efficient, because there is no software layer involved. You can add and remove CPU and RAM while the LDoms is running!

Access to Disk and Network can be done virtualized. Performance is good. Using such a virtualized setup the Domains can be live migrated between Servers with the same type of CPU. You can cold migrate (with downtime) between different types of Server in a few minutes.

You place different customers and applications in different LDoms. Good aproach to consolidate your environment.

We at JomaSoft use this technology very successful since years ourselfs and at customer sites.
Our VDCF tool makes deployment and management of LDoms very easy.

Learn more:
https://www.oracle.com/virtualization/vm-server-for-sparc/

https://www.oracle.com/technetwork/server-storage/vm/ovmsparc-best-practices-2334546.pdf

https://blog-archive.global.fujitsu.com/easy-flexible-control-of-your-virtualized-datacenter-with-vdcf-2/ 

https://www.jomasoft.ch/vdcf/

Performance Impact of ZFS Encryption on Oracle Solaris

Transparent Encryption is very easy to use on Oracle Solaris.
You just need to set the encryption property when you create a new filesystem and provide a passphrase or keyfile.

On a SPARC S7 LDom we have 3 ZFS filesystems with different encryption settings.

# zfs get encryption v0123_db/plain v0123_db/encr v0123_db/encr256
NAME              PROPERTY    VALUE        SOURCE
v0123_db/encr     encryption  on           local
v0123_db/encr256  encryption  aes-256-ccm  local
v0123_db/plain    encryption  off          -
Now lets see how much is the difference in write performance if we copy a 1 GB file.

# ls -lh p25604852_1100_Solaris86-64_1of4.zip
-rw-r--r--   1 marcel   staff       1.3G Apr  7  2017 p25604852_1100_Solaris86-64_1of4.zip
#

# time cp p25604852_1100_Solaris86-64_1of4.zip /plain

real    0m8.829s
user    0m0.002s
sys     0m1.711s

# time cp p25604852_1100_Solaris86-64_1of4.zip /encr

real    0m9.229s
user    0m0.002s
sys     0m1.747s

# time cp p25604852_1100_Solaris86-64_1of4.zip /encr256

real    0m9.733s
user    0m0.002s
sys     0m1.754s

The difference is a low one digit percent value.

Performance impact is a little larger when doing a simple read test.

# time cp /plain/p25604852_1100_Solaris86-64_1of4.zip /tmp

real    0m4.216s
user    0m0.002s
sys     0m3.810s

# time cp /encr/p25604852_1100_Solaris86-64_1of4.zip /tmp

real    0m5.131s
user    0m0.003s
sys     0m5.028s

# time cp /encr256/p25604852_1100_Solaris86-64_1of4.zip /tmp

real    0m5.400s
user    0m0.003s
sys     0m5.287s

Learn more about ZFS encryption with the Oracle Solaris 11.4 ZFS Admin Guide

https://docs.oracle.com/cd/E37838_01/html/E61017/gkkih.html

Oracle Database on Solaris ZFS done right

ZFS is the default filesystem on Oracle Solaris. It is

very easy to use with the two commands zpool and zfs.

Disk management

Expand existing LUNs or add additional LUNs if you

need more space. Since Solaris 11.4 you can remove LUNs if you

want to shrink your pool.

Features

No need for filesystem checks, because of the copy-on-write

implementation. You can create snapshots and clones,

use encryption and compression. Transfer data to other

systems using send/receive or sharing.

Move the pools using export/import to other systems.

ZFS builds the base for the Solaris BootEnvironment (beadm)

where you are able to update to and boot from different Solaris 11

Updates.

ZFS is my preferred filesystem and volume manager, but

is everything perfect? No. You need to carefully configure

ZFS to avoid and work around fragmentation.

Oracle Database

You can run Oracle Database very well on ZFS and profit

from snapshots, cloning and other features. Especially

for larger databases (many TB) with lots of data changes

you should setup carefully.

Following a few Best Practices based on own experiences

and Recommendations by Oracle:

- data pool with log device / 8KB recordsize for data / logbias=latency

- redo pool with log device / 1MB recordsize / logbias=latency

- archive pool / 1MB recordsize

Add multiple LUNs for striping. Use SSDs for highest performance.

If you are using SAN increase zfs:zfs_vdev_max_pending and ssd:ssd_max_throttle to 20.

Limit the ZFS Cache (zfs:zfs_arc_max)

Make sure there is around 20% free space on the zpools.

Use a Server with 'enough' Memory.

After many years of using ZFS it always hurts, if I have

to use other more complicated filesystem ....

Links

Pool Creation Practices for an Oracle Database (Solaris 11.4 ZFS Guide)

https://docs.oracle.com/cd/E37838_01/html/E61017/zfspools-4.html#SVZFSstorage-6

Configuring Oracle ZFS for an Oracle Database Whitepaper (2014)

https://www.oracle.com/technetwork/server-storage/solaris/config-solaris-zfs-wp-167894.pdf

Oracle DB erfolgreich betreiben auf SPARC/LDoms/Solaris/ZFS     (German Presentation)

https://www.jomasoft.ch/docs/DOAG18_JomaSoft_DB_Solaris_ZFS.pdf

New Oracle SPARC and Solaris Webcasts on Demand / April 2020

Learn about the Security features and Performance of the
Oracle SPARC Servers.

Upgrade to Solaris 11.4, which includes the new Web Dashboard,
Compliance, Virtualization and much more.

Why SPARC for most demanding mixed Database workloads
45 Minutes
https://go.oracle.com/LP=89566

Oracle Solaris and SPARC Virtual Seminar
2 Hours 15 Minutes
https://go.oracle.com/LP=91258

Oracle Systems Customer Forum / June 2020

Original plan was:

Tuesday, 17 March 2020  09:00 - 17:30
A full day event in Prague (Czech Republic)

NOW postponed to Early June 2020

with Oracle Systems Engineering and Product Management onsite

Learn the benefits in 2 tracks about Oracle SPARC/Solaris and Oracle PCA
Performance Analysis, Optimizing Lifecycle, Security & Compliance,
Beating Ransomware and a lot more ...

Full Agenda
https://www.oracle.com/a/ocom/docs/dc/em/systems-customer-forum-prague-2020-web.pdf

Registration is open
https://eventreg.oracle.com/profile/web/index.cfm?PKwebID=0x720861abcd

And Prague is a very nice City !!

See you there!

New Oracle Solaris eBook is available

Read the new Oracle Solaris eBook
Oracle Solaris: The Ideal Operating System for Your Oracle Database

Available for free, eMail address registration required.