ScaleArc for MySQL Administrator's Guide

Table of Contents

Introducing ScaleArc
What is ScaleArc?
Benefits of ScaleArc
ScaleArc Features
Terms and definitions
Installing ScaleArc
Installation Prerequisites
Installing ScaleArc
On-premise installation
>> Install ScaleArc on Bare Metal
>> Install ScaleArc on Hyper-V
>> Install ScaleArc on VMware
>> Install ScaleArc on XenServer
>> Custom Install
Cloud-based installation
>> Install ScaleArc on MS Azure
>> ScaleArc HA on MS Azure
>> Install ScaleArc on AWS
>> ScaleArc HA on AWS
>> Install ScaleArc on Google Cloud (GCP)
Upgrading ScaleArc to the Latest version
>> Upgrading a ScaleArc HA Deployment
Initialize ScaleArc
Configure basic settings
Configuring ScaleArc Clusters

Introduction to ScaleArc Clusters
Creating Clusters
>> Configure ScaleArc endpoints
>> Configure Database Access
>> Adding Database Servers to a Cluster
>> Configure Standalone servers
>> Configure Aurora server
>> Configuring Cluster SSL Settings
Cluster Configuration
>> ScaleArc Cluster Info
>> Cluster Control Panel Overview
>> Cluster Control Panel - Status Column
>> Cluster Settings - Client & Server Traffic Settings
>> Configuring Cluster Settings - ScaleArc
>> Cache Settings
>> Configuring Cluster Settings - Auto Failover
>> Configure SSL
>> Advanced Cluster Settings
>> Configuring Cluster Settings - Debug

Settings Column

>> Managing Users & DBs
>> Transparent Cache
>> Cache rules and Pre-cache Rules
>> Cache Manager
>> Configuring Stored Procedure Query Caching
>> Cache Invalidation
>> Load Balancing and Routing
>> Configuring Query Firewall Rules
>> Log Settings
Configuring Database Servers

 
Back to top

Getting started

Installing ScaleArc

Configure ScaleArc

Learn the benefits and features of ScaleArc.

Evaluate your on-premise or cloud-based enterprise
Install or upgrade ScaleArc.
Initialize ScaleArc and configure its basic functions.
Determine user authentication requirements
Create a ScaleArc endpoint cluster.
Configure ScaleArc's advanced features for load balancing, zero downtime, Always On and automated failover, security, and performance

Administering ScaleArc

Real-Time Monitoring

ScaleArc Analytics

Administer ScaleArc's many systems, cluster, and log settings. Live monitor ScaleArc for upgrading performance in real-time.  Use the powerful suite of Analytics tools to review, evaluate, and manage ScaleArc's performance and security at varying degrees of granularity.

.

Administering ScaleArc

Real-Time Monitoring

Administering ScaleArc - Introduction
Network Settings Configuration
System Settings
>> System Status
>> System Config
>> System Services
Configuring Email Alerts
Setting up HA (High Availability)
License Settings
User Management
>> Policy and Access Control configuration
>> Authentication Configuration
>> Editing the Authentication Module
Using ScaleArc RESTful APIs
Managing CPU Distribution
Real-Time Monitoring - Introduction
Live Monitor - System Stats
Live Monitor - Cluster Stats
Live Monitor - Historical Stats
Live Monitor - Logs
Live Monitor - Diagnostics
>> File Browser
>> Traffic Analyzer
Live Monitor - Value Meter
   

Analytics

Appendices

Using ScaleArc Analytics
Analytics - Total Cluster Traffic Analysis
Analytics - Cluster Analysis
Analytics - Database Server Analysis
Analytics - Query Pattern Analysis
Analytics - Unique Query Analysis
Analytics - Comparative Analysis
Analytics - Log Search
>> Deployment checklist
>> Cluster configuration checklist
>> ScaleArc Sizing Guide
>> ScaleArc Appliance Console Login
>> List of ports on ScaleArc
>> CPU distribution - Thread Mapping
>> Best practices for VM migration
>> Database replication topologies
>> Third-party software dependencies