Index - severalnines/ccx-admin-guide GitHub Wiki

CCX

Comprehensive data management and storage solution that offers a range of features including flexible node configurations, scalable storage options, secure networking, and robust monitoring tools. It supports various deployment types to cater to different scalability and redundancy needs, alongside comprehensive management functions for users, databases, nodes, and firewalls. The CCX project provides a versatile platform for efficient data handling, security, and operational management, making it suitable for a wide array of applications and workloads.

Deployment Solutions

Our deployment solutions offer customizable configurations for various node types, designed to support both dynamic and ephemeral storage requirements across multiple cloud environments. This includes comprehensive support for a wide range of cloud regions and instances, ensuring flexibility and scalability.

Cloud Service Providers

We support integration with several leading Cloud Service Providers (CSPs), including:

  • Amazon Web Services (AWS)
  • OpenStack

Database Support

Our platform is compatible with a diverse array of database types, including:

  • MariaDB
  • MySQL
  • PostgreSQL
  • Redis
  • Microsoft SQL Server

Node Configurations

We provide support for various node configurations to meet your database needs:

  • Replica nodes for MariaDB, MySQL, PostgreSQL, Redis, and Microsoft SQL Server (Single server and Always-On).
  • Galera clusters for MariaDB and MySQL.

Database deployment topologies

MySQL & MariaDB

  • Single (replication or Galera type).
  • One primary and multiple read-only standby with (Asynchronous and Semi-synchronous replication). Separate hostname (DNS) based access URLs for primary and read-only replicas.
  • Multi-Primary (Galera).

PostgreSQL

  • Single.
  • One primary and multiple read-only hot-standby. Separate hostname (DNS) based access URLs for primary and read-only replicas.

Redis

  • Single.
  • One primary and multiple read-only standby. Separate hostname (DNS) based access URLs for primary and read-only replicas.

Microsoft SQL server

  • Single.
  • One primary and multiple standby (mssql_ao_async)
    • Standard license - up to 2 nodes
    • Enterprise license - up to 5 nodes

Features

Monitoring and Management

Our platform features advanced monitoring capabilities, offering detailed performance analysis through extensive charts. It enables efficient management of nodes, including:

  • Datastore scaling
  • Volume scaling
  • Promote replica to primary
  • Node repair mechanisms

User and Database Administration

We offer sophisticated tools for managing database users and their permissions, ensuring secure access control.

Network Security

Our firewall configuration options are designed to enhance network security, providing robust protection for your data.

Event Logging

The event viewer tracks and displays a comprehensive history of operations performed on the datastore, enhancing transparency and accountability.

Backup and Recovery

Our backup solutions include:

  • Incremental and full backup options for comprehensive data protection
  • Point-in-time recovery capabilities
  • Automated cloud backup uploads with customizable retention periods
  • Restoration from separate volumes to optimize datastore space utilization

Customizable Settings

We offer customizable settings for various operational database parameters, allowing for tailored database management.

Account Management

Our platform facilitates user account creation and management, streamlining the login and registration process.

Billing and Payments

Our billing and payment processing tools are designed to simplify financial transactions, including the management of payments and invoices.

Feature Matrix

Each datastore has different features and are suitable for different use cases. Below is a feature matrix showing what operational feature is supported on each datastore:

Feature MySQL MariaDB PostgreSQL Redis Microsoft SQL Server
Standalone AlwaysOn(Standard license)
Provisioning and Deployment
Customers will be able to provision your infrastructure resources and deploy a database on them in clicks.
Standalone ✓ ✓ ✓ ✓ ✓ ✓
Cluster/Replication ✓ ✓ ✓ ✓ ✗ ✓
Failover and Automatic Recovery
CCX constantly checks the pulse of your customers’ DBs and underlying resources and proactively fixes any issues.
Automatic failover ✓ ✓ ✓ ✓ ✗ ✓
Scaling
You can enable your customers to right-size their data layer to their specific requirements.
Add/Remove nodes ✓ ✓ ✓ ✓ ✗ ✓
Scale volume* ✓ ✓ ✓ ✓ ✓ ✓
Backups and Recovery
Customers can implement a sophisticated backup and disaster recovery strategy.
Backup to S3-compatible storage ✓ ✓ ✓ ✓ ✓ ✓
Restore ✓ ✓ ✓ ✓ ✓ ✓
Point-in-time recovery ✓ ✓ ✓ ✓ ✗ ✓
Create datastore from backup ✓ ✓ ✓ ✗ ✗ ✗
Management
Customers can trigger management jobs
Datastore upgrade ✓ ✓ ✓ ✓ ✓ ✓
Operating system upgrade ✓ ✓ ✓ ✓ ✓ ✓
Promote replica ✓ ✓ ✓ ✓ ✓ ✓
Configuration management ✓ ✓ ✓ ✓ ✗ ✗
User management** ✓ ✓ ✓ ✓ ✓ ✓
Create databases ✓ ✓ ✓ ✓ ✗ ✗
Firewall ✓ ✓ ✓ ✓ ✓ ✓
Observability
Your customers can see what is going on up and down the data stack, pinpointing any issues.
Monitoring dashboards ✓ ✓ ✓ ✓ ✓ ✓
Query monitoring ✓ ✓ ✓ ✓ ✓ ✓
Database growth ✓ ✓ ✓ ✓ ✗ ✓
Export metrics to Prometheus/VictoriaMetrics ✓ ✓ ✓ ✓ ✓ ✓

* Scale volume is NOT supported for any ephemeral storage datastores. ** User management features and scope depends on the underlying datastore. There are datastore specific limitations.

⚠️ **GitHub.com Fallback** ⚠️