Try our new research platform with insights from 80,000+ expert users

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 (9th)
MySQL
Ranking in Open Source Databases
1st
Average Rating
8.2
Reviews Sentiment
7.1
Number of Reviews
152
Ranking in other categories
Relational Databases Tools (4th)
 

Mindshare comparison

As of March 2026, in the Open Source Databases category, the mindshare of Faiss is 3.8%, down from 5.3% compared to the previous year. The mindshare of MySQL is 10.3%, down from 11.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Open Source Databases Mindshare Distribution
ProductMindshare (%)
MySQL10.3%
Faiss3.8%
Other85.9%
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.
Prabir Kumar Kundu - PeerSpot reviewer
SR AVP–Presales Cloud & Platform Management Services at Path Infotech ltd
Offers robust security and availability with impressive replication capabilities
Regarding their documentation and interface, there is room for improvement. Documentation is definitely required when running multiple databases on a cluster system. The load balancer, MySQL LB, which is used to connect to the application, lacks clear documentation. When there are multiple application servers connecting to the MySQL cluster and going through the MySQL load balancer, the documentation is not user-friendly. It's there, but only technical persons with deep knowledge of the MySQL database can implement it. Most of the community users or ISVs who use MySQL don't have many technical persons or DBA experts, so they face some challenges for the high availability of connecting high available databases from high available applications. That documentation should be simplified.

Quotes from Members

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

Pros

"I used Faiss as a basic database."
"The product has better performance and stability compared to one of its competitors."
"For sure, the solution is very stable."
"This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable."
"I find MySQL's relational data storage format very useful for data management. Our structure is well-defined and easy for end users and business stakeholders to read. I appreciate the tool's simplicity and ability to integrate with our backend tools."
"It is a very stable solution. I deployed the product six years ago, and it still works fine."
"The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it."
"We are completely comfortable with the database’s performance and it is a mature product. My organization was looking for an open-source database for our smaller customers like the community edition. For bigger customers, we can scale into commercial and supported editions."
"MySQL solution is overall stable."
"The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
 

Cons

"It could be more accessible for handling larger data sets."
"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."
"I do not think MySQL's data security features were at an industrial level for my project, so I did not make use of them."
"The full-text search feature must be improved."
"The tool needs to improve table visualization."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"The product is a little bit complex and it is difficult to find sufficient documentation."
"I would like to see more integrations of the solution with other platforms and improve the support on different data types."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."
 

Pricing and Cost Advice

"It is an open-source tool."
"Faiss is an open-source solution."
"I am using the Community Edition, which is available free of charge."
"MySQL is a cheap solution."
"I am not paying, but I am not sure about the exact licensing requirements."
"We're using the open-source version right now, which is free. I do see some value in some of the more enterprise functions. We're using the open-source version right now, and I was interested in the MySQL Enterprise version really for the tools that they provide, but we decided not to make the purchase."
"We pay a yearly subscription fee."
"The solution does not come with a licensing fee."
"There is a license needed for this solution."
"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."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
884,797 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Computer Software Company
13%
Manufacturing Company
10%
Comms Service Provider
8%
Computer Software Company
10%
Financial Services Firm
9%
Manufacturing Company
8%
Comms Service Provider
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business75
Midsize Enterprise33
Large Enterprise61
 

Questions from the Community

What do you like most about Faiss?
I used Faiss as a basic database.
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...
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: March 2026.
884,797 professionals have used our research since 2012.