hellocphp

第 109 位会员

会员
个人信息
  • 加入于 2015-11-09 17:59:06
  • 最后登录时间 1年前
个人成就
  • 发表文章次数 1
  • 发布评论次数 10
  • 个人主页浏览次数 4
为什么主从复制,从数据库一会能复制一会就不行了 帮忙看一下有什么问题 从的配置1年前

160422 2:37:50 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release. 160422 2:37:50 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48) starting as process 45293 ... 160422 2:37:50 InnoDB: The InnoDB memory heap is disabled 160422 2:37:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins 160422 2:37:50 InnoDB: Compressed tables use zlib 1.2.3 160422 2:37:50 InnoDB: Initializing buffer pool, size = 128.0M 160422 2:37:50 InnoDB: Completed initialization of buffer pool 160422 2:37:50 InnoDB: highest supported file format is Barracuda. 160422 2:37:50 InnoDB: Waiting for the background threads to start 160422 2:37:51 InnoDB: 5.5.48 started; log sequence number 1595695 160422 2:37:51 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 160422 2:37:51 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 160422 2:37:51 [Note] Server socket created on IP: '0.0.0.0'. 160422 2:37:51 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mysql-relay-bin' to avoid this problem. 160422 2:37:51 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004' at position 107, relay log './mysql-relay-bin.000013' position: 253 160422 2:37:51 [Note] Event Scheduler: Loaded 0 events 160422 2:37:51 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.48' socket: '/tmp/mysql.sock' port: 3306 Source distribution 160422 2:37:51 [Note] Slave I/O thread: connected to master 'repl@139.217.16.221:3306',replication started in log 'mysql-bin.000004' at position 107 160422 2:38:57 [Warning] IP address '202.85.220.34' could not be resolved: Temporary failure in name resolution

怎么操作

为什么主从复制,从数据库一会能复制一会就不行了 帮忙看一下有什么问题 从的配置1年前

@ruyi #4楼 好的 谢谢大神 以后能不能录制些视频 这样访问用户也会多

为什么主从复制,从数据库一会能复制一会就不行了 帮忙看一下有什么问题 从的配置1年前

@ruyi #1楼 是刚做 大神 你给我一个mysql5.1的配置吗 用change 也是有问题