美文网首页
ERROR 3077 (HY000): To have mult

ERROR 3077 (HY000): To have mult

作者: 阿汤哥_8d27 | 来源:发表于2021-06-08 16:20 被阅读0次

    在oracle mysql 5.7.27 社区版搭建多源复制时,出现如下错误:

    mysql> change master to master_host='192.168.56.156',master_user='repl',master_password='oracle',master_port=3306,MASTER_AUTO_POSITION = 1 for channel 'master-15633006';
    ERROR 3077 (HY000): To have multiple channels, repository cannot be of type FILE; Please check the repository configuration and convert them to TABLE.

    【错误原因】:
    需要在从库配置下面两个参数
    master_info_repository =table
    relay_log_info_repository =table

    相关文章

      网友评论

          本文标题:ERROR 3077 (HY000): To have mult

          本文链接:https://www.haomeiwen.com/subject/odmqeltx.html