OraFAQ Forum: MySQL » MySQL Cluster 5.4

Home » Open Source » MySQL » MySQL Cluster 5.4 (GPL Edition, MySQL Proxy 7.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MySQL Cluster 5.4 [message #606644]

Mon, 27 January 2014 19:44

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Hi,

I'm using mysql cluster gpl edition with mysql proxy. The idea is to improve query and performance. Below is my config.ini

[ndb_mgmd default]

[ndb_mgmd]
NodeId=1
HostName=vsvr-console
DataDir=/var/lib/mysql-cluster


[ndbd default]
NoOfReplicas = 2
DataMemory = 4G
IndexMemory = 6G
#LockPagesInMainMemory = 1
MaxNoOfConcurrentOperations = 200000
MaxNoOfTables = 20000
#MaxNoOfOrderedIndexes = 3221225472
MaxNoOfAttributes = 25000
MaxNoOfOrderedIndexes = 25000
MaxNoOfExecutionThreads=8

[ndbd]
NodeId=2
HostName=172.16.0.90
DataDir=/var/lib/mysql-cluster/data1

[ndbd]
NodeId=3
HostName=172.16.0.91
DataDir=/var/lib/mysql-cluster/data1

[mysqld]
NodeId=10
HostName=172.16.1.90

[mysqld]
NodeId=20
HostName=172.16.1.91

Query from application very slow. What should i do? Please advice.

Thanks.

Report message to a moderator

Re: MySQL Cluster 5.4 [message #606645 is a reply to message #606644]

Mon, 27 January 2014 19:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.lmgtfy.com/?q=mysql+explain+plan

Report message to a moderator

Re: MySQL Cluster 5.4 [message #611782 is a reply to message #606645]

Tue, 08 April 2014 20:59

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

On production, it's use Innodb. The idea using cluster is HA. The table structure is same as production but production little bit fast than using cluster. I still don't know what it's wrong. If you said table structure, why production fast than mysql cluster?

Report message to a moderator

Re: MySQL Cluster 5.4 [message #621853 is a reply to message #611782]

Tue, 19 August 2014 02:52

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

I have other isu. Seems connection from application is single only. Why it not same as mysql enterprise?

tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:58010 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:58006 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:57612 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql vsvr-docuflow.int:59247 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:57429 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:57981 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:58009 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:58007 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:57165 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:58011 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:57975 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:57226 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:57983 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:58012 ESTABLISHED
tcp        0      0 svr-crdb1.intrane:mysql svr-crapp1.intran:57368 ESTABLISHED

This is from production. svr-crapp1 is apps server. The svr-crdb1 is mysql ent db server. Hope anyone can explain to me.

Report message to a moderator

Re: MySQL Cluster 5.4 [message #622087 is a reply to message #621853]

Wed, 20 August 2014 23:02

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Base on link, from application part which ip do i need to connect?
http://dev.mysql.com/doc/refman/4.1/en/images/multi-comp-1.png

Report message to a moderator

Previous Topic:	MySQL Procedure not getting compiled
Next Topic:	News -> OEM support for MySQL now available

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 29 22:33:36 CST 2023