We performed a comparison between LocalDB and MySQL based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature of LocalDBis the connection between the application and DB."
"The solution is fast."
"The initial setup was simple."
"The initial setup is very straightforward. The guidelines are very easy to follow. Maintenance is very easy and requires very little manpower."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"The speed is very good."
"It is a scalable solution."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"Compared to other databases, MySQL is cheaper and we were using the community edition which was free of cost. ML is fully integrated with the database in HeatWave. It has also many other features. MySQL is a far better solution in terms of pricing."
"It is easy to use."
"While MySQL offers strong basic functionality."
"Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database."
"The initial setup is complex and requires a skilled person."
"The solution needs to create a management tool. Right now, the solution has tools for creating a local installation, but it's too simplistic. We need something that's a bit more complex so that we can extend the tools with our scripts."
"The internal connection features of LocalDB could improve."
"The ALM features can be improved, but the database by itself is reliable."
"The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python."
"The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL."
"Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."
"There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations."
"It requires a training platform."
"MySQL could be improved by adding more automation."
"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."
"Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."
LocalDB is ranked 15th in Relational Databases Tools with 5 reviews while MySQL is ranked 4th in Relational Databases Tools with 142 reviews. LocalDB is rated 9.0, while MySQL is rated 8.2. The top reviewer of LocalDB writes "Good for the development process, generally stable, and easy to set up". On the other hand, the top reviewer of MySQL writes "Good beginner base but it should have better support for backups". LocalDB is most compared with SQL Server, Oracle Database In-Memory, Oracle Database, Infobright DB and Tibero, whereas MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB and Teradata. See our LocalDB vs. MySQL report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.