Mysql / Auth Server

[Blackvision]

Is it possible to run more than one mysql / auth server, with different ports of course ?
I'm trying to setup a test server, changed the mysql, auth, world port so it wouldn't be in conflict with my main server, but for some reason I can't enter it, not even via localhost, 127.0.0.1 etc ..

Thanks in advance

 

[koradorel]

The best thing for you to do is have a single MySQL server and Auth server, but separate world servers. Then you change the realmID for the worldserver, and the port, as well as the character and world databases. This would split your server and keep it on the same realmlist.

To clarify :

# CONNECTIONS AND DIRECTORIES
#
# RealmID
# Description: ID of the Realm using this config.
# Important: RealmID must match the realmlist inside the auth database.
# Default: 1

RealmID = 1

Change that to RealmID = 2

#
# LoginDatabaseInfo
# WorldDatabaseInfo
# CharacterDatabaseInfo
# Description: Database connection settings for the world server.
# Example: "hostname;port;username;password;database"
# ".;somenumber;username;password;database" - (Use named pipes on Windows
# "enable-named-pipe" to [mysqld]
# section my.ini)
# ".;/path/to/unix_socket;username;password;database" - (use Unix sockets on
# Unix/Linux)

LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;mop_auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;mop_world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;mop_characters"
ArchiveDatabaseInfo = "127.0.0.1;3306;root;ascent;mop_log"

You don't HAVE to change the port from 3306, but make sure you change the mop_characters, and mop_world to be something new... like mop_world2, etc

Then the final step is to go into the database, export data/copy mop_characters and mop_world, and create the new databases you defined earlier (mop_world2). Execute the other database file into the new database to create the data the world will run on.

Don't forget to add a new realm to the realmlist in mop_auth with the ID of 2 instead of 1.

INSERT INTO `realmlist` VALUES (2, 'Private Test Realm', 'Private Test Realm', '25.89.63.183', 8086, 1, 0, 1, 1, 0, 18414, 0);