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

来源:6-4 联机冷备份-冷还原

慕九州1544730

2019-03-28

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

写回答

2回答

慕九州1544730

提问者

2019-03-28

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
8
慕九州1544730
回复
神思者
好的,我多尝试一下
2019-03-28
共8条回复

神思者

2019-03-28

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

0
1
慕九州1544730
好的,请看我贴出的报错,不知道什么原因无法启动数据库了
2019-03-28
共1条回复

MySQL数据库集群-PXC方案,解决数据库领域疑难杂症

学习PXC,打造高价值的MySQL集群

511 学习 · 217 问题

查看课程