Home » Open Source » MySQL » MySQL Cluster 5.4 (GPL Edition, MySQL Proxy 7.3)
MySQL Cluster 5.4 [message #606644] Mon, 27 January 2014 19:44 Go to next message
mzainal
Messages: 50
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.
Re: MySQL Cluster 5.4 [message #606645 is a reply to message #606644] Mon, 27 January 2014 19:57 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=mysql+explain+plan
Re: MySQL Cluster 5.4 [message #611782 is a reply to message #606645] Tue, 08 April 2014 20:59 Go to previous messageGo to next message
mzainal
Messages: 50
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?
Re: MySQL Cluster 5.4 [message #621853 is a reply to message #611782] Tue, 19 August 2014 02:52 Go to previous messageGo to next message
mzainal
Messages: 50
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.
Re: MySQL Cluster 5.4 [message #622087 is a reply to message #621853] Wed, 20 August 2014 23:02 Go to previous message
mzainal
Messages: 50
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
Previous Topic: MySQL Procedure not getting compiled
Next Topic: News -> OEM support for MySQL now available
Goto Forum:
  


Current Time: Thu Nov 27 01:17:45 CST 2014

Total time taken to generate the page: 0.10161 seconds