Configuration:
4 x ndb 7.0.6 servers (2GB RAM, 2xXeon 2.4GHz)
1 x api (2GB RAM, 2xXeon 2.4GHz)
=================================================
Trying to create table in database:
CREATE TABLE account (
i_account int(10) unsigned NOT NULL auto_increment,
id varchar(32) NOT NULL,
`password` varchar(16) character set utf8 collate utf8_bin default NULL,
balance decimal(15,5) NOT NULL default '0.00000',
opening_balance decimal(15,5) NOT NULL default '0.00000',
issue_date date NOT NULL default '0000-00-00',
zero_balance_date date default NULL,
i_customer int(10) unsigned NOT NULL default '0',
billing_model tinyint(2) NOT NULL default '0',
activation_date date NOT NULL default '0000-00-00',
expiration_date date default NULL,
i_product int(10) unsigned NOT NULL default '0',
blocked char(1) NOT NULL default 'N',
last_usage datetime default NULL,
i_batch int(10) unsigned NOT NULL default '0',
i_env tinyint(1) unsigned NOT NULL default '1',
first_usage date default NULL,
life_time smallint(4) unsigned default NULL,
redirect_number varchar(32) default NULL,
control_number int(10) unsigned NOT NULL default '0',
i_time_zone int(10) unsigned NOT NULL default '1',
credit_limit decimal(15,5) default NULL,
iso_4217 char(3) character set utf8 NOT NULL,
non_call_related_charges decimal(15,5) default NULL,
refunds decimal(15,5) default NULL,
login varchar(64) character set utf8 default NULL,
email varchar(128) character set utf8 default NULL,
password_timestamp datetime default NULL,
i_acl int(10) unsigned NOT NULL default '155',
i_subscriber int(10) unsigned default NULL,
i_lang char(5) default NULL,
ua_profile_id int(10) unsigned default NULL,
follow_me_enabled char(1) NOT NULL default 'N',
timer datetime default NULL,
ecommerce_enabled char(1) default 'N',
out_date_format varchar(16) character set utf8 NOT NULL,
out_time_format varchar(16) character set utf8 NOT NULL,
out_date_time_format varchar(32) character set utf8 NOT NULL,
in_date_format varchar(16) character set utf8 NOT NULL,
in_time_format varchar(16) character set utf8 NOT NULL,
i_vd_plan int(10) unsigned default NULL,
last_recharge datetime default NULL,
i_moh int(10) unsigned default NULL,
service_flags varchar(32) character set utf8 NOT NULL,
PRIMARY KEY (i_account),
UNIQUE KEY Accounts_id (id,i_env),
UNIQUE KEY Accounts_login (login),
KEY Account_customer (i_customer),
KEY Accounts_product (i_product),
KEY AccountsProfileId (ua_profile_id),
KEY Accounts_iso_4217 (iso_4217),
KEY env_id (i_env,id),
KEY AccountFirstUsage (first_usage),
KEY i_vd_plan (i_vd_plan),
KEY Accounts_i_acl (i_acl)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
Getting - (errno: 783)
===
Trying to add like this:
CREATE TABLE account (
i_account int(10) unsigned NOT NULL auto_increment,
id varchar(32) NOT NULL,
`password` varchar(16) character set utf8 collate utf8_bin default NULL,
balance decimal(15,5) NOT NULL default '0.00000',
opening_balance decimal(15,5) NOT NULL default '0.00000',
issue_date date NOT NULL default '0000-00-00',
zero_balance_date date default NULL,
i_customer int(10) unsigned NOT NULL default '0',
billing_model tinyint(2) NOT NULL default '0',
activation_date date NOT NULL default '0000-00-00',
expiration_date date default NULL,
i_product int(10) unsigned NOT NULL default '0',
blocked char(1) NOT NULL default 'N',
last_usage datetime default NULL,
i_batch int(10) unsigned NOT NULL default '0',
i_env tinyint(1) unsigned NOT NULL default '1',
first_usage date default NULL,
life_time smallint(4) unsigned default NULL,
redirect_number varchar(32) default NULL,
control_number int(10) unsigned NOT NULL default '0',
i_time_zone int(10) unsigned NOT NULL default '1',
credit_limit decimal(15,5) default NULL,
iso_4217 char(3) character set utf8 NOT NULL,
non_call_related_charges decimal(15,5) default NULL,
refunds decimal(15,5) default NULL,
login varchar(64) character set utf8 default NULL,
email varchar(128) character set utf8 default NULL,
password_timestamp datetime default NULL,
i_acl int(10) unsigned NOT NULL default '155',
i_subscriber int(10) unsigned default NULL,
i_lang char(5) default NULL,
ua_profile_id int(10) unsigned default NULL,
follow_me_enabled char(1) NOT NULL default 'N',
timer datetime default NULL,
ecommerce_enabled char(1) default 'N',
out_date_format varchar(16) character set utf8 NOT NULL,
out_time_format varchar(16) character set utf8 NOT NULL,
out_date_time_format varchar(32) character set utf8 NOT NULL,
in_date_format varchar(16) character set utf8 NOT NULL,
in_time_format varchar(16) character set utf8 NOT NULL,
i_vd_plan int(10) unsigned default NULL,
last_recharge datetime default NULL,
i_moh int(10) unsigned default NULL,
service_flags varchar(32) character set utf8 NOT NULL,
PRIMARY KEY (i_account)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
Table created without problem. Trying to add more keys:
CREATE INDEX Account_customer ON account (i_customer);
And server crashed.
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2013 (HY000): Lost connection to MySQL server during query
