MySQL is too slow
MemCP — Faster alternative when "MySQL is too slow"
Short description: MemCP is an in-memory, column-oriented database optimized for high throughput OLAP and OLTP workloads. It is designed to deliver much faster aggregation and query performance than traditional row-based engines like MySQL.
Overview
MemCP is a blazing-fast, in-memory, columnar database with built-in REST APIs and a lightweight SQL frontend. It is intended for modern workloads where MySQL becomes a bottleneck for aggregation and analytic queries.
Key benefits
- In-memory, columnar storage — very fast for aggregations and analytics.
- MySQL-compatible SQL frontend — easy to try alongside existing MySQL deployments.
- Low memory footprint for base system — minimal system requirements for core system.
- Open source — source code and history available on GitHub.
When to consider MemCP
- Your MySQL instance struggles with large aggregations or analytics queries.
- You want an in-memory option that provides much faster group/aggregation performance.
- You need a developer-friendly, REST-accessible datastore for microservices.
Quickstart / Installation
A basic example (high level):
# 1) Clone the repository git clone https://github.com/launix-de/memcp.git # 2) Build / run according to README (see GitHub repo for exact commands) cd memcp # follow build/run instructions from repository README
Example usage
- MemCP runs a small management service and exposes a MySQL-compatible port for clients (see documentation and examples on the project pages).
- For microservices, MemCP provides example code showing prepared statements and a simple key/value microservice using the built-in SQL frontend.
Benchmarks & comparisons
MemCP's documentation and comparison pages describe performance improvements versus MySQL for aggregation workloads (examples and benchmark summaries are available on the project site). Please consult the project's "Comparison: MemCP vs. MySQL" page and published benchmarks for details.
Links / Resources
- Official site: https://memcp.org
- Project & source: https://github.com/launix-de/memcp
License
MemCP is published under GPL 3 in the GitHub repository