ScaleArc's database load balancing software is built on ScaleArc’s patented Ternion™ technology. Ternion, Latin for “a group of three,” refers to the three engines that work in unison to maximize application uptime and performance.
The SQL state engine and dynamic rules engine work together to assess and route queries, providing SQL query handling on behalf of applications. The analytics engine uses insights learned from the state engine to update the rules engine to further optimize your apps.
Ternion is at the heart of our software's ability to interact seamlessly with such a wide array of SQL databases, enabling resiliency and scalability benefits without any changes to your applications.
ScaleArc’s SQL state engine is the industry’s first universal database state recognition engine. It allows us to deeply inspect a database protocol stream and parse SQL states that reveal a lot about an application’s behavior with the database - in an extremely granular way.
ScaleArc's SQL state engine is unique in not relying on the source code or parser of a specific database server. Instead, it delivers a universal way to recognize state across different database protocols, allowing us to understand when a transaction begins or ends, what kind of queries go in that transaction, if they are reads or writes, and what database or tables those queries are addressing.
The ScaleArc SQL state engine also reveals other critical data, such as the user, authentication permissions, and type of errors given by the database in response to various problems. This engine then converts each one of these states into data points the ScaleArc rules engine can use to make decisions on what actions to perform with a database connection or query when it arrives at ScaleArc.
Once the ScaleArc SQL state engine parses the database protocol stream and can provide accurate state data, the dynamic rules engine is invoked. This dynamic decision matrix lets users create rules to match SQL state or queries, and it performs a wide set of actions that the SQL state engine applies to the database traffic, such as caching or query routing.
Some rules are built into the engine, such as the ability to automatically send writes and transactions to a primary or master and load balance reads across all available and healthy secondary or slave servers. ScaleArc operators define other rules, such as a query routing rule to always send a particularly large reporting query to a specific server in the cluster, or a caching rule that caches all queries to the zip codes table for 24 hours. The rules can be hand-crafted or built using ScaleArc’s user-friendly analytics engine.
The SQL analytics engine generates extremely granular logs and stats data that captures the whole life of a SQL connection, from start to end, and in aggregate across an entire application.
The analytics engine comprises two parts. The first is a big data processing system that crunches all the logs and stats into a set of predefined reports in near real time. The second is a graphical user interface that lets users investigate that data easily - and create rules out of that data that feed back into the dynamic rules engine.
With ScaleArc's analytics, a user could find a poorly performing query pattern in seconds and create a cache rule to offload it from the database server in another second - and then immediately see the improvement in application performance in ScaleArc’s real-time analytics.
ScaleArc has been granted a multitude of patents. These patents protect and highlight the unique contributions of ScaleArc’s Ternion™ technology. The patents cover our unique transparent SQL traffic management methods.
Our granted patents include: