MySQL Cluster configuration file-4 GB memory for SQL nodes

MySQL Cluster configuration file-SQL node 4G memory # Example MySQL config file for large systems. # This is for a large system with memory = 512 M where the system runs mainly # MySQL. # MySQL programs look for option files in a set of # locations which depend on the deployment platform. # You can copy this option file to one of those # locations. for information about these locations, see :# http://dev.mysql.com/doc/mysql/en/option-files.html## In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the "-- help" option. # The following options will be passed to all MySQL clients [client] # password = your_passwordport = 3307 socket =/tmp/mysql. sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3307 socket =/tmp/mysql. Sockndbclusterndb-connectstring = 10.100.200.36max _ connections = 2000 skip-external-lockingkey_buffer_size = bytes = 1Mtable_open_cache = bytes = 8query_cache_size = 16 M # Try number of CPU's * 2 for Example = 8 # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the "enable-named-pipe" option) will render mysqld useless! # Skip-networking # Replication Master Server (default) # binary logging is required for replicationlog-bin = mysql-bin # binary logging format-mixed recommendedbinlog_format = mixed # required unique id between 1 and 2 ^ 32-1 # defaults to 1 if master -host is not set # but will not function as a master if omittedserver-id = 1 # Replication Slave (comment out master section to use this) # To configure this host as a replication slave, you can choose between # two methods: #1) Use the change master to command (fully described in our manual) -# the syntax is: # change master to MASTER_HOST =