MySQL和MariaDB数据库有什么区别? [英] What is the difference between MySQL and MariaDB database?

问题描述

我使用XAMPP很久了，对于XAMPP从MySQL切换到MariaDB感到惊讶.

I have been using XAMPP for a long time and was surprised that XAMPP has switched to MariaDB from MySQL.

https://www.apachefriends.org/index.html

此更改对使用MySQL的现有开发人员有何影响?例如，现有的MySQL开发工具是否可以与MariaDB无缝协作?开发人员需要注意的MySQL和MariaDB之间的显着区别是什么?

How will this change impact on existing developers using MySQL? For example, can existing development tools for MySQL work seamlessly with MariaDB? What are notable difference between MySQL and MariaDB that developers need to take note?

由于此数据库更改，我不确定是否建议升级XAMPP版本.我担心数据会从MySQL迁移到MariaDB.

I am not sure if it is advisable to upgrade XAMPP version because of this database change. I am worried of the migration of data from MySQL to MariaDB.

推荐答案

例如，现有的MySQL开发工具是否可以与MariaDB无缝协作?"

"For example, can existing development tools for MySQL work seamlessly with MariaDB?"

MySQL的常见开发工具是MySQL Workbench. MySQL Workbench可能不支持MariaDB.

A common development tool for MySQL is MySQL Workbench. MySQL Workbench may not support MariaDB.

请参阅以下内容: MySQL Workbench打开XAMPP MySQL本地数据库时6.3.5崩溃

此处另外一个: MySQL Workbench不兼容/非标准服务器

话虽如此，MySQL Workbench还有其他选择(例如， HeidiSQL 就是一个很好的选择，与通过XAMPP安装的本地MariaDB一起使用时效果很好.

Having said that, there are other options to MySQL Workbench (a good alternative is HeidiSQL for example, which works great by the way with the local MariaDB install by XAMPP).

但是我相信所有这些都是很小的，在大多数情况下，迁移到MariaDB不会造成任何麻烦，您不会注意到任何区别.很棒的事情是，在线上似乎总会有关于您可能遇到的任何问题的良好信息.我完全不用担心从MySQL到MariaDB的数据迁移".

But all of this is minor I believe, for the most part the move to MariaDB is painless and you won't notice any difference. The great thing is that there always seems to be good information online about anything you might run into anyway. I wouldn't worry much at all about "the migration of data from MySQL to MariaDB."

(好奇user1824987是否采取了行动，如果这样做，是否发现他们受到了影响，则对此感到好奇.)

(Curious if user1824987 made the move and if so if they found any way they were impacted by it.)

这篇关于MySQL和MariaDB数据库有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！