Please welcome again – visitor blogger, Tushar Patel, Principal Engineer, Cisco
Not too long ago I revealed a weblog that reviewed the know-how advances that Cisco Techniques put into the Cisco UCS X-Sequence Modular System making it a real hybrid-cloud platform full with cloud-based administration by Cisco Intersight and a spread of compute nodes which can be “like” rack optimized servers that slide vertically into the X9508 chassis. I say “like” in that these nodes comprise as much as six NVMe drives that can be utilized to deal with functions and knowledge (two HW RAID1 drives individually home the working system) thus offering the choice of internet hosting a single occasion Oracle database. I closed that weblog mentioning that baseline testing utilizing FIO (business workload utility) to generate the utmost variety of IOPS (Enter Output Per Second) that might be supported at 37million IOPS utilizing 4K knowledge blocks.
Oracle database directors (DBA) could also be considering, that was begin however what about true Oracle workloads? I agree, let’s discover out.
We used Oracle Foolish Little Oracle Benchmark (SLOB) and Oracle SwingBench to check Cisco X210c M6 efficiency on a single compute node. These checks use 8K knowledge blocks as is typical with Oracle databases. The in depth particulars are on this whitepaper or learn the highlights beneath.
SLOB Check Outcomes
The Foolish Little Oracle Benchmark (SLOB) is a toolkit for testing I/O via an Oracle database. SLOB could be very efficient in testing the I/O subsystem with real Oracle SGA-buffered bodily I/O. SLOB helps testing bodily random single-block reads (db file sequential learn) and random single block writes (DBWR flushing functionality). SLOB points single block reads for the learn workload which can be usually 8K (because the database block measurement was 8K).
The Person Scalability take a look at was carried out with 64, 128, 192, 256, 384 and 512 customers on single occasion Oracle Database node by various learn/write ratio as defined beneath:
100% learn (0% replace)
90% learn (10% replace)
70% learn (30% replace)
50% learn (50% replace)
As you possibly can see the scalability is superb as most Oracle clients run an 80-20 or 70-30 learn/write ratio of their workloads. The system latency ranged from 0.11 milli-seconds (ms) for 100% reads to 0.59 ms for a learn/write of 50-50.
Key takeaways are:
• Outcomes are roughly half of the variety of IOPS in comparison with FIO take a look at referenced above utilizing 4k knowledge blocks, however SLOB makes use of 8k knowledge blocks. Thus, comparable IOPS efficiency.
• Continued close to linear scalability from 64 via 512 customers with low latency
SLOB affords a extra life like take a look at of the I/O subsystem in comparison with FIO. SLOB make precise transaction requests which course of knowledge after which modify the database as required. Consider this as extra aligned to a TPC-C (Transaction Processing Efficiency Council Benchmark C) OLTP (on-line transaction processing) benchmark workload the place many small transactions randomly hit the database. An instance is an airline reservation system.
Swingbench is a straightforward to make use of, free, Java-based instrument to generate numerous sort of database workloads and carry out stress testing utilizing totally different benchmarks in Oracle database environments. On this answer, we have now used Swingbench instrument for working Swingbench Order Entry (SOE) benchmark for representing OLTP sort of workload and captured the general efficiency of this reference structure.
The Order Entry benchmark is predicated on SOE schema and is TPC-C like by varieties of transactions. The workload makes use of a really balanced learn/write ratio round 60/40 and may be designed to run repeatedly and take a look at the efficiency of a typical Order Entry workload towards a small set of tables, producing competition for database assets.
For this take a look at we created a 3TB database and set it up as a pluggable database inside a container database infrastructure. Listed here are the testing outcomes:
Wow, these are glorious outcomes and indication that the Cisco UCS X210c M6 could be a superb server to host single occasion Oracle database 19c. The important thing takeaways are:
• Over 2.8 million transactions per minute
• Clearly there may be ample headroom to tackle extra transactions as want dictate
• IOPS scale as anticipated and with typical learn/write ratios used
• Viewing the AWR report from the database signifies no wait occasion (congestion) detected
Confirmed Efficiency Ought to Disk Failure Happen
Past uncooked efficiency, the problem that causes DBAs to lose sleep is what’s the affect to this efficiency when a disk drive fails?
To check this subject, we have now a working database working throughout 5 drives on the Cisco X210c compute node. We then pull out a drive and pressure the system to take away the drive from Oracle ASM. We then reinsert this drive and have ASM add this “new” drive again into the ASM for the database. By reviewing the chart beneath:
• Efficiency solely dropped by about 10percentwhen drive failure occurred
• ASM took 10 minutes to take away the drive from the disk group
• As soon as the brand new drive inserted, ASM required solely 25-Half-hour to rebalance the workload and produce database efficiency to the prior stage
Oracle ASM gives the flexibility to routinely rebalance the database when a drive failure happens. Subsequently, the affect of a drive failure just isn’t as impactful as had been the case years in the past and will a drive fail on the Cisco X210c M6 this take a look at exhibits a reasonably low affect that permits for work to proceed to course of.
Now I need to warning that testing your personal database arrange might alter the outcomes for any variety of causes akin to learn/write ratio and so on. In abstract, nonetheless, in case you are seeking to replace your server infrastructure to host 1-8 single situations of Oracle (one per compute node) you need to strongly think about Cisco UCS X-Sequence. Thanks for studying.