[Opensim-dev] Potential MySQL issue with centralized datastor

[Brian Wolfe]

I have 14 regions using a central MySQL server for all storage that I'm
comfortable giving access to the core devs.

I plan on upgrading it to latest trunk this weekend. I can open up ports
on the firewall to get them SSH access if it's wanted as a testing
ground for tracking this issue.

On Fri, 2008-04-04 at 08:46 -0700, Charles Krinke wrote:
> A week ago, the CentralGrid folks changed their regions from SQLite to
> use a centralized MySQL datastor and had a problem. I got their
> regions back to SQLite and everything worked again.
> 
> Yesterday the UCIGrid folks tried to update past r4058 and had a
> similar problem. The problem is an inability to bring up any regions
> and getting the error "unknown master user UUID".
> 
> During all of this, OSGrid is working pretty well.
> 
> I can tell you that some regions on OSGrid are running SQLite (plazas,
> Yang, Celt, 'moons' to name a few) and others are running MySQL
> (Nebadon's, daTwitch's) and we did that intentionally to test both
> datastores.
> 
> But, heres the deal. There is no centralized datastor for *any* region
> on OSGrid. The UGAI MySQL database stands on its own and contains the
> users, regions, assets, inventory and web site folders.
> 
> No region talks to the UGAI MySQL except through the UGAI. Each region
> has its own standalone MySQL or SQLite datastor. Another point. I did
> run the plazas on the UGAI server for a while, but I had some trouble
> with the gridserver freezing and a couple of months ago, I moved the
> plazas to our backup server and they have been running much better
> ever since.
> 
> It very well may be that we have uncovered a problem. If so, this is
> going to be tough to close the loop as we dont have that use case
> setup anywhere.
> 
> There are 4 of the core team that have console access to OSGrid and
> generally just watch over our shoulder or read entries in the MySQL
> datastore. We did that in order to have a way for our core developers
> insight into the dynamics of a running grid.
> 
> But, since OSGrid is a heterogeneous grid, meaning, all the regions
> are *elsewhere*. That is, none are on the same lan segment as the
> UGAI, all the regions datastores are local to the regions and not
> connected to the UGAI except through the external UGAI interfaces.
> 
> Hmmm. If true, how are we going to figure this one out for grids that
> are more homogeneous, that is, the regions are tied more closely to
> the UGAI then on OSGrid.
> 
> Charles
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev