问题遇到的现象和发生背景
参考我本人写的https://blog.csdn.net/heming20122012/article/details/131420914博客安装windown的mysql集群时,启动sql节点失败,报错内容如下,然后自动退出了mysqld
D:\mysqlcluster\sqlnode\mysql\bin>mysqld --console
2023-06-29 10:03:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-06-29 10:03:18 7196 [Note] Plugin 'FEDERATED' is disabled.
2023-06-29 10:03:18 7196 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-06-29 10:03:18 7196 [Note] InnoDB: The InnoDB memory heap is disabled
2023-06-29 10:03:18 7196 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-06-29 10:03:18 7196 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-06-29 10:03:18 7196 [Note] InnoDB: Not using CPU crc32 instructions
2023-06-29 10:03:18 7196 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-06-29 10:03:18 7196 [Note] InnoDB: Completed initialization of buffer pool
2023-06-29 10:03:18 7196 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode
2023-06-29 10:03:18 7196 [ERROR] InnoDB: The system tablespace must be writable!
2023-06-29 10:03:18 7196 [ERROR] Plugin 'InnoDB' init function returned error.
2023-06-29 10:03:18 7196 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-06-29 10:03:18 7196 [Note] NDB: Changed global value of binlog_format from STATEMENT to MIXED
2023-06-29 10:03:53 7196 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
2023-06-29 10:03:53 7196 [Note] Starting Cluster Binlog Thread
2023-06-29 10:03:53 7196 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-06-29 10:03:53 7196 [ERROR] Aborting
2023-06-29 10:03:53 7196 [Note] Binlog end
操作环境、软件版本等信息
操作环境window10
软件版本mysql-cluster-gpl-7.3.5-winx64.zip
尝试过的解决方法
1、D盘获取管理员权限
2、删除了所有的临时日志文件,包含sql节点下的data目录下的ib_logfile0、ib_logfile1文件,重新执行了一边,启动sql节点还是失败。
我想要达到的结果
启动sql节点成功,且mysql集群搭建成功