从 MySQL 迁移到 MariaDB
我正在将数据库迁移到 MySQL 到 MariaDB。我在 MySQL 中有二进制存储引擎,而 MariaDB 不支持它。
我如何转换它以确保我的表能够正常工作?谢谢
I am migrating my database to MySQL to MariaDB. I have binary storage engine in MySQL and MariaDB does not support it.
How can I convert this to make sure my tables will works? Thank You
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
如果这是一个与 MySQL 一起使用的二进制引擎,并且您有它的源代码,那么您应该能够轻松地将其移植到 MariaDB:
存储引擎的一些功能(例如统计计数)
到处理程序接口,修复起来应该很简单。
弄清楚这一点并不容易。
实际上,人们应该能够在 30 分钟左右的时间内将 MySQL 的存储引擎移植到 MariaDB。
如果没有源代码,则需要向供应商询问支持MySQL的存储引擎。他们应该能够毫不费力地做到这一点(只要它是一个真正的插件存储引擎,而不是对 MySQL/MariaDB 上层代码进行重大更改的东西)。
If this is a binary engine that works with MySQL and you have the source for it, then you should be able to easily port it to MariaDB:
some functionality from the storage engine (like statistic counting)
to the handler interface which should be trivial to fix.
should not be almost trivial to figure out.
In practice one should be able to port a storage engine for MySQL to MariaDB within 30 minutes or so.
If you don't have the source code, you need to ask the vendor for the storage engine to support MySQL. They should be able to do that without much trouble (as long it's a true plugg-in storage engine and not something that makes big changes to the MySQL/MariaDB upper level code).