hiroi10

▼NDB config.ini
[tcp default]
SendBufferMemory=64M
ReceiveBufferMemory=64M

[ndb_mgmd default]
DataDir=/var/lib/mysql-cluster

[ndb_mgmd]
HostName=10.3.65.1

hiroi10

###########################################
# RUN CentOS7.3, Kernel 4.10.9-1(elrepo)
###########################################

# uname -r
4.10.9-1.el7.elrepo.x86_64
#
# lscpu
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit

hiroi10

5.0はこける

事前に
mysql> create table t1( id int not null auto_increment, hoge varchar(255) not null, primary key(id) )engine=innodb;

Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (null, "foo");
Query OK, 1 row affected (0.00 sec)

hiroi10

スレッドA
mysql> create table t1( id int not null auto_increment, hoge varchar(255) not null, primary key(id) )engine=innodb;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t1 values (null, "foo");
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1;
+----+------+
| id | hoge |

hiroi10

o MASTER
mysql> DROP TABLE IF EXISTS `xatest`;
  `id` int(11) NOT NULL AUTO_INCREMENT,
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE `xatest` (
    ->   `id` int(11) NOT NULL AUTO_INCREMENT,
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=InnoDB;
XA START 'xatest';

hiroi10

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

max_connections = 2048
character-set-server = utf8
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
sort_buffer_size = 64K
net_buffer_length = 8K