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

Faiss vs MySQL comparison

 

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
12th
Average Rating
8.0
Reviews Sentiment
3.3
Number of Reviews
3
Ranking in other categories
Vector Databases (13th)
MySQL
Ranking in Open Source Databases
1st
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
152
Ranking in other categories
Relational Databases Tools (4th)
 

Mindshare comparison

As of June 2026, in the Open Source Databases category, the mindshare of Faiss is 3.3%, down from 3.9% compared to the previous year. The mindshare of MySQL is 11.4%, up from 10.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Open Source Databases Mindshare Distribution
ProductMindshare (%)
MySQL11.4%
Faiss3.3%
Other85.3%
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.
Varuns Ug - PeerSpot reviewer
Senior Software Developer at NIT
Reliable transactions have supported secure payments, refunds, and bookings at high volumes
Regarding MySQL improvements, a pain point is horizontal scalability. MySQL scales very well vertically and can support read replicas, but as a system grows significantly, sharding and distributed data management can become complex compared to databases that are designed to scale horizontally from the beginning. This is one of the areas where I think MySQL should work more. Another area is handling very large analytic workloads. MySQL is excellent for transactional systems, but for large-scale analytics or reporting, specialized analytic databases may sometimes be a better fit. Apart from that, one area is performance troubleshooting. As the database grows, diagnosing things such as slow queries, lock contention, and deadlocks becomes complex.

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."
"I would recommend the solution to those interested in using the free, stable version of the solution which incurs no licensing costs."
"The solution helps us perform with our databases and extract data."
"MySQL is open-source, easy to use, highly scalable, and supported by a huge community and multiple vendors, making it a reliable choice for everything from financial and PCI data to large-scale relational applications."
"Combined with PHPMyAdmin, MySQL is an excellent database solution for small to medium sized businesses or installations."
"It’s been used as the main databases for a lot of the developments we have done."
"The most valuable feature of MySQL is auto-scaling."
"The IO segregation in CGE is valuable."
"MySQL installation is more straightforward and streamlined; it is just a database engine that gives you what you need, and I like it."
 

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."
"MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers."
"It has a lot of options to interact with. Sometimes it is hard to find the appropriate options quickly."
"We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar, which affects database performance."
"Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"Improvements to MySQL depend on the specific use case. For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools."
"I would like to see the automatic backup feature in the solution as well. Data is very important and we need to preserve it in a safe place. It would be good if MySQL can back up the data automatically."
"The analytics features are in need of improvement. They aren't as far along as the capabilities that you have in terms of analytics for SQL Server and Oracle."
 

Pricing and Cost Advice

"Faiss is an open-source solution."
"It is an open-source tool."
"The pricing is not much expensive, it's cheap."
"The tool is open source."
"I rate the solution's pricing as four out of ten, where one is cheap, and ten is expensive. For our basic needs, it's quite affordable. However, the cost increases when we need to scale up or require high availability. Our developer team of about 600 people uses MySQL without much issue. The pricing becomes more of a concern on the business side, as we have more end users and need constant database availability and scaling. In those cases, the solution gets a bit more expensive, even though it provides good value for the business."
"We are using the free community version of the solution."
"MySQL is very cheap. It could be free. It also has a yearly licensing option."
"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 open source. We prefer it for POCs because it saves the license cost."
"The solution’s pricing depends on customer requirements. A license is not required for the community edition."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
900,644 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business74
Midsize Enterprise34
Large Enterprise63
 

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: June 2026.
900,644 professionals have used our research since 2012.