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