Where do i change the my.cnf on mysql cluster I'm trying to change the max_allowed_packet setting on mysql cluster (version 7.4.8) - i have 5 nodes


2x SQL Node
2x Data Node
1x Managament Node


I have updated the my.cnf on all of the servers ->

[mysqld]
datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
user=mysql
ndbcluster
ndb-connectstring=manager-db
default_storage_engine=ndbcluster
port=3306
max_allowed_packet=1073741824


But show variables like '%max_allowed_packet%' still returns 524288000 

What am i doing wrong ? where do i need to set it ?
The answer is indeed the SQL Nodes - the key factor is related to the client - the setting doesn't apply until you close the client session and reopen it