Synchronize Characters between two databses.

[blackms3]

Hi Everyone,

Just a little question, I have two instances of mangosd, one with PlayerBot, one without.

I'd like to synchronize characters between the two databases, in order of let the user play in a server or in another and share the same progresses.

Have you an Idea of which queries have I to run? And which table have I to keep updated?

Thanks in advance!

[evilatwow]

Characters have data in so many tables. The spells they know/trained, the inventory, quest status, etc, it's all saved in different tables. They might even show up as the person putting or removing something in a guild bank tab!

So... perhaps it's easier to just export a character and import it again on the other server? I vaguely remember the commands are something like "pdump write" and "pdump load".

Oh, do make a backup when you first test this. I would be surprised if that functionality is often used, so you never know exporting/importing has a little bug

[antz]

As a long shot, can you point both the servers at the same characters database ?

I often share the characters database across different mangos instances this way.

Just a thought

[Cala]

I agree with Antz. I too have instances of mangos (one with playerbot and the other without) and they share the same database (characters, realm, world and scripts). Much easier to maintain. No issue until now.

[evilatwow]

Hmm yes, that probably works even better. At least until someone starts two clients and tries to log in on both realms simultaneously...

[Cala]

You are right, indeed. I just wonder what is the point of starting two different clients to log into the same account.

[Cala]

If you still want to synchronise two databases, keep in mind that you can not just sync the whole characters database, you'll have to sync also some of the tables from the realm database as the accounts linked to the characters are stored there and the number of characters per realm also.

[brunogcar_]

there might be problems using 1 char db to 2 servers,

IF I REMEMBER IT ORRECTLY

each core load some tables from char db to memory and perform some checks when it starts up

and load individual chars as they login

each core will save data from memory to db at set interval or player logout

as proposed lets imagine a simple situation

- 2 diferent players,

- one on each server,

- both using same char db,

- and they get a new item

each server will assign new entry to that item in item_instance, but as server reads it when it starts and keep it on memory just saving eventually, both servers can use same range ID to new entries

as long both players are online, both servers will know what each player has in its inventory, but as both players logout that kind of info inst ther anymore to be read on the fly, so after a while when both players try to connect, both servers will read db and load every thing related to that char id from db

IMO for sure one of those chars wont have that item, as its been long i dont do anything to mangos, i wont dare to predict other errors that will happen, as CHARS DB unlike REALMD DB was never meant to be used by more than one core

but then again, i might be wrong cos its been really long i dont use mangos or any of its variants, but giving heads up to problems that might happen

[antz]

Im not sure, but if you log into one account, it becomes locked on the other server. At worst if you login to the 2nd server, you are disconnected from the 1st.

At least thats how I remember it working