how to disable InnoDB and MyISAM on ndb cluster
Hi All, I'm using mysql-cluster-gpl-6.2.15 for create DB cluster in our server machines, currently I'm using 2 data nodes, 2 management nodes and two mysqld server nodes which were combine with same data directory in SAN. SAN for the collect binary logs only. What need to know are, 1. Is it possible to disable InnoDB and MyISAM engines while using the ndb cluster in mysqld servers, if it is yes, can you tell me the way of doing it? 2. Is there having any disterbance for ndb cluster by disabling the InnoDB and MyISAM? Thanks and Regards, -- Nipuna Perera නිපුණ පෙරේරා http://nipunaperera.blogspot.com
Combining NDB, MySAM and InnoDB
Hi All,I need tom combine two ndb cluster db and one MyISAM db and one InnoDB db together using one mysqld demon, can anyone help me to build the my.cnf? ndb cluster details ndb node1 = 172.18.18.1 ndb node2 = 172.18.18.2 ndb_mdmd1 = 172.18.18.3 ndb_mdmd2 = 172.18.18.4 myisam db details mysqld = 172.18.18.5 innodb db details mysqld = 172.18.18.5 myisam and innodb data should be in one location in one server. (ex /usr/local/data) Kind Regards, -- Nipuna Perera නිපුණ පෙරේරා http://nipunaperera.blogspot.com
Fwd: our server got stuck
localhost kernel: Unable to handle kernel NULL pointer
dereference at RIP:
Aug 24 17:41:35 localhost kernel:
a0156b10{:jbd:journal_commit_transaction+1136}
Aug 24 17:41:35 localhost kernel: PML4 2cd832067 PGD 1f1216067 PMD 0
Aug 24 17:41:35 localhost kernel: Oops: [1] SMP
Aug 24 17:41:35 localhost kernel: CPU 3
Aug 24 17:41:35 localhost kernel: Modules linked in: parport_pc lp parport
autofs4 i2c_dev i2c_core sunrpc ds yenta_socket pcmcia_core dm_mod button
battery ac md5 ipv6 joydev ohci_hcd ehci_hcd tg3 floppy ext3 jbd mppVhba(U)
qla2400(U) qla2xxx(U) qla2xxx_conf(U) aacraid(U) mppUpper(U) sg sd_mod
scsi_mod
Aug 24 17:41:35 localhost kernel: Pid: 2312, comm: kjournald Tainted: GF
2.6.9-5.ELsmp
Aug 24 17:41:35 localhost kernel: RIP: 0010:[a0156b10]
a0156b10{:jbd:journal_commit_transaction+1136}
Aug 24 17:41:35 localhost kernel: RSP: 0018:01032ae27bb8 EFLAGS:
00010206
Aug 24 17:41:35 localhost kernel: RAX: 0102691752f0 RBX:
0101018779d0 RCX: c100
Aug 24 17:41:35 localhost kernel: RDX: c100 RSI:
0101018779d0 RDI: 0100cfe3dc00
Aug 24 17:41:35 localhost kernel: RBP: R08:
01032ae26000 R09: 0046
Aug 24 17:41:36 localhost kernel: R10: 0060 R11:
01032ae27b68 R12:
Aug 24 17:41:36 localhost kernel: R13: 01032d39e4c0 R14:
0100cfe3dc00 R15: 0100cfe3dce0
Aug 24 17:41:36 localhost kernel: FS: 002a95564b00()
GS:804bf480() knlGS:
Aug 24 17:41:36 localhost kernel: CS: 0010 DS: ES: CR0:
8005003b
Aug 24 17:41:36 localhost kernel: CR2: CR3:
37e24000 CR4: 06e0
Aug 24 17:41:36 localhost kernel: Process kjournald (pid: 2312, threadinfo
01032ae26000, task 01032a8727f0)
Aug 24 17:41:36 localhost kernel: Stack:
Aug 24 17:41:36 localhost kernel:0101a5e340e0 1988
01032a8727f0
Aug 24 17:41:36 localhost kernel:80132ff0 01032ae27c30
Aug 24 17:41:36 localhost kernel: Call
Trace:80132ff0{autoremove_wake_function+0}
80132ff0{autoremove_wake_function+0}
Aug 24 17:41:36 localhost kernel:
a0159898{:jbd:kjournald+250}
80132ff0{autoremove_wake_function+0}
Aug 24 17:41:36 localhost kernel:
80132ff0{autoremove_wake_function+0}
a0159798{:jbd:commit_timeout+0}
Aug 24 17:41:36 localhost kernel:80110c23{child_rip+8}
a015979e{:jbd:kjournald+0}
Aug 24 17:41:36 localhost kernel:80110c1b{child_rip+0}
Aug 24 17:41:36 localhost kernel:
Aug 24 17:41:36 localhost kernel: Code: 49 8b 1c 24 f0 ff 43 18 8b 03 a8 04
74 52 49 8d be 5c 01 00
Aug 24 17:41:36 localhost kernel: RIP
a0156b10{:jbd:journal_commit_transaction+1136} RSP
01032ae27bb8
Aug 24 17:41:36 localhost kernel: CR2:
Aug 24 17:41:36 localhost kernel: 0Assertion failure in
journal_dirty_data() at fs/jbd/transaction.c:986: jh-b_transaction ==
journal-j_committing_transaction
Aug 24 17:41:36 localhost kernel: --- [cut here ] - [please
bite here ] -
Aug 24 17:41:36 localhost kernel: Kernel BUG at transaction:986
Aug 24 17:41:36 localhost kernel: invalid operand: [2] SMP
Aug 24 17:41:36 localhost kernel: CPU 2
Aug 24 17:41:36 localhost kernel: Modules linked in: parport_pc lp parport
autofs4 i2c_dev i2c_core sunrpc ds yenta_socket pcmcia_core dm_mod button
battery ac md5 ipv6 joydev ohci_hcd ehci_hcd tg3 floppy ext3 jbd mppVhba(U)
qla2400(U) qla2xxx(U) qla2xxx_conf(U) aacraid(U) mppUpper(U) sg sd_mod
scsi_mod
Aug 24 17:41:36 localhost kernel: Pid: 5442, comm: pdflush Tainted: GF
2.6.9-5.ELsmp
Aug 24 17:41:36 localhost kernel: RIP: 0010:[a0155d4c]
a0155d4c{:jbd:journal_dirty_data+167}
Aug 24 17:41:36 localhost kernel: RSP: :010014805ab8 EFLAGS:
00010212
Aug 24 17:41:36 localhost kernel: RAX: 0083 RBX:
010089c7f870 RCX: 0246
Aug 24 17:41:36 localhost kernel: RDX: 6ac2 RSI:
0246 RDI: 803c7520
--
Nipuna Perera
http://nipunaperera.blogspot.com
