Introduction
CCX is a 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.
Architecture at a glance
The control plane automates the database lifecycle; the data plane is where the databases and their data live, inside your own infrastructure. For the services, ports and traffic flows behind this picture, see the detailed Architecture.
Installation
Check out our Architecture and installation guide to get started.
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:
Database Support
Our platform is compatible with a diverse array of database types, including:
- MariaDB
- MySQL
- PostgreSQL
- Redis
- Valkey
- 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.
AI Assistants (MCP)
CCX ships two MCP servers for AI assistants such as Claude Code: ccx-admin-mcp gives operators a view across all users and datastores (status, nodes, audit logs, users, billing usage), and ccx-mcp lets customers manage their own datastores. Read more in Admin MCP server and MCP server for AI assistants.
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.