What it does
The ClickHouse Integration module automatically stores non-essential data (like logs and historical records) in a separate high-speed database called ClickHouse. This frees your main database (PostgreSQL, MariaDB, or MySQL) from heavy loads, improving everyday performance while keeping all information available when needed.
Why it matters
- Faster system performance: Your primary database responds quickly because it no longer handles huge volumes of background data.
- No data loss: All records remain safe and accessible, nothing is deleted, only moved.
- Same user experience: The application interface works the same for users; sorting, filtering, and reports continue to function as before.
- Smaller backups: Backups of your primary database become smaller and faster to create and restore.
- Better reporting: ClickHouse is optimized for fast reporting and analytics over large datasets.
Key Scenarios It Solves
- Log management: Store audit trails and event logs separately so they don’t slow down daily operations.
- Reporting & analytics: Run large reports and dashboards from ClickHouse without affecting the main system.
- Data archiving: Keep historical records accessible without cluttering the primary database.
How it works
The system copies selected data from the main database to ClickHouse on a regular schedule. Your main application continues to use the primary database for normal tasks, while ClickHouse holds large, older, or less critical records for fast queries and reporting.
Quick setup overview
Setup is handled in a few straightforward steps:
- Install ClickHouse (server software).
- Connect ClickHouse to your application and prepare the schema.
- Run a one-time transfer of existing data.
- Enable regular synchronization to copy new records automatically.
Backup & maintenance
The module includes a simple backup script to save ClickHouse data and remove old backups automatically, helping you keep storage tidy and safe.
Documentation
You can find full installation, configuration, and backup instructions for the ClickHouse Integration module in the Help Center .
License
This module is distributed under a Proprietary License.
Demo & Customization
To access a demo or discuss customizing the module to fit your requirements, contact AtroCore.