© 2016 CLUSTRIX

The First Scale-out SQL Database Engineered for Today’s Cloud

ClustrixDB 7.5

Rupert HarwoodSupport Engineer@clustrix

Agenda

• Housekeeping• ClustrixDB v7.5 Features• ClustrixGUI Preview• Q&A

2

3

ClustrixDB 7.5 Features

Feature List

• Improved Query Fanout• Durability Options• Storage Enhancements• Improved Performance• Planner Improvements• Miscellaneous Features• Shadow (Re)Indexer

4

What is Query Fanout?

When ClustrixDB executes a query, it is split into fragments for execution. These fragments are then passed to the various CPUs for execution. Depending on the query type and complexity, each fragment can have multiple stages of execution.Query Fanout is the process by which fragments of a query are run simultaneously on multiple CPUs per node. This allows for expanded parallelism and much shorter execution times.

5

Improved Query Fanout

• Fanout multiple cores per node per phase of query execution

– Even better distribution of workloads– Increased query parallelism for faster

execution times

• Improved Fanout for DDL– ALTERS up to 400% faster– Adding Indexes and columns– Re-slicing tables

• Improved Row Based Replication speed– Up to 45% increase in performance

6

What are Durability Options?

ClustrixDB now has optional levels that allows the user to determine at which point in the commit process the application is notified of a successful commit.

7

Durability Options(1 of 2)

• Optional early commit reporting for lower latency and higher throughput

• Three possible settings to tune durability vs performance

• All transactions ultimately durable– Default Commit Reporting is full ACID– All Commit Reporting modes use the same commit process

• Session or Global Variable– Allows for critical workloads to remain fully ACID and lower value

workloads to be near-ACID.

8

Early Durability Reporting(2 of 2)

9

Storage Enhancements• New guardrails and warnings

– Prevent the database from becoming completely full– Alert at multiple levels due to severity of disk usage

10

• Pre-allocate storage– device1 (database storage) pre-

allocated at cluster formation– Configurable via ALTER command

• Pre-allocate temp space – device1-temp (temp space) pre-

allocated at database start– Configurable via global variable

Improved Performance (page 1 of 2)

• Increased near linear scale to 30 nodes

• 10x concurrency boost (number of connections per node)

• Query Fanout processing now default behavior (all previously mentioned goodies come standard)

11

Improved Performance (page 2 of 2)

• Default distribution for representations now based on first column of an index.

– Reduction in broadcasting and latency– Reduced query plan cost– Shorter query runtimes

• Performance improved for INSERT INTO... SELECT FROM... ON DUPLICATE KEY statements that encounter duplicates

• Improved performance on workloads with heavy use of temporary tables

• Performance improved for count(*)12

Planner Improvements

• Improved planning on tables with indexes

• Specific performance improvements– Queries using ISNOTNULL– Cardinality estimation after

LIMIT/OFFSET– Queries having multiple IN predicates

with OR

• Optimized planner memory management

13

Other Features in ClustrixDB v7.5

• Improved clx administration tool– Massively improved operation speed– Better error reporting

• Improved Installation Process– Better Guardrails– Easier Setup

• Fast Backup/Restore– Added database.table EXCLUDE functionality

14

Introducing the Shadow (re)Indexer

Re-write of two modules of the Magento Platform• Clustrix EAV

– Dramatically improves data store retrieval from primary data tables– Removes need for flat tables

• Reindex faster and less often

• Clustrix Indexer– Tunes indexes to run better on Clustrix– Improves processing behavior

15

What is the Clustrix Shadow (re)Indexer?

• Rewrite of the Magento Indexer and Magento EAV Systems– Optimized to address common problems on the Magento platform

experienced by high-transaction sites

• Removes frustrations and downtime stemming from catalog updates– Update catalog and index anytime– Catalog updates appear in your store in seconds– Avoid major site slow-downs due to indexing– No major downtime or check-out issues

• No impact on site performance– Users are able to browse and shop on the site

16

ClustrixGUI Preview

• ClustrixDB 7.5 includes a beta of the newly redesigned browser-based user interface, ClustrixGUI. The new UI is organized to give the user quick insight into the overall performance of key metrics.

• The health dashboard provides insight into transactions per second, CPU utilization, storage usage, and latency for both reads and writes.

• With this dashboard it is simple to get an “at a glance” overview of your clusters current and recent health.

17

The Health dashboard in ClustrixDB 7.5 provides a visual summary of your

database cluster. Quickly review key performance metrics.

Comparison

18

● In the Compare tab you can easily identify bottlenecks and performance issues.

● The comparison tool provides the ability to select two points on a graph and quickly see the queries that were running at those times.

● Extremely useful tool to identify problem queries that may be the cause of a performance slow-down or CPU spike.

Graphing

19

● The ClustrixGUI Graphs page provides a multitude of graphs for deep insight into the historical workings of the cluster.

● Completely reworked from the ground up to give a more intuitive graphing experience.

● Can now mark points in time with a picker needle to easily compare spikes and dips over multiple graphs.

Flex Up and Flex Down

● No more typing of difficult to remember and complicated IP addresses.

● Easily scan your network for available node.

● Simply scan, click, scale.

20

21

support.clustrix.com

docs.clustrix.com

22

Q&A

Thank You

facebook.com/clustrix

www.clustrix.com

@clustrix

linkedin.com/clustrix

ClustrixDB Overview23