release/src/router/mysql/support-files/config.medium.ini.sh

   1 # Copyright (c) 2008 MySQL AB
   2 # Use is subject to license terms.
   3 #
   4 # This program is free software; you can redistribute it and/or modify
   5 # it under the terms of the GNU General Public License as published by
   6 # the Free Software Foundation; version 2 of the License.
   7 #
   8 # This program is distributed in the hope that it will be useful,
   9 # but WITHOUT ANY WARRANTY; without even the implied warranty of
  10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  11 # GNU General Public License for more details.
  12 #
  13 # You should have received a copy of the GNU General Public License
  14 # along with this program; if not, write to the Free Software
  15 # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
  16 #
  17 # MySQL NDB Cluster Medium Sample Configuration File
  18 #
  19 # This files assumes that you are using at least 6
  20 # hosts for running the cluster. Hostnames and paths
  21 # listed below should be changed to match your setup
  22 #
  23
  24 [NDBD DEFAULT]
  25 NoOfReplicas: 2
  26 DataDir: /add/path/here
  27 FileSystemPath: /add/path/here
  28
  29
  30 # Data Memory, Index Memory, and String Memory
  31
  32 DataMemory: 3000M
  33 IndexMemory: 800M
  34 BackupMemory: 64M
  35
  36 # Transaction Parameters
  37
  38 MaxNoOfConcurrentOperations: 100000
  39 MaxNoOfLocalOperations: 100000
  40
  41 # Buffering and Logging
  42
  43 RedoBuffer: 16M
  44
  45 # Logging and Checkpointing
  46
  47 NoOfFragmentLogFiles: 200
  48
  49 # Metadata Objects
  50
  51 MaxNoOfAttributes: 500
  52 MaxNoOfTables: 100
  53
  54 # Scans and Buffering
  55
  56 MaxNoOfConcurrentScans: 100
  57
  58
  59 [MGM DEFAULT]
  60 PortNumber: 1186
  61 DataDir: /add/path/here
  62
  63 #
  64 # Change HOST1 to the name of the NDB_MGMD host
  65 # Change HOST2 to the name of the NDB_MGMD host
  66 # Change HOST3 to the name of the NDBD host
  67 # Change HOST4 to the name of the NDBD host
  68 # Change HOST5 to the name of the NDBD host
  69 # Change HOST6 to the name of the NDBD host
  70 #
  71
  72 [NDB_MGMD]
  73 Id: 1
  74 HostName: HOST1
  75 ArbitrationRank: 1
  76
  77 [NDB_MGMD]
  78 Id: 2
  79 HostName: HOST2
  80 ArbitrationRank: 1
  81
  82 [NDBD]
  83 Id: 3
  84 HostName: HOST3
  85
  86 [NDBD]
  87 Id: 4
  88 HostName: HOST4
  89
  90 [NDBD]
  91 Id: 5
  92 HostName: HOST5
  93
  94 [NDBD]
  95 Id: 6
  96 HostName: HOST6
  97
  98 #
  99 # Note: The following can be MySQLD connections or
 100 #      NDB API application connecting to the cluster
 101 #
 102
 103 [API]
 104 Id: 7
 105 HostName: HOST1
 106 ArbitrationRank: 2
 107
 108 [API]
 109 Id: 8
 110 HostName: HOST2
 111 ArbitrationRank: 2
 112
 113 [API]
 114 Id: 9
 115 HostName: HOST3
 116 ArbitrationRank: 2
 117
 118 [API]
 119 Id: 10
 120 HostName: HOST4
 121
 122 [API]
 123 Id: 11
 124 HostName: HOST5
 125
 126 [API]
 127 Id: 12
 128 HostName: HOST6
 129
 130 [API]
 131 Id: 13
 132
 133 [API]
 134 Id: 14
 135
 136 [API]
 137 Id: 15
 138
 139