Forums WoW Modding Support Archives TrinityCore Discord Archives [DiscordArchive] I was thinking about the ways of implementing crossrelam worldserver with the focus on DB interactio

[DiscordArchive] I was thinking about the ways of implementing crossrelam worldserver with the focus on DB interactio

[DiscordArchive] I was thinking about the ways of implementing crossrelam worldserver with the focus on DB interactio

rektbyfaith
Administrator
0
03-07-2023, 11:09 AM
#1
Archived author: walkline • Posted: 2023-03-07T11:09:14.732000+00:00
Original source

I was thinking about the ways of implementing crossrelam worldserver with the focus on DB interactions. I see here 2 possible solutions.

The first one is obvious, crossrealm worldserver would have connections to all characters databases for all possible realms.

The second one is more interesting. Don't use any connections to the characters DB in crossrealm worldserver. So basically, we can serialize (JSON, protobuf, etc.) a player on a realm-specific worldserver before redirecting him to the crossrealm. And send this serialized player alongside with redirect/connect command. And on crossrealm, this player would be created from this serialized data. Once player finishes his business on crossrealm, redirect/connect player back to the realm-specific worldserver using the same logic with serialization/deseralization, but this time, once player deserialazed, we need to save him to the DB.
The second one looks interesting on paper to me. But not sure about how it would go in practice.
How would you implement this?
rektbyfaith
03-07-2023, 11:09 AM #1

Archived author: walkline • Posted: 2023-03-07T11:09:14.732000+00:00
Original source

I was thinking about the ways of implementing crossrelam worldserver with the focus on DB interactions. I see here 2 possible solutions.

The first one is obvious, crossrealm worldserver would have connections to all characters databases for all possible realms.

The second one is more interesting. Don't use any connections to the characters DB in crossrealm worldserver. So basically, we can serialize (JSON, protobuf, etc.) a player on a realm-specific worldserver before redirecting him to the crossrealm. And send this serialized player alongside with redirect/connect command. And on crossrealm, this player would be created from this serialized data. Once player finishes his business on crossrealm, redirect/connect player back to the realm-specific worldserver using the same logic with serialization/deseralization, but this time, once player deserialazed, we need to save him to the DB.
The second one looks interesting on paper to me. But not sure about how it would go in practice.
How would you implement this?

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)