Run 2 Servers WoW same computer

[elliott300]

Hey guys, I just made my shadowlands server and it runs great, now im trying to make my Dragonflight server and whenever I try to put the Query in from the website it keeps saying Query failed even though I created a brand new server.

 

[elliott300]

I also noticed that my new dragonflight data has the same information as my shadowlands one in the SQLyog.

 

[jenson]

Example:

1-Mysql server
Data for server one:
Auth, characters, world , hotfix

Data for server two:
Auth2, characters2, world2, hotfix2

Set authconfig and worldconfig of server two to point to database's (2)

(Auth2, characters2, world2, hotfix2)

Config realmlist table:
Each server need his own ports:

Default: ports for server one
8081-8085
Or
3724-8085

(Ports depending on core)

Create ports for server two
Example: 8086 - 8082

Open ports in firewall for realm two.

 

[AlKamel]

As @jenson said it would be better if you rename every expansion database name to avoid conflicts with server paths.

As the master branch on TC will always have the generic Auth, Characters, Hotfixes and World databases names, for older versions of WoW it will cause a lot of issues, so it's better that you rename them the way you consider more comfortable. Then, once you have done this, you'll have to replace the database names on .config files.

The last thing is the Ports and IP configuration. This is because if you want to run the servers simultaneously it'll be a MySQL conflict with the connections if both of them are addresed to localhost (or the same IP)

Here are some threads with discussions realted to your question.
Multiple servers on a single machine
Vanilla/TBC and WoTLK realms

We hope it'll be of any help, and let us know if you have another question.

 

[amycastell]

Example:

1-Mysql server
Data for server one:
Auth, characters, world , hotfix

Data for server two:
Auth2, characters2, world2, hotfix2

Set authconfig and worldconfig of server two to point to database's (2)

(Auth2, characters2, world2, hotfix2)

Config realmlist table:
Each server need his own ports:

Default: ports for server one
8081-8085
Or
3724-8085

(Ports depending on core)

Create ports for server two
Example: 8086 - 8082

Open ports in firewall for realm two.

Puedes darme esta explicación en español?

 

[jenson]

Puedes darme esta explicación en español?

Para tener dos reinos:

1 servidor MYSQL
Cada reino tiene su propia db's

El primero por defecto es:
World, characters, auth, hotfix

El segundo reino usaremos por ejemplo:

World2, characters2, auth2, hotfix2

Ahora tenemos que apuntar el reino 2 a las db's (2), buscaremos:

Worldconfig y authconfig del reino 2
Hay cambiaremos la información para apuntar a la dbs2 ejemplo:

Auth = auth2

Una vez hecho eso, también tendremos que darle un puerto de acceso diferente al reino 1, cada reino utiliza su propio puerto, ejemplo:

Si reino 1 utiliza 3724 y 8085
El segundo reino utiliza 3725 y 8086

Puedes usar los puertos que quieras.
edita los puertos en Worldconfig y authconfig del reino 2.

En la tabla realmlist de la db auth2 tendras que cambiar el puerto del reino.

Eso es si utilizas dos versiones diferentes de wow / core / cliente

Si utilizas la misma versión por ejemplo:

Un reino 335a blizzlike y otro 335a instant80 puedes usar el mismo auth server para los dos reinos, solo tendrías que crear:
Characters2 y world2

Recuerda que los puertos tienes que abrirlos en el firewall y router.

Y creo que no se me olvida nada, corregidme si eso, un saludo.