No more typing reviews! Try our Samantha, our new voice AI agent.

Faiss vs MySQL comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 23, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Faiss
Ranking in Open Source Databases
13th
Average Rating
8.0
Reviews Sentiment
3.3
Number of Reviews
3
Ranking in other categories
Vector Databases (14th)
MySQL
Ranking in Open Source Databases
2nd
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
152
Ranking in other categories
Relational Databases Tools (4th)
 

Mindshare comparison

As of September 2026, in the Open Source Databases category, the mindshare of Faiss is 2.9%, down from 3.6% compared to the previous year. The mindshare of MySQL is 12.5%, up from 9.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Open Source Databases Mindshare Distribution
ProductMindshare (%)
MySQL12.5%
Faiss2.9%
Other84.6%
Open Source Databases
 

Featured Reviews

Kalindu Sekarage - PeerSpot reviewer
Senior Software Engineer
Integration improves accuracy and supports token-level embedding
The best features FAISS offers for my team include seamless integration with Colbert and the ability to use FAISS via the Ragatouille framework, which is tailor-made for using the Colbert model. Feature-wise, FAISS allows for more accurate result retrieval, and retrieval speed is also good when comparing the index size. Regarding features, I also emphasize that the usability of FAISS is very seamless, particularly its integration with Colbert and Ragatouille. FAISS has positively impacted my organization by helping us increase the accuracy of retrieval documents; when we store documents in token-level embedding, the accuracy will be high. Additionally, we do not need any external server to host FAISS, allowing us to integrate it with our backend framework, making it a very flexible framework.
Amandeep Pawar - PeerSpot reviewer
Senior Engineer at Airy Software Technologies Private Limited
Careful data design has delivered consistent transactions and supports reliable microservices
MySQL is a reliable and mature relational database, but there are a few areas where it could be improved. One area is horizontal scalability. While MySQL supports scaling for applications, handling write-heavy workloads often requires additional solutions such as sharding, which adds complexity. Another area where it could improve is in native support for advanced analytics and large-scale distributed processing, which may require specialized databases. Changing the database schema on large tables can also be challenging and may require careful planning to minimize downtime. Performance tuning is powerful, but identifying and optimizing slow queries often requires manual analysis and experience. Having more built-in performance insights and automated optimization recommendations would be helpful for administrators. In terms of documentation and security, I think MySQL could be improved in those areas. While the official documentation is comprehensive, it can sometimes be difficult for beginners to navigate, especially for advanced topics such as application partitioning and query optimization. More practical examples and architecture-focused guides would be beneficial. On the integration side, MySQL already works well with frameworks such as Spring Boot and Hibernate, but enhancing support for modern cloud-native deployments, Kubernetes, and automated observability would simplify operations. MySQL is a mature and dependable database, and I hope to see improvements primarily around administration, better operational tooling, and a smoother developer experience rather than fundamental database capabilities.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The product has better performance and stability compared to one of its competitors."
"I used Faiss as a basic database."
"The most valuable feature is the ease of use."
"This product is good as it is a graphical interface; it's easy to do all MySQL database administration very easily."
"One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab."
"Amazon has come up with Aurora, a MySQL hybrid that has helped us get up to speed without actually thinking about MySQL underlying optimizations."
"Fully scalable and stable SQL-based RDBMS, with a straightforward and easy setup."
"I would recommend this product if someone is new to the IT world."
"The open source product is good; if you want advanced features go for the enterprise edition."
"MySQL is easy to integrate. It works with just about every language."
 

Cons

"It would be beneficial if I could set a parameter and see different query mechanisms being run."
"One of the drawbacks of Faiss is that it works only in-memory. If it could provide separate persistent storage without relying on in-memory, it would reduce the overhead."
"It could be more accessible for handling larger data sets."
"It has a lot of options to interact with. Sometimes it is hard to find the appropriate options quickly."
"In the next release, I would like to see the scalability features improved to allow you to configure it and reduce the complexity with the configuration, making it easier for the end-user to scale. Make it as simple as it can be."
"The simplicity of the product lets people abuse it."
"We did encounter some scalability issues as it has limited clustering support, it requires scaling up rather than out to some degree."
"According to our experience, it's not really an enterprise tool that you can easily expand and scale the way you can with, for example, Oracle."
"The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions."
"The technical support should be more knowledgeable and available worldwide."
"MySQL has some unique exchange problems when it comes to migration projects."
 

Pricing and Cost Advice

"Faiss is an open-source solution."
"It is an open-source tool."
"MySQL Enterprise Support is not cheap, though might still be cheaper than Oracle or SQL Server. They may not have local support depending on where you’re based, but there are many smaller agencies out there that will readily provide support. You’ll need to spend some time looking around."
"It is an open source platform."
"I am not paying, but I am not sure about the exact licensing requirements."
"​Enterprise editions and support are definitely needed for the heavy users who need direct support. ​"
"We pay a yearly subscription fee."
"We've never bought a commercial license. We just use the open-source community edition."
"I would rate the solution’s pricing a six out of ten. The solution is not cheap but it’s a fair value. The pricing depends on the use cases of our customers. Some of our customers use the community edition which is license free and a good fit for their use cases. However, we encourage our bigger customers to sign up because of the scalability issues. The paid versions get direct technical support from Oracle."
"It is free. It is an open-source platform."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
913,683 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Manufacturing Company
10%
Comms Service Provider
10%
Computer Software Company
8%
Outsourcing Company
11%
Manufacturing Company
8%
Financial Services Firm
8%
Construction Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business75
Midsize Enterprise34
Large Enterprise64
 

Questions from the Community

What is your experience regarding pricing and costs for Faiss?
I did not purchase FAISS through the AWS Marketplace because FAISS is an open-source product. My experience with pricing, setup cost, and licensing is straightforward, as there is no cost for acqui...
What needs improvement with Faiss?
I currently do not think there is anything to be improved based on our experience, as Faiss performs as we expected for our workflow. I would like to see improvement in the fact that FAISS currentl...
What is your primary use case for Faiss?
My main use case for FAISS is in a retrieval-augmented generation project using it with OpenAI, where we use FAISS to store our embeddings created by the Colbert model and for retrieval as well. In...
Why are MySQL connections encrypted and what is the biggest benefit of this?
MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If you move information over a network without encryption, you are endangering it, m...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid versions. So back in my day, it was all free, it was open-source and the best among sim...
What is one thing you would improve with MySQL?
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos onli...
 

Comparisons

 

Overview

 

Sample Customers

1. Facebook 2. Airbnb 3. Pinterest 4. Twitter 5. Microsoft 6. Uber 7. LinkedIn 8. Netflix 9. Spotify 10. Adobe 11. eBay 12. Dropbox 13. Yelp 14. Salesforce 15. IBM 16. Intel 17. Nvidia 18. Qualcomm 19. Samsung 20. Sony 21. Tencent 22. Alibaba 23. Baidu 24. JD.com 25. Rakuten 26. Zillow 27. Booking.com 28. Expedia 29. TripAdvisor 30. Rakuten 31. Rakuten Viber 32. Rakuten Ichiba
Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Find out what your peers are saying about Faiss vs. MySQL and other solutions. Updated: September 2026.
913,683 professionals have used our research since 2012.