Apache Kafka vs. MySQL

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Kafka
Score 8.4 out of 10
N/A
Apache Kafka is an open-source stream processing platform developed by the Apache Software Foundation written in Scala and Java. The Kafka event streaming platform is used by thousands of companies for high-performance data pipelines, streaming analytics, data integration, and mission-critical applications.N/A
MySQL
Score 8.3 out of 10
N/A
MySQL is a popular open-source relational and embedded database, now owned by Oracle.N/A
Pricing
Apache KafkaMySQL
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Apache KafkaMySQL
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Apache KafkaMySQL
Considered Both Products
Apache Kafka

No answer on this topic

MySQL
Chose MySQL
SQLite - Is the goto DB for Mobile/Desktop Apps. Its not as elaborate as Mysql but since its a RDBMS it provides all the basic features and its lite. We use mysql at the backend and for desktop app we use SQLite

postgres - Its a formidable opponent. It is fast and reliable and …
Chose MySQL
MySQL provides the option to reduce support and maintenance cost when P0 Level 1 support is not really needed for databases used for noncritical use cases and workloads. Other versions that include Microsoft SQL, Amazon RDS, etc don't provide such options and are overkill. …
Top Pros
Top Cons
Best Alternatives
Apache KafkaMySQL
Small Businesses

No answers on this topic

Redis™*
Redis™*
Score 9.0 out of 10
Medium-sized Companies
IBM MQ
IBM MQ
Score 9.0 out of 10
Redis™*
Redis™*
Score 9.0 out of 10
Enterprises
IBM MQ
IBM MQ
Score 9.0 out of 10
Redis™*
Redis™*
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache KafkaMySQL
Likelihood to Recommend
8.3
(18 ratings)
8.2
(134 ratings)
Likelihood to Renew
9.0
(2 ratings)
9.9
(4 ratings)
Usability
10.0
(1 ratings)
10.0
(6 ratings)
Support Rating
8.4
(4 ratings)
8.6
(2 ratings)
Implementation Rating
-
(0 ratings)
8.0
(1 ratings)
User Testimonials
Apache KafkaMySQL
Likelihood to Recommend
Apache
Apache Kafka is well-suited for most data-streaming use cases. Amazon Kinesis and Azure EventHubs, unless you have a specific use case where using those cloud PaAS for your data lakes, once set up well, Apache Kafka will take care of everything else in the background. Azure EventHubs, is good for cross-cloud use cases, and Amazon Kinesis - I have no real-world experience. But I believe it is the same.
Read full review
Oracle
From my own perspective and the tasks that I perform on a daily basis, MySQL is perfect. It has a reasonable footprint, is fast enough and offers the security and flexibility I need. Everyone has their preferred applications and, no doubt, for larger data warehouses or more intensive applications, MySQL may have its limits, but for the area that I operate in, it's a great match.
Read full review
Pros
Apache
  • Really easy to configure. I've used other message brokers such as RabbitMQ and compared to them, Kafka's configurations are very easy to understand and tweak.
  • Very scalable: easily configured to run on multiple nodes allowing for ease of parallelism (assuming your queues/topics don't have to be consumed in the exact same order the messages were delivered)
  • Not exactly a feature, but I trust Kafka will be around for at least another decade because active development has continued to be strong and there's a lot of financial backing from Confluent and LinkedIn, and probably many other companies who are using it (which, anecdotally, is many).
Read full review
Oracle
  • Security: is embedded at each level in MySQL. Authentication mechanisms are in place for configuring user access and even service account access to applications. MySQL is secure enough under the hood to store your sensitive information. Also, additional plugins are available that sit on top of MySQL for even tighter security.
  • Widely adopted: MySQL is used across the industry and is trusted the most. Therefore, if you face any problems, simply Google it and you shall land in plenty of forums. This is a great relief as when you are in a need of help, you can find it right in your browser.
  • Lightweight application: MySQL is not a heavy application. However, the data you store in the database can get heavy with time, but as in the configuration and MySql application files, those are not very heavy and can easily be installed on legacy systems as well.
Read full review
Cons
Apache
  • Sometimes it becomes difficult to monitor our Kafka deployments. We've been able to overcome it largely using AWS MSK, a managed service for Apache Kafka, but a separate monitoring dashboard would have been great.
  • Simplify the process for local deployment of Kafka and provide a user interface to get visibility into the different topics and the messages being processed.
  • Learning curve around creation of broker and topics could be simplified
Read full review
Oracle
  • Although you can add the data you require as more and more data is added, the fixity of it becomes more critical.
  • As the demand, size, and use of the system increase, you may also need to change or acquire more equipment on your servers, although this is an internal inconvenience for the company.
Read full review
Likelihood to Renew
Apache
Kafka is quickly becoming core product of the organization, indeed it is replacing older messaging systems. No better alternatives found yet
Read full review
Oracle
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
Read full review
Usability
Apache
Apache Kafka is highly recommended to develop loosely coupled, real-time processing applications. Also, Apache Kafka provides property based configuration. Producer, Consumer and broker contain their own separate property file
Read full review
Oracle
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
Read full review
Support Rating
Apache
Support for Apache Kafka (if willing to pay) is available from Confluent that includes the same time that created Kafka at Linkedin so they know this software in and out. Moreover, Apache Kafka is well known and best practices documents and deployment scenarios are easily available for download. For example, from eBay, Linkedin, Uber, and NYTimes.
Read full review
Oracle
The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
Read full review
Implementation Rating
Apache
No answers on this topic
Oracle
1. Estimate your data size. 2. Test, test, and test.
Read full review
Alternatives Considered
Apache
I used other messaging/queue solutions that are a lot more basic than Confluent Kafka, as well as another solution that is no longer in the market called Xively, which was bought and "buried" by Google. In comparison, these solutions offer way fewer functionalities and respond to other needs.
Read full review
Oracle
MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.
Read full review
Return on Investment
Apache
  • Positive: Get a quick and reliable pub/sub model implemented - data across components flows easily.
  • Positive: it's scalable so we can develop small and scale for real-world scenarios
  • Negative: it's easy to get into a confusing situation if you are not experienced yet or something strange has happened (rare, but it does). Troubleshooting such situations can take time and effort.
Read full review
Oracle
  • As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
  • The acquisition by Oracle makes you need to contract support for the enterprise version
  • If you have knowledge about oracle databases, you can get more out of the enterprise version
Read full review
ScreenShots