|
Forum > Serverside Modding
[QUESTION] Ports for a wow server
<< < (3/14) > >>
Amaroth:
--- Quote from: "Смердокрыл" ---Also, I need an alternative for the 3036 port for the mysql of the second server.
--- End quote ---
Why the hell would you want to have 2 MySQL servers at one machine for this? It just complicates working with databases, accounts to acces them and there are possibly more issues with such thing. Aside, I have no idea how to install second MySQL server on a machine where one MySQL server already is.
Смердокрыл:
--- Quote from: "Amaroth" ---Why the hell would you want to have 2 MySQL servers at one machine for this? It just complicates working with databases, accounts to acces them and there are possibly more issues with such thing. Aside, I have no idea how to install second MySQL server on a machine where one MySQL server already is.
--- End quote ---
So the databases of the two servers do not mix. Although, I might not fully understad what a "MySQL server" actually is.
Amaroth:
auth, characters, world - that is not one databas, thats 3 databases. There can be unlimited number of databases on one MySQL server (most of folks call MySQL server "database" but thats pretty incorrect, MySQL server actually contains multiple databases).
You don't need 2 MySQL servers running on 2 different ports. There is absolutely no need of it. One server with one IP on 1 port containing 6 databases (3 for each server) will work.
Смердокрыл:
I'll give an example:
I already have two servers installed on my computer. Therefore, I have two connections listed in navicat. However, if I run one server's denwer, I can open both connections and so both of them show me exactly the same databases of one server. But I want one connection to show one server and the other connection - the other server. Or, at least, I want to have access to the databases of both servers and not be confused between them.
saifi0102:
You can read this https://dev.mysql.com/doc/refman/5.1/en ... rvers.html
If you see exactly the same databases in both Navicat connections, its probably because you are connecting to the same MySQL server. Do both connections have the same port?
However, I agree with Amaroth you don't need 2 MySQL servers. Just create 3 additional database in your current MySQL server and name them like
realmname_auth, realmname_char, realmname_world
Navigation
[0] Message Index
[#] Next page
[*] Previous page
|