#     options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2    # Number of replicas
#DataMemory=80M    # How much memory to allocate for data storage
DataMemory=1800M    # How much memory to allocate for data storage
#IndexMemory=18M   # How much memory to allocate for index storage
IndexMemory=400M   # How much memory to allocate for index storage

# recommandation ESA contre erreur 708 sur import bdd cercle valrhona
# Default value 1000
# ESA 2008/04/03 MaxNoOfAttributes=2000
#MaxNoOfAttributes=5000
MaxNoOfAttributes=10000

# recommandation ESA contre erreur 904 sur import bdd cercle valrhona
# Default value 128
#MaxNoOfOrderedIndexes=512
MaxNoOfOrderedIndexes=1024

# recommandation ESA contre erreur 1297 sur import caprice des dieux
# Default value 20
TimeBetweenLocalCheckpoints=15

# recommandation ESA contre erreur 1297 sur import caprice des dieux
# Default value 8
NoOfFragmentLogFiles=32

# ESA 2008/04/03 - MaxNoOfTables
# Default value 128
#MaxNoOfTables=512
MaxNoOfTables=1024

# ESA le 2008-04-23 - MaxNoOfConcurrentOperations
MaxNoOfConcurrentOperations=100000

# TCP/IP options:
#[TCP DEFAULT]
#portnumber=2202   # This the default; however, you can use any
                  # port that is free for all the hosts in cluster
                  # Note: It is recommended beginning with MySQL 5.0 that
                  # you do not specify the portnumber at all and simply allow
                  # the default value to be used instead

# Management process options:
[NDB_MGMD]
hostname=ha-sba-prd01           # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster  # Directory for MGM node logfiles
Id=1
ArbitrationRank=1

[NDB_MGMD]
hostname=ha-sba-prd02           # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster  # Directory for MGM node logfiles
Id=2
ArbitrationRank=2

# Options for data node "A":
[NDBD]
                                # (one [NDBD] section per data node)
hostname=ha-sba-prd01           # Hostname or IP address
datadir=/data/mysql/5.0.41/data # Directory for this data node's datafiles
Id=3

# Options for data node "B":
[NDBD]
hostname=ha-sba-prd02           # Hostname or IP address
datadir=/data/mysql/5.0.41/data # Directory for this data node's datafiles
Id=4

# SQL node options:
[MYSQLD]
hostname=ha-sba-prd01           # Hostname or IP address
                                # (additional mysqld connections can be
                                # specified for this node for various
                                # purposes such as running ndb_restore)
Id=5
[MYSQLD]
hostname=ha-sba-prd02           # Hostname or IP address
Id=6