Introducing G2.ai, the future of software buying.Try now
Compare ClickHouse and MySQL 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
RaimaDB
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
ER/Studio
Visit Website
At a Glance
Market Segments
Small-Business (47.4% of reviews)
Small-Business (36.5% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
$5,000
ClickHouse
Star Rating
(20)4.4 out of 5
Market Segments
Small-Business (47.4% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHouseMySQL
Star Rating
(1,654)4.4 out of 5
Market Segments
Small-Business (36.5% of reviews)
Entry-Level Pricing
$5,000
Browse all 3 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that MySQL excels in ease of setup with a score of 8.5, making it a preferred choice for small businesses looking for a straightforward installation process. In contrast, ClickHouse has a slightly higher ease of admin score of 7.0, indicating that while it may require more effort to manage, it offers robust features for those willing to invest the time.
- Reviewers mention that ClickHouse shines in performance analysis with a perfect score of 10.0, particularly for analytical queries, while MySQL's performance analysis score is lower at 8.3. This makes ClickHouse a better option for users needing high-speed data processing and real-time analytics.
- G2 users highlight MySQL's strong data replication capabilities with a score of 8.8, which is crucial for businesses that require reliable data backup and recovery solutions. Conversely, ClickHouse's data replication score is lower at 7.9, suggesting it may not be as robust in this area.
- Users on G2 report that MySQL's query language is highly rated at 9.3, making it user-friendly for developers familiar with SQL. ClickHouse, while also strong with a score of 9.2, is noted for its unique features that cater to analytical workloads, which may require a learning curve for traditional SQL users.
- Reviewers mention that ClickHouse offers superior scalability with a score of 9.0, allowing for linear scaling as data needs grow. MySQL, with a score of 8.1, may not scale as efficiently, making ClickHouse a better choice for businesses anticipating rapid growth.
- Users say that MySQL provides solid security features, particularly in access control with a score of 9.0, which is essential for businesses handling sensitive data. ClickHouse, while also secure, has a slightly lower score in this area, indicating that MySQL may be the safer option for security-conscious users.
Pricing
Entry-Level Pricing
ClickHouse
ClickHouse Pricing
Starting at $1.00
Per Month
Options for every user, organization, and use case.
- Up to 1 TB storage
- 16 GiB total memory
- Burstable CPU
Free Trial
ClickHouse
No trial information availableMySQL
No trial information availableRatings
Meets Requirements
8.9
11
8.9
1,384
Ease of Use
8.6
11
8.7
1,387
Ease of Setup
9.0
7
8.6
651
Ease of Admin
7.0
5
8.4
630
Quality of Support
8.7
9
8.0
1,169
Has the product been a good partner in doing business?
Not enough data
8.5
517
Product Direction (% positive)
10.0
10
8.0
1,351
Features by Category
Management
9.4
6
Not enough data
7.9
7
Not enough data
9.3
7
Not enough data
9.4
6
Not enough data
10.0
5
Not enough data
Maintenance
8.8
7
Not enough data
7.8
6
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Not enough data
Not enough data
Management
Not enough data
9.0
140
9.3
5
9.1
141
Feature Not Available
8.9
127
Not enough data
8.8
124
Support
Not enough data
8.4
134
Not enough data
8.8
138
Not enough data
8.9
132
Not enough data
9.2
130
Security
Feature Not Available
8.9
131
Not enough data
8.9
132
Not enough data
8.6
126
Not enough data
8.6
131
Performance
Not enough data
8.3
122
Not enough data
8.5
125
Not enough data
8.5
126
Not enough data
8.6
126
Not enough data
8.7
125
Database Features
9.0
5
8.8
1139
9.3
5
8.9
1149
9.0
5
8.7
1151
9.0
5
8.1
1117
Not enough data
8.4
1112
Not enough data
8.7
1123
8.7
5
8.9
1143
Storage
9.2
6
Not enough data
9.0
7
Not enough data
Availability
Feature Not Available
Not enough data
7.8
6
Not enough data
8.3
6
Not enough data
Performance
8.1
6
Not enough data
Security
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
8.3
5
Not enough data
Support
Not enough data
Not enough data
Not enough data
Not enough data
Query latency
Not enough data
Not enough data
Not enough data
Not enough data
Data latency
Not enough data
Not enough data
Not enough data
Not enough data
Connectors
Not enough data
Not enough data
Not enough data
Not enough data
Scale
Not enough data
Not enough data
Not enough data
Not enough data
Architecture
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
ClickHouse and MySQL are categorized as Relational Databases
Unique Categories
ClickHouse is categorized as Real-time Analytic Database, Database Management Systems (DBMS), and Columnar Databases
MySQL has no unique categories
Reviews
Reviewers' Company Size
ClickHouse
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
MySQL
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
31.6%
Computer Software
21.1%
Wholesale
5.3%
Telecommunications
5.3%
Marketing and Advertising
5.3%
Other
31.6%
Information Technology and Services
24.8%
Computer Software
20.4%
Internet
4.6%
Higher Education
4.2%
Education Management
3.4%
Other
42.7%
Alternatives
Discussions
ClickHouse has no discussions with answers
Does MySQL new version has strong security?
10 Comments
JH
here is list of some overlooked security holes in MySql:
update the password plugin;
password for the root account
root accounts that are...Read more
Is there any possibilities than mysql database can be online?
2 Comments
CH
Of course! Most hosts provide it automatically. Only the dedicated servers or virtual servers might not. You can install it on any Linux or Windows or Mac...Read more
What version of MySQL do I have?
2 Comments
HD
You can use MySQL Workbench to check the version number. After connected to a server using MySQL Workbench, click on server from main menu. Then "Server...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
