想做灾备，例如某天阿里云主数据库机房网络瘫痪。那么程序无法访问数据库(老板担心。我只能照办)。所以就想把数据备份一份到外地去....于是就想在外地做一个从节点。。。。。可惜阿里云这混蛋在 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.
有没有这样做过的朋友？？？
Select Language