阿里云的 RDS 如何自建从节点??

[lianxiaoyi]

想做灾备，例如某天阿里云主数据库机房网络瘫痪。那么程序无法访问数据库(老板担心。我只能照办)。所以就想把数据备份一份到外地去....于是就想在外地做一个从节点。。。。。可惜阿里云这混蛋在 mysqldump 的时候不让导出 db 表

Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events.

mysqldump: Couldn't execute 'show create table db': SHOW command denied to user 'aaaa'@'139.196.xxx.xxx' for table 'db' (1142)

然后在建立从节点时

ERROR 1794 (HY000): Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log.

有没有这样做过的朋友？？？

好吧。。。我已经解决了。。。只需要在 my.cnf 里面加个配置

[houzhimeng]

加个什么配置？话说阿里的 rds 不是自己有灾备么。

[lianxiaoyi]

@houzhimeng 贵啊！