MYSQL CLUSTER questions

最新推荐文章于 2022-10-07 14:55:58 发布
最新推荐文章于 2022-10-07 14:55:58 发布
阅读量3.7k 收藏
点赞数
分类专栏： mysql cluster
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/eason_oracle/article/details/51500141
版权

  0、    failed to allocate nodeid for API ,returned error:'no free node id found for API'

 mysqld starting as service can't register at MGM server (connection established), but the same mysqld starting manually (mysqld_safe) connecting succesfully.
 
=============================================================================
【1】查看表空间数据文件大小
-- =============================================================================         
mysql> SELECT TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE";
+-----------------+------------+----------------+----------------+----------------+
| TABLESPACE_NAME | FILE_NAME  | TOTAL_MB       | FREE_MB        | EXTRA          |
+-----------------+------------+----------------+----------------+----------------+
| ts_1            | data_2.dat | 10240.00000000 | 10146.00000000 | CLUSTER_NODE=4 |
| ts_1            | data_2.dat | 10240.00000000 | 10146.00000000 | CLUSTER_NODE=5 |
| ts_1            | data_2.dat | 10240.00000000 | 10146.00000000 | CLUSTER_NODE=6 |
| ts_1            | data_2.dat | 10240.00000000 | 10162.00000000 | CLUSTER_NODE=7 |
| ts_1            | data_1.dat |   512.00000000 |    19.00000000 | CLUSTER_NODE=4 |
| ts_1            | data_1.dat |   512.00000000 |    19.00000000 | CLUSTER_NODE=5 |
| ts_1            | data_1.dat |   512.00000000 |    16.00000000 | CLUSTER_NODE=6 |
| ts_1            | data_1.dat |   512.00000000 |     0.00000000 | CLUSTER_NODE=7 |
+-----------------+------------+----------------+----------------+----------------+         

 
 
-- ============================
【2】：建库报错
mysql> CREATE DATABASE zhang;
Query OK, 1 row affected, 2 warnings (0.01 sec)
mysql> 
mysql> 
mysql> 
mysql> show warnings;
+---------+------+----------------------------------------------------------------------------------+
| Level   | Code | Message                                                                          |
+---------+------+----------------------------------------------------------------------------------+
| Warning | 1296 | Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock  |
| Warning | 1296 | Got error 4009 'Cluster Failure' from Could not log query '%s' on other mysqld's |
+---------+------+----------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
【ok】安全模式启动
/usr/local/mysql/bin/mysqld_safe &
-- ==============================
【3】ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
-- ==============================
mysql> use bg;
Database changed
mysql> 
mysql> 
mysql> show create table bgt1;
ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> show create table bgt1;
ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
mysql> 
mysql> 
mysql> create table bgt2(id int,name varchar(20))engine=ndb;
ERROR 1005 (HY000): Can't create table 'bg.bgt2' (errno: 157)
【ok】之后关闭sql节点，重新启动，搞定了！
[root@banggo data]# /etc/rc.d/init.d/mysqld stop
Shutting down MySQL....                                    [确定]
[root@banggo data]# /etc/rc.d/init.d/mysqld start
Starting MySQL...                                          [确定]
[root@banggo data]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.19-ndb-7.2.4-gpl MySQL Cluster Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use bg;
Database changed
mysql> show tables;
+--------------+
| Tables_in_bg |
+--------------+
| bgt1         |
+--------------+
1 row in set (0.03 sec)
mysql> desc bgt1;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | NO   | PRI | 0       |       |
| name  | varchar(20) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)
-- =============================================================================
【4】ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
-- =============================================================================
2012-07-18 09:58:15 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:16 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:16 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:17 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:17 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:18 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:18 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:19 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:19 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'
2012-07-18 09:58:20 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'
【ok】：在config.ini里面加空的sql节点，以便自动扩展s
[API]
[API]

 
 
-- =============================================================================
【5】数据节点报错
-- =============================================================================
2012-07-18 23:34:48 [ndbd] INFO     -- Start initiated (mysql-5.5.19 ndb-7.2.4)
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
Adding 7164Mb to ZONE_LO (32896,229247)
Adding 4301Mb to ZONE_LO (262145,137607)
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
WOPool::init(61, 9)
RWPool::init(22, 14)
2012-07-18 23:35:00 [ndbd] INFO     -- timerHandlingLab now: 12658118985 sent: 12658118306 diff: 679
2012-07-18 23:36:09 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Allocating memory elapsed=60029
2012-07-18 23:36:09 [ndbd] INFO     -- Watchdog: User time: 244  System time: 6855
2012-07-18 23:36:35 [ndbd] ALERT    -- Node 4: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 9.
【ok】：调整参数值
调小参数，内存超过了。


 
 
-- =============================================================================
【6】建立表空间报错
-- =============================================================================
mysql> CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.log' INITIAL_SIZE 1024 M UNDO_BUFFER_SIZE 128 M ENGINE NDBCLUSTER;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'M UNDO_BUFFER_SIZE 128 M ENGINE NDBCLUSTER' at line 1
mysql>
【ok】M不识别
-- CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.log' INITIAL_SIZE 536870912 UNDO_BUFFER_SIZE 67108864 ENGINE NDBCLUSTER;
mysql> CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.log' INITIAL_SIZE 536870912 UNDO_BUFFER_SIZE 67108864 ENGINE NDBCLUSTER;
Query OK, 0 rows affected (27.95 sec)
-- CREATE TABLESPACE ts_1  ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 536870912 ENGINE NDBCLUSTER;
mysql> CREATE TABLESPACE ts_1  ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 536870912 ENGINE NDBCLUSTER;
Query OK, 0 rows affected (28.79 sec)
# 创建使用磁盘存储的表：
CREATE TABLE `bgtdisk` (    
  `Name` varchar(50) NOT NULL,
  `ProviderName` varchar(200) NOT NULL,
  PRIMARY KEY (`Name`)
) tablespace ts_1 storage disk ENGINE=ndbcluster DEFAULT CHARSET=utf8;


 
 
-- =============================================================================
【7】配置报错
-- =============================================================================
Caused by error 2353: 'Insufficent nodes for system restart(Restart error). Temporary error, restart node'.
【error】：没有解决，后来重新部署了cluster。


 
 
-- =============================================================================
【8】ERROR 1528 (HY000): Failed to create LOGFILE GROUP
-- =============================================================================
mysql> CREATE LOGFILE GROUP lg_02 ADD UNDOFILE 'undo_02.log' INITIAL_SIZE 5368709120         UNDO_BUFFER_SIZE 67108864       ENGINE NDBCLUSTER;
ERROR 1528 (HY000): Failed to create LOGFILE GROUP
mysql> 
mysql> 
mysql> 
mysql> show errors;
+-------+------+--------------------------------+
| Level | Code | Message                        |
+-------+------+--------------------------------+
| Error | 1528 | Failed to create LOGFILE GROUP |
+-------+------+--------------------------------+
1 row in set (0.00 sec)
mysql>
解决办法：
原来现在的MYSQL只支持创建一个LOGFILE GROUP文件。
只有删掉原来的才可以创建新的。
-- =============================================================================
【9】ERROR 1114 (HY000): The table 'UserMvpbak' is full
-- =============================================================================
mysql> insert into UserMvpbak select * from UserMvp limit 800000,200000;
ERROR 1114 (HY000): The table 'UserMvpbak' is full
mysql> 
alter tablespace ts_1
         add datafile 'data_3.dat'
         initial_size 21474836480
           engine ndb;
                   
【ok】原有的数据文件空间满了，需要增加新的数据文件                   
mysql> alter tablespace ts_1
    ->      add datafile 'data_2.dat'
    ->      initial_size 10737418240
    ->      engine ndb;
Query OK, 0 rows affected (1 min 54.30 sec)
mysql>

 
 
-- =============================================================================
【10】ERROR 1114 (HY000): The table 'UserMvpbak' is full
-- =============================================================================
mysql> insert into um select * from um limit 940000,3000000;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
mysql>
[ok] 减少录入的数据量
mysql> replace into um select * from um limit 940000,800000;       
Query OK, 755105 rows affected (2 min 44.54 sec)
Records: 755105  Duplicates: 0  Warnings: 0


 
 
-- =============================================================================
【11】Node 4: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 11.
-- =============================================================================
2012-08-15 12:35:38 [ndbd] INFO     -- Start initiated (mysql-5.5.25 ndb-7.2.7)
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
2012-08-15 12:35:45 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Polling for Receive elapsed=159
2012-08-15 12:35:45 [ndbd] INFO     -- timerHandlingLab now: 498814955 sent: 498814782 diff: 173
2012-08-15 12:35:45 [ndbd] INFO     -- Watchdog: User time: 28  System time: 497
2012-08-15 12:35:47 [ndbd] INFO     -- timerHandlingLab now: 498816970 sent: 498816803 diff: 167
2012-08-15 12:35:49 [ndbd] INFO     -- Watchdog: User time: 39  System time: 741
2012-08-15 12:35:49 [ndbd] WARNING  -- Watchdog: Warning overslept 262 ms, expected 100 ms.
2012-08-15 12:35:49 [ndbd] INFO     -- timerHandlingLab now: 498818963 sent: 498818779 diff: 184
Adding 5201Mb to ZONE_LO (1152,166408)
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer
2012-08-15 12:35:56 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Allocating memory elapsed=6002
2012-08-15 12:35:56 [ndbd] INFO     -- Watchdog: User time: 61  System time: 1179
2012-08-15 12:36:02 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Allocating memory elapsed=12006
2012-08-15 12:36:02 [ndbd] INFO     -- Watchdog: User time: 64  System time: 1763
2012-08-15 12:36:08 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Allocating memory elapsed=18030
2012-08-15 12:36:08 [ndbd] INFO     -- Watchdog: User time: 70  System time: 1957
2012-08-15 12:36:12 [ndbd] ALERT    -- Node 4: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 11.
[ok] 注释如下三个参数，启动ok！
#MaxNoOfConcurrentTransactions=100000
#MaxNoOfConcurrentOperations=10000000
#MaxNoOfLocalOperations=11000000


 
 
-- =============================================================================
【12】启动管理节点报错
-- =============================================================================
[root@banggo mysql-cluster]# ndb_mgmd -f /usr/local/mysql/cluster-conf/config.ini --reload
MySQL Cluster Management Server mysql-5.5.25 ndb-7.2.7
2012-08-15 21:36:54 [MgmtSrvr] ERROR    -- at line 18: Illegal value 128 for parameter LockPagesInMainMemory.
Legal values are between 0 and 2
2012-08-15 21:36:54 [MgmtSrvr] ERROR    -- at line 18: Could not parse name-value pair in config file.
2012-08-15 21:36:54 [MgmtSrvr] ERROR    -- Could not load configuration from '/usr/local/mysql/cluster-conf/config.ini'
2012-08-15 21:36:54 [MgmtSrvr] ERROR    -- Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid=<nodeid> on command line
[root@banggo mysql-cluster]# 
[root@banggo mysql-cluster]#
【ok】LockPagesInMainMemory值设置太大了！改成默认的1，搞定。
-- =============================================================================
【13】 1528 错误
-- =============================================================================
mysql> CREATE LOGFILE GROUP lg_1
    -> ADD UNDOFILE 'undo_2.log'
    -> INITIAL_SIZE 634217728 
    ->  UNDO_BUFFER_SIZE 134217728      
    -> ENGINE NDBCLUSTER;
ERROR 1528 (HY000): Failed to create LOGFILE GROUP
mysql> 
mysql> 
mysql> 
mysql> show warnings;
+---------+------+---------------------------------------------------+
| Level   | Code | Message                                           |
+---------+------+---------------------------------------------------+
| Warning | 1296 | Got error 1504 'Out of logbuffer memory' from NDB |
| Error   | 1528 | Failed to create LOGFILE GROUP                    |
+---------+------+---------------------------------------------------+
2 rows in set (0.00 sec)
【ok】
# UNDO_BUFFER_SIZE不能超过config.ini的配置RedoBuffer=32M大小，否则创建失败，
CREATE LOGFILE GROUP lg_1
ADD UNDOFILE 'undo_2.log'
INITIAL_SIZE 634217728     
  UNDO_BUFFER_SIZE 33554432      
ENGINE NDBCLUSTER;
CREATE TABLESPACE ts_1
       ADD DATAFILE 'data_10.dat'
       USE LOGFILE GROUP lg_1
       INITIAL_SIZE 32212254720
    EXTENT_SIZE 33554432
       ENGINE NDBCLUSTER;
    执行结束之后，需要去数据目录/var/lib/mysql-cluster/里面看看undo文件和data文件，如果存在，那么就证明建立成功了。
可以建立2个表空间
CREATE TABLESPACE ts_2
       ADD DATAFILE 'data_20.dat'
       USE LOGFILE GROUP lg_1
       INITIAL_SIZE 10737418240
    EXTENT_SIZE 33554432
       ENGINE NDBCLUSTER;
    
    create table bguserdb.mcbak like test.mc;
    alter table bguserdb.mcbak tablespace ts_1 storage disk ENGINE=ndbcluster DEFAULT CHARSET=utf8;
    insert into bguserdb.mcbak select * from test.mc;
    
    CREATE TABLESPACE ts_1
       ADD DATAFILE 'data_10.dat‘ USE LOGFILE GROUP lg_1 INITIAL_SIZE 32212254720
    EXTENT_SIZE 33554432 ENGINE NDBCLUSTER;



-- =============================================================================
【14】 1528 错误
-- =============================================================================         
mysql> insert into bguserdb.mv select * from test.mc;
ERROR 1297 (HY000): Got temporary error 410 'REDO log files overloaded (decrease TimeBetweenLocalCheckpoints or increase NoOfFragmentLogFiles)' from NDBCLUSTER
mysql>
【】增加2个参数的值
TimeBetweenLocalCheckpoints=30
NoOfFragmentLogFiles=128

 
 


-- =============================================================================
【15】 1005 错误
-- =============================================================================
mysql>    create table bu.mcbak like test.mc;
Query OK, 0 rows affected (0.07 sec)
mysql>    alter table bu.mcbak tablespace ts_1 storage disk ENGINE=ndbcluster DEFAULT CHARSET=utf8;
ERROR 1005 (HY000): Can't create table 'bu.#sql-14ab_2' (errno: 140)
mysql> show errors;
+-------+------+--------------------------------------------------------+
| Level | Code | Message                                                |
+-------+------+--------------------------------------------------------+
| Error | 1005 | Can't create table 'bu.#sql-14ab_2' (errno: 140) |
+-------+------+--------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show warnings;
+---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1296 | Got error 755 'Invalid tablespace' from NDB            |
| Error   | 1005 | Can't create table 'bu.#sql-14ab_2' (errno: 140) |
+---------+------+--------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> 
【ok】重新建立表空间：
CREATE LOGFILE GROUP lg_1
ADD UNDOFILE 'undo_1.log'
INITIAL_SIZE 334217728     
  UNDO_BUFFER_SIZE 33554432      
ENGINE NDBCLUSTER;
CREATE TABLESPACE ts_1 ADD DATAFILE 'data_11.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 4294967296 EXTENT_SIZE 33554432 ENGINE NDBCLUSTER;
alter table bu.mc tablespace ts_1 storage disk ENGINE=ndbcluster DEFAULT CHARSET=utf8;
insert into bu.mc select * from test.mc limit 0,100000;

 
 
-- =============================================================================
【16】 1005 错误
-- =============================================================================
mysql> alter table oib TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=utf8;
ERROR 1005 (HY000): Can't create table 'os.#sql-711_3' (errno: 851)
mysql> show warnings;
+---------+------+---------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                             |
+---------+------+---------------------------------------------------------------------------------------------------------------------+
| Warning | 1296 | Got error 851 'Maximum 8052 bytes of FIXED columns supported, use varchar or COLUMN_FORMAT DYNMIC instead' from NDB |
| Error   | 1005 | Can't create table 'os.#sql-711_3' (errno: 851)                                                               |
+---------+------+---------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
[暂无解决方案]google之，无果！


 
 
-- =============================================================================
【17】 1297 错误
-- =============================================================================
mysql> alter table ebelkTABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=utf8 comment '';
ERROR 1297 (HY000): Got temporary error 1501 'Out of undo space' from NDBCLUSTER
mysql> 
mysql> show errors;
+-------+------+--------------------------------------------------------------+
| Level | Code | Message                                                      |
+-------+------+--------------------------------------------------------------+
| Error | 1297 | Got temporary error 1501 'Out of undo space' from NDBCLUSTER |
| Error | 1296 | Got error 4350 'Transaction already aborted' from NDBCLUSTER |
| Error | 1180 | Got error 4350 during COMMIT                                 |
+-------+------+--------------------------------------------------------------+
3 rows in set (0.00 sec)
mysql>
[ok]增加数据文件，数据文件空间可能不够了。 
alter tablespace ts_1 add datafile 'data_12.dat' initial_size 10737418240 engine NDBCLUSTER;
alter tablespace ts_1 add datafile 'data_13.dat' initial_size 10737418240 engine NDBCLUSTER;
alter tablespace ts_1 add datafile 'data_14.dat' initial_size 10737418240 engine NDBCLUSTER;
-- =============================================================================
【18】 1297 错误
-- =============================================================================
mysql> alter table aau TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=utf8 comment '';
ERROR 1297 (HY000): Got temporary error 1501 'Out of undo space' from NDBCLUSTER
mysql> show warnings;
+---------+------+--------------------------------------------------------------+
| Level   | Code | Message                                                      |
+---------+------+--------------------------------------------------------------+
| Warning | 1297 | Got temporary error 1501 'Out of undo space' from NDB        |
| Error   | 1297 | Got temporary error 1501 'Out of undo space' from NDBCLUSTER |
| Warning | 1296 | Got error 4350 'Transaction already aborted' from NDB        |
| Error   | 1296 | Got error 4350 'Transaction already aborted' from NDBCLUSTER |
| Error   | 1180 | Got error 4350 during COMMIT                                 |
+---------+------+--------------------------------------------------------------+
5 rows in set (0.00 sec)
mysql>
【】暂时未解决。


 
 
-- =============================================================================
【19】 1297 错误
-- =============================================================================
ndb_mgm> Node 7: Forced node shutdown completed. Occured during startphase 4. Caused by error 2303: 'System error, node killed during node restart by other node(Internal error, programming error or missing error message, please report a bug). Temporary error,
restart node'.
Node 4: Forced node shutdown completed. Occured during startphase 4. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'.
Node 5: Forced node shutdown completed. Occured during startphase 4. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'.
Node 6: Forced node shutdown completed. Occured during startphase 4. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'.
【ok】baidu，google之，没有得到相似的案列，看到一个emporary error, restart node的提示，不得已 restart node 节点
重新在4个data 节点，执行 ndbd --initial，等待2分钟，搞定！oh，my god，不知道其中的原理，但是data node确实是起来了。
ndb_mgm> Node 4: Started (version 7.2.7)
Node 7: Started (version 7.2.7)
Node 5: Started (version 7.2.7)
Node 6: Started (version 7.2.7)
启动sql节点，执行检查数据 
mysql> SELECT TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE";
Empty set (0.00 sec)
mysql>
oh my god，原来的数据文件都无法显示了。简直是暴力破解啊，^_^！



-- =============================================================================
【20】 Out of undo space
-- =============================================================================
mysql> insert into mc select * from zzbak_mc limit 0,10000;
ERROR 1297 (HY000): Got temporary error 1501 'Out of undo space' from NDBCLUSTER
mysql> show warnings;
+---------+------+--------------------------------------------------------------+
| Level   | Code | Message                                                      |
+---------+------+--------------------------------------------------------------+
| Warning | 1297 | Got temporary error 1501 'Out of undo space' from NDB        |
| Error   | 1297 | Got temporary error 1501 'Out of undo space' from NDBCLUSTER |
+---------+------+--------------------------------------------------------------+
2 rows in set (0.00 sec)
【ok】参考网址
http://forums.mysql.com/read.php?25,413217,413217
I add another undo log file ,it's ok now ,but counld some one tell me how can I know the usage of my undo log file ? SELECT FILE_NAME FROM information_schema.files WHERE FILE_TYPE='UNDO LOG'\G;
执行：alter LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_21.log' UNDO_BUFFER_SIZE 33554432 ENGINE NDBCLUSTER;
mysql> alter LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_21.log' ENGINE NDBCLUSTER; 
Query OK, 0 rows affected (4.33 sec)
-- 查看系统已有的undo文件
mysql> SELECT FILE_NAME FROM information_schema.files WHERE FILE_TYPE='UNDO LOG';
+-------------+
| FILE_NAME   |
+-------------+
| undo_2.log  |
| undo_2.log  |
| undo_2.log  |
| undo_2.log  |
| undo_21.log |
| undo_21.log |
| undo_21.log |
| undo_21.log |
| NULL        |
+-------------+
9 rows in set (0.05 sec)
mysql>SELECT FILE_NAME FROM information_schema.files WHERE FILE_TYPE='UNDO LOG'\G;
搞定，OK。
mysql> insert into mc select * from zzbak_mc limit 0,10000;
Query OK, 10000 rows affected (0.80 sec)
Records: 10000  Duplicates: 0  Warnings: 0
mysql> insert into mc select * from zzbak_mc limit 810000,890000;
Query OK, 890000 rows affected (2 min 10.10 sec)
Records: 890000  Duplicates: 0  Warnings: 0
-- =============================================================================
【21】 后台日志报错，批量insert数据
-- =============================================================================
2012-08-16 22:38:05 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 38285338476552 nodes: 0000000000000000000000000000000000000000000000000000000000016400
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/8) ref: 0fa2000e from: 0fa2000e
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/8) ref: 0fa2000a from: 0fa2000a
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/8) ref: 0fa20010 from: 0fa20010
2012-08-16 22:38:05 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 38285338476553 nodes: 0000000000000000000000000000000000000000000000000000000000016400
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/9) ref: 0fa2000e from: 0fa2000e
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/9) ref: 0fa2000a from: 0fa2000a
2012-08-16 22:38:05 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 38289633443840 nodes: 0000000000000000000000000000000000000000000000000000000000016400
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/9) ref: 0fa20010 from: 0fa20010
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8915/0) ref: 0fa2000a from: 0fa2000a
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8915/0) ref: 0fa20010 from: 0fa20010
2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8915/0) ref: 0fa2000e from: 0fa2000e
【ok】减少insert的数量，一次批量从100W减少到50W，ok，不会报异常信息了。


 
 
-- =============================================================================
【22】 第4个data节点意外down了
-- =============================================================================
ndb_mgm> Node 7: Forced node shutdown completed. Caused by error 2305: 'Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s)(Arbitration error). Temporary error, restart node'.
ndb_mgm>
【ok】执行ndbd 重新启动起来



-- =============================================================================
【22】 管理台老是报警，诡异
-- =============================================================================
一次性批量录入了100W数据，管理节点控制台报如下信息：
ndb_mgm> Node 7: Data usage increased to 80%(64016 32K pages of total 80000)
Node 4: Data usage increased to 80%(64007 32K pages of total 80000)
Node 5: Data usage increased to 80%(64014 32K pages of total 80000)
Node 6: Data usage increased to 80%(64001 32K pages of total 80000)
Node 4: Data usage increased to 90%(72005 32K pages of total 80000)
Node 5: Data usage increased to 90%(72014 32K pages of total 80000)
Node 7: Data usage increased to 90%(72010 32K pages of total 80000)
Node 6: Data usage increased to 90%(72009 32K pages of total 80000)
Node 6: Data usage decreased to 89%(71772 32K pages of total 80000)
Node 7: Data usage decreased to 89%(71271 32K pages of total 80000)
Node 4: Data usage decreased to 89%(71215 32K pages of total 80000)
Node 5: Data usage decreased to 88%(70607 32K pages of total 80000)
Node 5: Data usage decreased to 79%(63850 32K pages of total 80000)
Node 7: Data usage decreased to 79%(63673 32K pages of total 80000)
Node 4: Data usage decreased to 78%(62947 32K pages of total 80000)
Node 6: Data usage decreased to 78%(62932 32K pages of total 80000)
没有搞懂这是什么情况呢？


 
 
-- =============================================================================
【23】 ERROR 1297 (HY000)
-- =============================================================================
mysql> insert into bu.up_2012 select * from test.up_2012 limit 1200000,10000; 
ERROR 1297 (HY000): Got temporary error 899 'Rowid already allocated' from NDBCLUSTER
mysql>
【ok】网上都说需要调大datamemory，但是我的是磁盘表，应该不是这个原因，不得已只有restart cluster了试试了，还好搞定了！
mysql>  replace into bu.up_2012 select * from test.up_2012 limit 1200000,300000;
Query OK, 300000 rows affected (59.97 sec)
Records: 300000  Duplicates: 0  Warnings: 0
赞叹一句，网上关于STORAGE DISK ndbcluster table的测试的资料好少啊！


 
 
-- =============================================================================
【25】 修改了config.in之后，data node 启动，需要 ndbd --initial重新加载之后，
原有的*.dat数据文件无效，启动不起来，sql节点启动之后，show tables; 原来的磁盘表都不见了，诡异啊！
-- =============================================================================
1 修改config.inf
2 ndb_mgmd -f /usr/local/mysql/cluster-conf/config.ini --reload 重新加载管理节点
3 ndbd --initial  重新启动data node
4 service mysqld start
5 use bu; show tables; 原来的表不存在了，丢失了。
看的文档是说，原有的数据文件加载不了，我想问的是：
1 如果我已经导入了很多数据，这个时候发现自己的配置参数不合理，我要修改配置参数，能不能在线修改并生效。
2 如果1失败，我能否在重新启动管理节点之后，启动data node的时候，能加载进去以前的数据呢？


 
 
想修改配置，需要以--initial或reload的方式重新启动ndb_mgmd
ndbd一般不需要--initial启动，只有当有文件文件损坏的时候，它会删除所有本地文件，然后从其他节点的member取回数据，如果其它都是down的，那数据库就丢失了
mysql cluster很不稳定，启动很可能失败，修改场数据前最好备份一下，实在不行全部--initial启动，恢复数据


 
 

  
  

   
   



  
  

 
 

 
 

  
  

   
   




  
  

 
 
再请教一个小问题：
ERROR 1297 (HY000): Got temporary error 410 'REDO log files overloaded (decrease TimeBetweenLocalCheckpoints or increase NoOfFragmentLogFiles)' from NDBCLUSTER
cluster里面的 redo log file 在哪里可以看到，我知道undo log文件，但是不知道redo log file 在哪里呢？

 
 

  
  

   
   
-- =============================================================================

  
  

 
 
【26】 批量insert 500W记录报错
-- =============================================================================
2012-08-26 00:37:25 [ndbd] INFO     -- findNeighbours from: 4861 old (left: 5 right: 5) new (65535 65535)
2012-08-26 00:37:25 [ndbd] INFO     -- Watchdog: User time: 976564  System time: 1189718
2012-08-26 00:37:25 [ndbd] WARNING  -- Watchdog: Warning overslept 410 ms, expected 100 ms.
2012-08-26 00:37:25 [ndbd] INFO     -- Arbitrator decided to shutdown this node
2012-08-26 00:37:25 [ndbd] INFO     -- QMGR (Line: 5975) 0x00000002
2012-08-26 00:37:25 [ndbd] INFO     -- Error handler shutting down system
2012-08-26 00:37:25 [ndbd] INFO     -- Error handler shutdown completed - exiting
2012-08-26 00:37:38 [ndbd] ALERT    -- Node 6: Forced node shutdown completed. Caused by error 2305: 'Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s)(Arbitration error).
Temporary error, restart node'.
[ok]：google之，大部分的方案都是 restart data node。
而且一般的ndbd启动无效，需要ndbd --initial 重新加载才行。


 
 
-- =============================================================================
【27】 导入数据错误；
-- =============================================================================
CREATE TABLE `pp_order` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` varchar(255) DEFAULT NULL,
  `itemCode` varchar(255) DEFAULT NULL,
  `itemLocalCode` varchar(255) DEFAULT NULL,
  `stockLocalCode` varchar(255) DEFAULT NULL,
  `itemDetailLink` varchar(255) DEFAULT NULL,
  `itemName` varchar(255) DEFAULT NULL,
  `itemPicLink` varchar(255) DEFAULT NULL,
  `itemRetailPrice` varchar(255) DEFAULT NULL,
  `itemDealPrice` varchar(255) DEFAULT NULL,
  `stockAttr` varchar(255) DEFAULT NULL,
  `itemAdjustPrice` varchar(255) DEFAULT NULL,
  `itemDealCount` varchar(255) DEFAULT NULL,
  `itemDealState` varchar(255) DEFAULT NULL,
  `account` varchar(255) DEFAULT NULL,
  `itemFlag` varchar(255) DEFAULT NULL,
  `refundState` varchar(255) DEFAULT NULL,
  `refundStateDesc` varchar(255) DEFAULT NULL,
  `availableAction` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `dealCode` (`pid`(30))
) TABLESPACE ts_1 STORAGE DISK  DEFAULT CHARSET=utf8;
mysql> ERROR 1005 (HY000): Can't create table 'bgapidb.pp_order' (errno: 851)
mysql> show warnings;
+---------+------+---------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                             |
+---------+------+---------------------------------------------------------------------------------------------------------------------+
| Warning | 1296 | Got error 851 'Maximum 8052 bytes of FIXED columns supported, use varchar or COLUMN_FORMAT DYNMIC instead' from NDB |
| Error   | 1005 | Can't create table 'bgapidb.pp_order' (errno: 851)                                                                  |
+---------+------+---------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
【OK】，磁盘表的varchar列的占据的总长度不能多于8052B，所以合理设计字段的长度。搞定
mysql>  CREATE TABLE bgapidb.`pp_order` (
    ->   `Id` INT(11) NOT NULL AUTO_INCREMENT,
    ->   `pid` VARCHAR(30) DEFAULT NULL,
    ->   `itemCode` VARCHAR(40) DEFAULT NULL,
    ->   `itemLocalCode` VARCHAR(16) DEFAULT NULL,
    ->   `stockLocalCode` VARCHAR(16) DEFAULT NULL,
    ->   `itemDetailLink` VARCHAR(100) DEFAULT NULL,
    ->   `itemName` VARCHAR(100) DEFAULT NULL,
    ->   `itemPicLink` VARCHAR(100) DEFAULT NULL,
    ->   `itemRetailPrice` VARCHAR(10) DEFAULT NULL,
    ->   `itemDealPrice` VARCHAR(10) DEFAULT NULL,
    ->   `stockAttr` VARCHAR(120) DEFAULT NULL,
    ->   `itemAdjustPrice` VARCHAR(10) DEFAULT NULL,
    ->   `itemDealCount` VARCHAR(10) DEFAULT NULL,
    ->   `itemDealState` VARCHAR(30) DEFAULT NULL,
    ->   `account` VARCHAR(10) DEFAULT NULL,
    ->   `itemFlag` VARCHAR(10) DEFAULT NULL,
    ->   `refundState` VARCHAR(32) DEFAULT NULL,
    ->   `refundStateDesc` VARCHAR(32) DEFAULT NULL,
    ->   `availableAction` VARCHAR(60) DEFAULT NULL,
    ->   PRIMARY KEY (`Id`),
    ->   KEY `dealCode` (`pid`(30))
    -> ) TABLESPACE ts_1 STORAGE DISK  ENGINE=NDBCLUSTER DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.24 sec)

 
 
-- =============================================================================
【30】 Got temporary error 899 'Rowid already allocated' from NDB
-- =============================================================================
CREATE TABLE lg.`nc_xxx` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `ymd` datetime NOT NULL COMMENT '请求日期',
  `request_url` varchar(200) NOT NULL COMMENT '请求URL',
  `post_data` text COMMENT '提交参数',
  `return_data` text COMMENT '返回参数',
  `ipaddr` varchar(20) DEFAULT NULL COMMENT '发送请求IP',
  `status` char(3) DEFAULT NULL COMMENT '请求状态:0  已请求 返回异常     1  已请求 正常返回  ',
  `created` datetime DEFAULT NULL COMMENT '该记录创建时间',
  `modified` datetime DEFAULT NULL COMMENT '记录修改时间',
  `api_type` varchar(55) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster  DEFAULT CHARSET=utf8;
ERROR 1005 (HY000): Can't create table 'lg.xxxx' (errno: 708)
mysql> show warnings;
+---------+------+------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                  |
+---------+------+------------------------------------------------------------------------------------------+
| Warning | 1296 | Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDB |
| Error   | 1005 | Can't create table 'bglogdb.nc_api_logs' (errno: 708)                                    |
+---------+------+------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
【ok】


再补充一个问题，就是当在集群中插入亿万条数据，会因为file system is full 的错误，也就是 Caused by error 2810 'The file system is full',导致一个节点forced to shutdown，其他节点 not connected，error 2305.

主要原因是安装虚拟机的时候，对磁盘安装没有分区，文件系统，默认为50G，所以当大规模的数据插进来后，会占用磁盘空间，导致以上错误。此时需要我们为根目录扩容。df -h命令查看磁盘分区的大小，然后把home目录的减少，root目录增加即可。具体步骤参照 CENTOS 7 减少HOME分区，扩大ROOT分区的博客


 

 

河南骏
关注
专栏目录
mysql error4009_mysql-cluster的问题棘手
weixin_35545563的博客
01-21 1247
mysql-cluster的问题棘手发布时间:2009-12-01 15:56:29来源:红联作者:skyuun我搭建了一个3台服务器所做的mysql-cluster集群集群版本是7.09G 操作系统是RH-5.2-32使用的是RPM包安装方式服务器为 MySQL-Cluster-gpl-server和MySQL-Cluster-gpl-client和MySQL-Cluster-gpl-stora...
mysql cluster 测试_mysql cluster 在测试的时候出的问题　希望大家帮助
weixin_33604071的博客
01-27 575
你的位置:问答吧-> 服务器-> 问题详情mysql cluster 在测试的时候出的问题　希望大家帮助ERROR 1296 (HY000): Got error 4009 'Cluster Failure' from NDBCLUSTER这个是错误信息．我已经都安装成功了．我是采用两个机器安装的．[root@...
mysql-cluster常见错误解决方法
xiefangjian的专栏
03-26 2109
mysql cluster 生产环境常见错误解决方法 在生产环境中由于默认的配置，部分参数非常小，需要进行调整，否在创建较大表时，会产生异常，如 Table storage engine for ‘xxxx’ doesn’t have this option The table ‘xxx’ is full 主要修改参数如下： mysql cluster 生产环境常用参数配置 ...
MySQL Cluster(MySQL集群)数据节点无法启动
白鱼赤乌的博客
09-18 1049
由于应用系统服务器的服务器数据节点断开了很长一段时间，大概2个月左右。当这台应用应用服务器因原因重启之后，整个集群的所有数据节点就无法正常启动，表现为可以启动成功，但是几分钟之后数据节点就会自动停止，日志文件中会有报错文件。项目中搭建了mysql集群，用到了4台服务器，一台管理节点服务器+数据节点服务器，3台数据节点服务器+SQL节点服务器，其中一台数据节点+SQL节点服务器也作为应用服务器部署了系统。这种原因是因为其中一个数据节点断开时间过长，无法同步数据，导致不同的数据节点之后数据存在较大的差量。
MySQL 5.7 Reference Manual Including MySQL Cluster NDB 7.5
01-05
It documents MySQL 5.7 through 5.7.13, as well as MySQL Cluster releases based on version 7.5 of NDB through 5.7.11-ndb-7.5.2, respectively. MySQL 5.7 features. This manual describes features that ...
MySQL 8.0 Reference Manual 官方参考手册（HTML版）
08-17
Abstract ...If you have any questions about the features included in your edition of MySQL 8.0, refer to your MySQL 8.0 license agreement or contact your Oracle sales representative.
MySQL8.0文档（英文）
05-11
MySQL Cluster is currently not supported in MySQL 8.0. For information about MySQL Cluster, please see MySQL NDB Cluster 7.5 and NDB Cluster 7.6. MySQL 8.0 features. This manual describes features ...
MySQL 8.0 Reference Manual.pdf.7z
09-01
Abstract This is the MySQL™ ... If you have any questions about the features included in your edition of MySQL 8.0, refer to your MySQL 8.0 license agreement or contact your Oracle sales representative.
MySQL 8.0 Reference Manual 官方参考手册
08-17
Abstract ...If you have any questions about the features included in your edition of MySQL 8.0, refer to your MySQL 8.0 license agreement or contact your Oracle sales representative.
【异常类】Create table/tablespace ‘表‘failed,as disk is full
最新发布
pingzhuyan的博客
10-07 4211
清理到98% 后测试 一切正常。
MySQL Cluster Error msg
Zhong Weicheng Study Notes
11-21 4130
config.ini [tcp default] SendBufferMemory=16M 在向操作系统发出调用请求之前，TCP传输器采用缓冲来保存所有的消息。当该缓冲达到64KB时，将发送其内容，执行完一组消息循环后，也将发送这些内容。发送缓冲的默认值是256KB ReceiveBufferMemory=16M 指定了从TCP/IP套接字
Mysql ndb-cluster centos6.4 简单配置
conglushao5834的博客
05-12 197
NDBCluster Server1 192.168.0.30 ...
pxs MySQL_Mysql高开用集群搭建
weixin_31993699的博客
02-04 235
环境rhel6.5x64192.168.20.11 mysql11192.168.29.12 mysql12拓扑环境关闭iptables关闭selinuxyum -y install ncurses-devel gcc gcc-c++make autoconf automake zlib zlib-devel openssl openssl-devel pcre-devel开始安装配置my...
LeetCode 538 把二叉树转为累加数 HERODING的LeetCode之路
HERODING23的博客
09-21 553
给定一个二叉搜索树（Binary Search Tree），把它转换成为累加树（Greater Tree)，使得每个节点的值是原来的节点值加上所有大于它的节点值之和。 例如： 输入: 原始二叉搜索树: 5 / \ 2 13 输出: 转换为累加树: 18 / \ 20 13 解题思路： 刚开始写这道题感觉挺疑惑的，这挺复杂的题目为什么会是简单题呢，后来仔细观察题目终于发现了，这是个二叉搜索树，那么就代表着对于每个节点，其右子节点的值一定比当前节点值大，左子节点的值一定比当前值小，那么左
mysql cluster部分报错解决办法
weixin_30265103的博客
04-26 378
This is a test setup and to get maximum RAM availability, I have 3 data nodes and 1 Management node with replication factor of 1. The solutions provided are the ones which helped me. 1....
msyql集群搭建
梅初初的博客
02-23 780
演示系统为Macos，VMware Fusion12.2.1 1、名称概念 MySQL集群： 应用程序层：负责与MySQL服务器通信的各种应用程序。 Mysql服务器层：处理SQL命令，并与NDB存储引擎通信和Mysql服务器。 NDB集群组件层：NDB集群组件有时也称数据节点，负责处理查询，然后将结果返回给mysql服务器。 1) SQL节点（SQL node - 下图对应为 mysqld）：分布式数据库。包括自身数据和查询中心结点数据 2) 数据节点（Data node - ndb
Mysql集群 遇到的问题
li200918003的博客
11-12 778
1. Forced node shutdown completed. Occured during startphase 0. Initiated by signal 9 解决方法：检查config.ini配置文件中的配置项是否正确。我当时是DataMemory配置过大。导致这个错误出现 2. failed: 1297 Got temporary error 410 'REDO log fil
MySQL Cluster快速搭建指南
"MySQL Cluster开发环境快速部署" MySQL Cluster是一种高可用、高性能的分布式数据库系统，由MySQL AB公司（现为Oracle公司的一部分）开发。它通过数据分片（sharding）和复制来提供冗余和故障切换能力，适用于需要...
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

河南骏

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值