请稍等 ...
×

采纳答案成功!

向帮助你的同学说点啥吧!感谢那些助人为乐的人

6-4这个是pxc 集群的演示还是replication集群的演示联机冷还原

6-4这个是pxc 集群的演示还是replication集群的演示联机冷还原

正在回答 回答被采纳积分+3

2回答

提问者 慕九州1544730 2019-03-28 09:57:52

2019-03-28T01:56:27.379099Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2019-03-28T01:56:27.380914Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.25-28-57-log) starting as process 15316 ...

2019-03-28T01:56:27.383831Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=localhost-bin' to avoid this problem.

2019-03-28T01:56:27.383990Z 0 [Note] WSREP: Setting wsrep_ready to false

2019-03-28T01:56:27.384002Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.

2019-03-28T01:56:27.384005Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera3/libgalera_smm.so'

2019-03-28T01:56:27.387253Z 0 [Note] WSREP: wsrep_load(): Galera 3.35(rddf9876) by Codership Oy <info@codership.com> loaded successfully.

2019-03-28T01:56:27.387323Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.

2019-03-28T01:56:27.387803Z 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'

2019-03-28T01:56:27.387816Z 0 [Warning] WSREP: No persistent state found. Bootstraping with default state

2019-03-28T01:56:27.387881Z 0 [ERROR] WSREP: Could not open state file for writing: '/var/lib/mysql//grastate.dat'. Check permissions and/or disk space.: 13 (Permission denied)

         at galera/src/saved_state.cpp:SavedState():57

2019-03-28T01:56:27.387889Z 0 [ERROR] WSREP: Failed to initialize wsrep_provider (reason:7). Must shutdown

2019-03-28T01:56:27.387894Z 0 [ERROR] Aborting


2019-03-28T01:56:27.387902Z 0 [Note] Binlog end

2019-03-28T01:56:27.387976Z 0 [Note] /usr/sbin/mysqld: Shutdown complete


0 回复 有任何疑惑可以回复我~
  • 你做什么操作了?
    回复 有任何疑惑可以回复我~ 2019-03-28 09:59:37
  • 提问者 慕九州1544730 回复 神思者 #2
    sudo service mysql start ,其它2个节点是正常启动的,ls -al /var/lib/mysql//grastate.dat 
    -rwxrwxrwx. 1 mysql mysql 117 Mar 27 12:24 /var/lib/mysql//grastate.dat
    回复 有任何疑惑可以回复我~ 2019-03-28 10:03:02
  • 神思者 回复 提问者 慕九州1544730 #3
    你是主节点启动错误?
    回复 有任何疑惑可以回复我~ 2019-03-28 10:08:27
神思者 2019-03-28 09:40:16

课程里演示的是pxc的备份和还原,当然了不管什么MySQL都可以这样备份和还原

0 回复 有任何疑惑可以回复我~
  • 提问者 慕九州1544730 #1
    好的,请看我贴出的报错,不知道什么原因无法启动数据库了
    回复 有任何疑惑可以回复我~ 2019-03-28 09:58:44
问题已解决,确定采纳
还有疑问,暂不采纳
意见反馈 帮助中心 APP下载
官方微信