[Opensim-users] robust/opensim estate tables

[Nicky Perian]

Thanks for the reply. I have an operational performance question. If I changed over to estate on mysql, would that rule out transfer of that region to a grid? If not, would transfer of that region to an off site server degrade performance? I assume that a remote instance of opensim would have the SULite Opensim.db on a remote server with ROBUST on different hardware.

Asking more directly: Would removing SQlite->Opensim.db use decrease flexibility or performance of the Opensim instance?



>________________________________
> From: James Hughes <jamesh at bluewallgroup.com>
>To: Nicky Perian <nickyperian at yahoo.com>; opensim-users at lists.berlios.de 
>Sent: Tuesday, October 2, 2012 6:43 PM
>Subject: Re: [Opensim-users] robust/opensim estate tables
> 
>I have it working on a grid with a separate estate database in mysql. To 
>do that, comment the Include-Storage = 
>"config-include/storage/SQLiteStandalone.ini", then uncomment...
>
>StorageProvider = "OpenSim.Data.MySQL.dll"
>ConnectionString = "Data Source=localhost;Database=db_name;User 
>ID=db_user;Password=db_pass;Old Guids=true;"
>EstateConnectionString = "Data Source=localhost;Database=db_estate;User 
>ID=db_user;Password=db_pass;Old Guids=true;"
>
>If you select MySQL and leave the EstateConnectionString commented, then 
>your estate data *should* be included in your region data selected with 
>the parameters in "ConnectionString".
>
>If you see something different then let me know and I'll dig further.
>
>Thanks,
>BlueWall
>
>
>On 10/01/2012 07:26 PM, Nicky Perian wrote:
>> maybe this is a non-problem but, it has me stumped.
>> when running a standalone w/mysql the estate tables are populated into
>> the database.
>> when running robust/opensim instances the estate tables appear to to be
>> placed in an sqlite database
>> as per the setting in GridCommon.ini of:
>> [DatabaseService]
>> ;
>> ; ### Choose the DB
>> ;
>>
>> ; SQLite
>> Include-Storage = "config-include/storage/SQLiteStandalone.ini";
>>
>> Attempts to comment this out and use mysql database fail w/ region not
>> part of estate error.
>>
>>
>> Is there a way to place the estate tables into the mysql database?
>>
>> This came up because I wanted to transfer ownership of region by table
>> entry as I had done before in a standalone configuration.
>>
>> If this is the way estate data is handled in the robust/opensim
>> configuration; how are the estate tables edited to transfer region
>> ownership?
>>
>> Additionally, the show names data does not persist for run to run which
>> it does for a standalone.
>>
>> Comments please.
>>
>> Nicky
>>
>>
>>
>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20121002/753364ca/attachment.html>