V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 3190 days ago, the information mentioned may be changed or developed.
因此此前采用的一键环境包，MariaDB 版本 10.1.10
现在要做迁移，想用主从复制的方式迁移数据
请问社区各位大大，MariaDB 版本 10.1.10 ，可以跟 mysql 哪个版本搭建主从？ 兼容性比较好？
 |
1
pqee Aug 10, 2017 via Android
let someone google it for you
|
 |
2
coolwind Aug 10, 2017
建議備份後導入 mysql 吧
從下面信息看，mariadb 的 binlog 看起來不兼容 mysql 的 https://mariadb.com/kb/en/mariadb/setting-up-replication/ Replicating from MySQL master to MariaDB slave Replication from MySQL 5.6 with GTID, binlog_rows_query_log_events and ignorable events works starting from MariaDB 10.0.22 and MariaDB 10.1.8. In this case MariaDB will remove the MySQL GTIDs and other unneeded events and instead adds its own GTIDs. |
 |
3
xiaoyanbot OP @coolwind 备份后的话， 原来的账户信息可以保存吗？
|
 |
4
yylzcom Aug 10, 2017
|
 |
5
sprintfan Aug 10, 2017
建议版本一致，小版本号都要一致，不然你会准备跑路的
|
Select Language