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 initial setup is very straightforward. The guidelines are very easy to follow. Maintenance is very easy and requires very little manpower."
"The initial setup was simple."
"The solution is fast."
"The most valuable feature of LocalDBis the connection between the application and DB."
"MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore."
"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."
"The most valuable feature is the ease of use."
"The initial setup is easy."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"The speed is very good."
"Like other databases, it has a rich set of functions, such as stored procedures and its own procedural language, which is akin to Oracle SQL. It also has trigger and cursor commands you would expect with a good database language."
"The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"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 ALM features can be improved, but the database by itself is reliable."
"The internal connection features of LocalDB could improve."
"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 replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"Could use some additional JSON query support in the solution."
"The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform."
"It could be a little bit simpler to use."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"The manuals or documentation could be better."
"The GUI could improve to make MySQL better."
LocalDB is ranked 17th 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, Infobright DB, Oracle Database In-Memory and Tibero, whereas MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and SAP HANA. 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.