mysql-cluster(6)——配置详解

清疚 2022-05-23 08:10 160阅读 0赞

mysql-cluster系列：

1.  [mysql-cluster(1)——简介][mysql-cluster_1]
2.  [mysql-cluster(2)——部署][mysql-cluster_2]
3.  [mysql-cluster(3)——集群管理和维护][mysql-cluster_3]
4.  [mysql-cluster(4)——创建内存表和磁盘表][mysql-cluster_4]
5.  [mysql-cluster(5)——jdbc][mysql-cluster_5_jdbc]
6.  [mysql-cluster(6)——配置详解][mysql-cluster_6]
7.  [mysql-cluster(7)——基准测试][mysql-cluster_7]
8.  [mysql-cluster(8)——最佳实践][mysql-cluster_8]
9.  [mysql-cluster(9)——NDB和InnoDB区别][mysql-cluster_9_NDB_InnoDB]
10. [mysql-cluster(10)——注意事项][mysql-cluster_10]

--------------------

NDB节点参数列表：[https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-params-ndbd.html][https_dev.mysql.com_doc_refman_5.6_en_mysql-cluster-params-ndbd.html]  
MGM节点参数列表：[https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-params-mgmd.html][https_dev.mysql.com_doc_refman_5.6_en_mysql-cluster-params-mgmd.html]  
SQL节点参数列表：[https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-params-api.html][https_dev.mysql.com_doc_refman_5.6_en_mysql-cluster-params-api.html]

配置示例：

[NDBD DEFAULT]
    NoOfReplicas=2               #每个数据节点的镜像数量，通常最低设置为2，否则就没有意义了，这里是方便后面测试。
    DataMemory=64M               #每个数据节点中给数据分配的内存
    IndexMemory=16M              #每个数据节点中给索引分配的内存
    
    #管理节点
    [NDB_MGMD]
    nodeid=1
    hostname=10.5.11.85          #管理节点ip
    datadir=/opt/mysql/data      #管理节点数据目录,存放相关日志，以及pid文件
    
    #第一个 ndbd 节点:
    [NDBD]
    nodeid=2
    hostname=10.5.11.86         #数据节点ip地址
    datadir=/opt/mysql/data   
    
    # SQL node options:
    [MySQLD]
    nodeid=3
    hostname=10.5.11.87         #SQL节点ip地址
    [MySQLD]             #这里保留了一个空节点。否则停止NDB会报错：No free node id found for ndbd(NDB).

[mysql-cluster_1]: https://blog.csdn.net/weitry/article/details/80579706
[mysql-cluster_2]: https://blog.csdn.net/weitry/article/details/80579769
[mysql-cluster_3]: https://blog.csdn.net/weitry/article/details/80579795
[mysql-cluster_4]: https://blog.csdn.net/weitry/article/details/80579817
[mysql-cluster_5_jdbc]: https://blog.csdn.net/weitry/article/details/80579824
[mysql-cluster_6]: https://blog.csdn.net/weitry/article/details/80579838
[mysql-cluster_7]: https://blog.csdn.net/weitry/article/details/80579897
[mysql-cluster_8]: https://blog.csdn.net/weitry/article/details/80579925
[mysql-cluster_9_NDB_InnoDB]: https://blog.csdn.net/weitry/article/details/80579975
[mysql-cluster_10]: https://blog.csdn.net/weitry/article/details/80579988
[https_dev.mysql.com_doc_refman_5.6_en_mysql-cluster-params-ndbd.html]: https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-params-ndbd.html
[https_dev.mysql.com_doc_refman_5.6_en_mysql-cluster-params-mgmd.html]: https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-params-mgmd.html
[https_dev.mysql.com_doc_refman_5.6_en_mysql-cluster-params-api.html]: https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-params-api.html