[MSSQL] 2 Cluster auf einem Root

    Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

    • [MSSQL] 2 Cluster auf einem Root

      Tach mCore,
      Ich hab mal ne Frage.

      Weis jemand wie man 2 Cluster auf einen Root macht, sprich z.b einen Low Rate Server und einen High Rate Server.
      Ich hab auch schon gegoogelt, jedoch erfolglos.
      Ich hoffe mir kann jemand Helfen dabei, da ich nicht genau weis was ich da machen muss.

      Mfg,

    • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )

    • TwiLight;194627 schrieb:

      Wenn man keine Ahnung hat, Klappe zu.
      Serverindex = Channel, aber nicht Cluster ;)

      Versuch mal, 2 Cluster auf einem Root laufen zu lassen (beim 2. Certifier hörts schon auf, weil sie den gleichen Port verwenden :P)

      EDIT: Kleiner Kommentar hierzu

      Das rotmarkierte sind die Cluster, das blaue die Channels :P

      Um es also richtig zu machen, sollte es in etwa so aussehen:
      (Wir gehen davon aus, dass
      - [COLOR="Red"]192.168.178.22 = Root 1[/COLOR]
      - [COLOR="Lime"]192.168.178.23 = Root 2[/COLOR]
      ist.)

      AccountServer.ini

      Quellcode

      1. AddTail( -1, [COLOR="Red"]1[/COLOR], "CLUSTER 1", "[COLOR="Red"]192.168.178.22[/COLOR]", 0, 1, 0 );
      2. AddTail( [COLOR="Red"]1[/COLOR], 1, "CHANNEL 1-1", "", 0, 1, 1100 );
      3. AddTail( [COLOR="Red"]1[/COLOR], 2, "CHANNEL 1-2", "", 0, 1, 1100 );
      5. AddTail( -1, [COLOR="Lime"]2[/COLOR], "CLUSTER 2", "[COLOR="Lime"]192.168.178.23[/COLOR]", 0, 1, 0 );
      6. AddTail( [COLOR="Lime"]2[/COLOR], 1, "CHANNEL 2-1", "", 0, 1, 1100 );
      7. AddTail( [COLOR="Lime"]2[/COLOR], 2, "CHANNEL 2-2", "", 0, 1, 1100 );
      9. DSN_NAME_LOGIN "login"
      10. DB_ADMIN_ID_LOGIN "account"
      12. DSN_NAME_LOG "log01"
      13. DB_ADMIN_ID_LOG "log01"
      15. DB_PWD_LOGIN ""
      16. DB_PWD_LOG ""
      Alles anzeigen


      Certifier.ini (Cluster 1):

      Quellcode

      1. Account "[COLOR="Red"]192.168.178.22[/COLOR]"
      2. DB_PWD_LOGIN ""


      Certifier.ini (Cluster 2):

      Quellcode

      1. Account "[COLOR="Red"]192.168.178.22[/COLOR]"
      2. DB_PWD_LOGIN ""


      CacheServer.ini (Cluster 1):

      Quellcode

      1. Core "[COLOR="Red"]192.168.178.22[/COLOR]"


      CacheServer.ini (Cluster 2):

      Quellcode

      1. Core "[COLOR="Lime"]192.168.178.23[/COLOR]"


      CoreServer.ini (Cluster 1):

      Quellcode

      1. Sys [COLOR="Red"]1[/COLOR]
      2. Database "[COLOR="Red"]192.168.178.22[/COLOR]"
      4. [COLOR="Red"]0101[/COLOR]
      5. {
      6. 1 0 0 30 30 00 00
      7. 2 0 0 5 5 00 00
      8. 200 0 0 5 5 00 00
      9. 201 0 0 5 5 00 00
      10. // 6
      11. 210 0 0 1 1 00 00
      12. 220 0 0 1 1 00 00
      13. 230 0 0 1 1 00 00
      14. 202 0 0 5 5 00 00
      15. // 7
      16. 204 0 0 5 5 00 00
      17. 205 0 0 2 2 00 00
      18. // 10
      19. 203 0 0 3 3 00 00
      20. 206 0 0 2 2 00 00
      21. 207 0 0 2 2 00 00
      22. // 11
      23. 208 0 0 2 2 00 00
      24. 241 0 0 1 1 00 00
      25. 242 0 0 1 1 00 00
      26. 243 0 0 1 1 00 00
      27. 244 0 0 1 1 00 00
      28. // 12
      29. 21 0 0 1 1 00 00
      30. 22 0 0 1 1 00 00
      31. 23 0 0 1 1 00 00
      32. 24 0 0 1 1 00 00
      33. 25 0 0 1 1 00 00
      34. 151 0 0 2 2 00 00
      35. 152 0 0 2 2 00 00
      36. 153 0 0 2 2 00 00
      37. 154 0 0 2 2 00 00
      38. 155 0 0 2 2 00 00
      39. 156 0 0 2 2 00 00
      40. 157 0 0 2 2 00 00
      41. 158 0 0 2 2 00 00
      42. 159 0 0 2 2 00 00
      43. 160 0 0 2 2 00 00
      44. 161 0 0 2 2 00 00
      45. 162 0 0 2 2 00 00
      46. 163 0 0 2 2 00 00
      47. 164 0 0 2 2 00 00
      48. 165 0 0 2 2 00 00
      49. 166 0 0 2 2 00 00
      50. 167 0 0 2 2 00 00
      51. //13
      52. 3 0 0 5 5 00 00
      53. 209 0 0 1 1 00 00
      54. //14
      55. 121 0 0 5 5 00 00
      56. 122 0 0 5 5 00 00
      57. 211 0 0 5 5 00 00
      58. //15
      59. 123 0 0 10 10 00 00
      60. 212 0 0 1 1 00 00
      61. 213 0 0 1 1 00 00
      62. 214 0 0 1 1 00 00
      64. 124 0 0 5 5 00 00
      65. }
      67. [COLOR="Red"]0102[/COLOR]
      68. {
      69. 1 0 0 30 30 00 00
      70. 2 0 0 5 5 00 00
      71. 200 0 0 5 5 00 00
      72. 201 0 0 5 5 00 00
      73. // 6
      74. 210 0 0 1 1 00 00
      75. 220 0 0 1 1 00 00
      76. 230 0 0 1 1 00 00
      77. 202 0 0 5 5 00 00
      78. // 7
      79. 204 0 0 5 5 00 00
      80. 205 0 0 2 2 00 00
      81. // 10
      82. 203 0 0 3 3 00 00
      83. 206 0 0 2 2 00 00
      84. 207 0 0 2 2 00 00
      85. // 11
      86. 208 0 0 2 2 00 00
      87. 241 0 0 1 1 00 00
      88. 242 0 0 1 1 00 00
      89. 243 0 0 1 1 00 00
      90. 244 0 0 1 1 00 00
      91. // 12
      92. 21 0 0 1 1 00 00
      93. 22 0 0 1 1 00 00
      94. 23 0 0 1 1 00 00
      95. 24 0 0 1 1 00 00
      96. 25 0 0 1 1 00 00
      97. 151 0 0 2 2 00 00
      98. 152 0 0 2 2 00 00
      99. 153 0 0 2 2 00 00
      100. 154 0 0 2 2 00 00
      101. 155 0 0 2 2 00 00
      102. 156 0 0 2 2 00 00
      103. 157 0 0 2 2 00 00
      104. 158 0 0 2 2 00 00
      105. 159 0 0 2 2 00 00
      106. 160 0 0 2 2 00 00
      107. 161 0 0 2 2 00 00
      108. 162 0 0 2 2 00 00
      109. 163 0 0 2 2 00 00
      110. 164 0 0 2 2 00 00
      111. 165 0 0 2 2 00 00
      112. 166 0 0 2 2 00 00
      113. 167 0 0 2 2 00 00
      114. //13
      115. 3 0 0 5 5 00 00
      116. 209 0 0 1 1 00 00
      117. //14
      118. 121 0 0 5 5 00 00
      119. 122 0 0 5 5 00 00
      120. 211 0 0 5 5 00 00
      121. //15
      122. 123 0 0 10 10 00 00
      123. 212 0 0 1 1 00 00
      124. 213 0 0 1 1 00 00
      125. 214 0 0 1 1 00 00
      127. 124 0 0 5 5 00 00
      128. }
      Alles anzeigen


      CoreServer.ini (Cluster 2):

      Quellcode

      1. Sys [COLOR="Lime"]2[/COLOR]
      2. Database "[COLOR="Lime"]192.168.178.23[/COLOR]"
      4. [COLOR="Lime"]0201[/COLOR]
      5. {
      6. 1 0 0 30 30 00 00
      7. 2 0 0 5 5 00 00
      8. 200 0 0 5 5 00 00
      9. 201 0 0 5 5 00 00
      10. // 6
      11. 210 0 0 1 1 00 00
      12. 220 0 0 1 1 00 00
      13. 230 0 0 1 1 00 00
      14. 202 0 0 5 5 00 00
      15. // 7
      16. 204 0 0 5 5 00 00
      17. 205 0 0 2 2 00 00
      18. // 10
      19. 203 0 0 3 3 00 00
      20. 206 0 0 2 2 00 00
      21. 207 0 0 2 2 00 00
      22. // 11
      23. 208 0 0 2 2 00 00
      24. 241 0 0 1 1 00 00
      25. 242 0 0 1 1 00 00
      26. 243 0 0 1 1 00 00
      27. 244 0 0 1 1 00 00
      28. // 12
      29. 21 0 0 1 1 00 00
      30. 22 0 0 1 1 00 00
      31. 23 0 0 1 1 00 00
      32. 24 0 0 1 1 00 00
      33. 25 0 0 1 1 00 00
      34. 151 0 0 2 2 00 00
      35. 152 0 0 2 2 00 00
      36. 153 0 0 2 2 00 00
      37. 154 0 0 2 2 00 00
      38. 155 0 0 2 2 00 00
      39. 156 0 0 2 2 00 00
      40. 157 0 0 2 2 00 00
      41. 158 0 0 2 2 00 00
      42. 159 0 0 2 2 00 00
      43. 160 0 0 2 2 00 00
      44. 161 0 0 2 2 00 00
      45. 162 0 0 2 2 00 00
      46. 163 0 0 2 2 00 00
      47. 164 0 0 2 2 00 00
      48. 165 0 0 2 2 00 00
      49. 166 0 0 2 2 00 00
      50. 167 0 0 2 2 00 00
      51. //13
      52. 3 0 0 5 5 00 00
      53. 209 0 0 1 1 00 00
      54. //14
      55. 121 0 0 5 5 00 00
      56. 122 0 0 5 5 00 00
      57. 211 0 0 5 5 00 00
      58. //15
      59. 123 0 0 10 10 00 00
      60. 212 0 0 1 1 00 00
      61. 213 0 0 1 1 00 00
      62. 214 0 0 1 1 00 00
      64. 124 0 0 5 5 00 00
      65. }
      67. [COLOR="Lime"]0202[/COLOR]
      68. {
      69. 1 0 0 30 30 00 00
      70. 2 0 0 5 5 00 00
      71. 200 0 0 5 5 00 00
      72. 201 0 0 5 5 00 00
      73. // 6
      74. 210 0 0 1 1 00 00
      75. 220 0 0 1 1 00 00
      76. 230 0 0 1 1 00 00
      77. 202 0 0 5 5 00 00
      78. // 7
      79. 204 0 0 5 5 00 00
      80. 205 0 0 2 2 00 00
      81. // 10
      82. 203 0 0 3 3 00 00
      83. 206 0 0 2 2 00 00
      84. 207 0 0 2 2 00 00
      85. // 11
      86. 208 0 0 2 2 00 00
      87. 241 0 0 1 1 00 00
      88. 242 0 0 1 1 00 00
      89. 243 0 0 1 1 00 00
      90. 244 0 0 1 1 00 00
      91. // 12
      92. 21 0 0 1 1 00 00
      93. 22 0 0 1 1 00 00
      94. 23 0 0 1 1 00 00
      95. 24 0 0 1 1 00 00
      96. 25 0 0 1 1 00 00
      97. 151 0 0 2 2 00 00
      98. 152 0 0 2 2 00 00
      99. 153 0 0 2 2 00 00
      100. 154 0 0 2 2 00 00
      101. 155 0 0 2 2 00 00
      102. 156 0 0 2 2 00 00
      103. 157 0 0 2 2 00 00
      104. 158 0 0 2 2 00 00
      105. 159 0 0 2 2 00 00
      106. 160 0 0 2 2 00 00
      107. 161 0 0 2 2 00 00
      108. 162 0 0 2 2 00 00
      109. 163 0 0 2 2 00 00
      110. 164 0 0 2 2 00 00
      111. 165 0 0 2 2 00 00
      112. 166 0 0 2 2 00 00
      113. 167 0 0 2 2 00 00
      114. //13
      115. 3 0 0 5 5 00 00
      116. 209 0 0 1 1 00 00
      117. //14
      118. 121 0 0 5 5 00 00
      119. 122 0 0 5 5 00 00
      120. 211 0 0 5 5 00 00
      121. //15
      122. 123 0 0 10 10 00 00
      123. 212 0 0 1 1 00 00
      124. 213 0 0 1 1 00 00
      125. 214 0 0 1 1 00 00
      127. 124 0 0 5 5 00 00
      128. }
      Alles anzeigen


      LoginServer.ini (Cluster 1):

      Quellcode

      1. DB "[COLOR="Red"]192.168.178.22[/COLOR]"
      2. Core "[COLOR="Red"]192.168.178.22[/COLOR]"
      3. // CACHE
      4. AddCache( "[COLOR="Red"]192.168.178.22[/COLOR]" );
      5. MSG_VER "20070706"


      LoginServer.ini (Cluster 2):

      Quellcode

      1. DB "[COLOR="Lime"]192.168.178.23[/COLOR]"
      2. Core "[COLOR="Lime"]192.168.178.23[/COLOR]"
      3. // CACHE
      4. AddCache( "[COLOR="Lime"]192.168.178.23[/COLOR]" );
      5. MSG_VER "20070706"


      DatabaseServer.ini (Cluster 1):

      Quellcode

      1. ResourceFolder "C:\NeuroSpace\Resource"
      2. Sys [COLOR="Red"]1[/COLOR]
      3. Account "[COLOR="Red"]192.168.178.22[/COLOR]"
      5. DSN_NAME_CHARACTER "[COLOR="Red"]character01[/COLOR]"
      6. DB_ADMIN_ID_CHARACTER "[COLOR="Red"]character01[/COLOR]"
      8. DSN_NAME_LOG "[COLOR="Red"]log01[/COLOR]"
      9. DB_ADMIN_ID_LOG "[COLOR="Red"]log01[/COLOR]"
      11. DB_PWD_LOG ""
      12. DB_PWD_CHARACTER ""
      13. DB_PWD_BACKEND ""
      14. DB_PWD_ITEMUPDATE ""
      Alles anzeigen


      DatabaseServer.ini (Cluster 2):

      Quellcode

      1. ResourceFolder "C:\NeuroSpace\Resource"
      2. Sys [COLOR="Lime"]2[/COLOR]
      3. Account "[COLOR="Lime"]192.168.178.23[/COLOR]"
      5. DSN_NAME_CHARACTER "[COLOR="Lime"]character02[/COLOR]"
      6. DB_ADMIN_ID_CHARACTER "[COLOR="Lime"]character02[/COLOR]"
      8. DSN_NAME_LOG "[COLOR="Lime"]log02[/COLOR]"
      9. DB_ADMIN_ID_LOG "[COLOR="Lime"]log02[/COLOR]"
      11. DB_PWD_LOG ""
      12. DB_PWD_CHARACTER ""
      13. DB_PWD_BACKEND ""
      14. DB_PWD_ITEMUPDATE ""
      Alles anzeigen


      WorldServer.ini (Cluster 1, Channel 1):

      Quellcode

      1. ResourceFolder "C:\NeuroSpace\Resource"
      3. Key [COLOR="Red"]0101[/COLOR]
      4. Core "[COLOR="Red"]192.168.178.22[/COLOR]"
      5. DB "[COLOR="Red"]192.168.178.22[/COLOR]"
      7. GUILDWAR
      9. //18
      10. //PK
      11. //PKCOST
      12. //STEAL
      14. DROPITEM_REMOVE
      16. WORMON
      17. GUILDBANK
      18. GUILDCOMBAT
      19. GUILDCOMBAT1TO1
      20. ARENA
      21. SECRETROOM
      22. RAINBOWRACE
      Alles anzeigen


      WorldServer.ini (Cluster 1, Channel 2):

      Quellcode

      1. ResourceFolder "C:\NeuroSpace\Resource"
      3. Key [COLOR="Red"]0102[/COLOR]
      4. Core "[COLOR="Red"]192.168.178.22[/COLOR]"
      5. DB "[COLOR="Red"]192.168.178.22[/COLOR]"
      7. GUILDWAR
      9. //18
      10. //PK
      11. //PKCOST
      12. //STEAL
      14. DROPITEM_REMOVE
      16. WORMON
      17. GUILDBANK
      18. GUILDCOMBAT
      19. GUILDCOMBAT1TO1
      20. ARENA
      21. SECRETROOM
      22. RAINBOWRACE
      Alles anzeigen


      WorldServer.ini (Cluster 2, Channel 1):

      Quellcode

      1. ResourceFolder "C:\NeuroSpace\Resource"
      3. Key [COLOR="Lime"]0201[/COLOR]
      4. Core "[COLOR="Lime"]192.168.178.23[/COLOR]"
      5. DB "[COLOR="Lime"]192.168.178.23[/COLOR]"
      7. GUILDWAR
      9. //18
      10. //PK
      11. //PKCOST
      12. //STEAL
      14. DROPITEM_REMOVE
      16. WORMON
      17. GUILDBANK
      18. GUILDCOMBAT
      19. GUILDCOMBAT1TO1
      20. ARENA
      21. SECRETROOM
      22. RAINBOWRACE
      Alles anzeigen


      WorldServer.ini (Cluster 2, Channel 2):

      Quellcode

      1. ResourceFolder "C:\NeuroSpace\Resource"
      3. Key [COLOR="Lime"]0202[/COLOR]
      4. Core "[COLOR="Lime"]192.168.178.23[/COLOR]"
      5. DB "[COLOR="Lime"]192.168.178.23[/COLOR]"
      7. GUILDWAR
      9. //18
      10. //PK
      11. //PKCOST
      12. //STEAL
      14. DROPITEM_REMOVE
      16. WORMON
      17. GUILDBANK
      18. GUILDCOMBAT
      19. GUILDCOMBAT1TO1
      20. ARENA
      21. SECRETROOM
      22. RAINBOWRACE
      Alles anzeigen


      Auf dem SQL Server müssen natürlich die verschiedenen Datenbanken (CHARACTER_01_DBF, LOGGING_01_DBF, CHARACTER_02_DBF, LOGGING_02_DBF) vorhanden sein, damit das ganze funktioniert ^^

      Auf dem 2. Root dann natürlich die DSNs erstellen, die mit der 2 aufhören :P

      Damit das ganze auch noch klar wird, hier die Struktur:

      Quellcode

      1. AccountServer
      2. - Certifier1
      3. - DBServer1
      4. - CoreServer1
      5. - LoginServer1
      6. - CacheServer1
      7. - WorldServer1
      8. - Certifier2
      9. - DBServer2
      10. - CoreServer2
      11. - LoginServer2
      12. - CacheServer2
      13. - WorldServer2
      Alles anzeigen

      Das einzige, was alle Server verbindet, ist der Account Server ^^


      Viel spaß damit :D

      b2w laut twi geht es nicht :D