Multiple servers on shared path

[Mr_Moose]

As a test to see if it worked I made a copy of a fully working MTA server directory with data stored as SQLite and xml, copied the MTA Server.exe file and started the first server, when it finished loading I changed the mtaserver.conf with new ports and started the second server. So what we got here is basically two MTA servers running on the same path with access to the same files and resources, after running this configuration for a few hours I haven't seen any issues yet, however I could use some advices from anyone with experience in this, is this a good solution to sync multiple servers, is there anything that can go wrong and make the files corrupt for instance?

To start it all up and move the configuration files to the correct destinations I'm using a regular bat file with some delays included to prevent conflicts during load. Any advices or is there better and more simple ways to keep multiple servers synced? It seems like an easy solution but you know the rules of engineering, if it seems easy it's most likely wrong. What do you think?

[tosfera]

I wouldn't recommend it. Simply because the system isn't build for things like this. Keeping server-sided values can mess up alot, also your scripts will be filled with more and more users I guess... it can cause some serious damage if I think about it...

[Mr_Moose]

After a couple of hours I realized the issues with this idea, for instance multiple apps can't write to the SQLite databases at the same time, internal database wasn't fully synced due to that and the same was seen in the resources itself, everything wasn't synced and some values seems to disappear while connecting between the servers, this with just a few players online. I gave up on this one by myself to, should have used MySQL from the beginning I guess, speaking of that does anyone know a way to convert a SQLite database to MySQL, (would save a lot of time since most of the accounts are located in one server).