Change font size
It is currently Fri Jul 19, 2019 3:33 pm

Forum rules


{L_IMAGE}



Post a new topicPost a reply Page 1 of 1   [ 5 posts ]
Author Message
 Post subject: database migrations..!! whats the latest?
PostPosted: Mon Dec 25, 2017 3:50 pm 
User avatar

Joined: Sun Apr 25, 2010 1:03 pm
Posts: 33
Location: Zierikzee, Netherlands
whats the latest on database migrations..?? if mysql is getting to slow, maybe switch to (MS)SQL Server witch is WAY faster....

OSGRID login page:

We are taking a new strategy for database migration, as you know Osgrid is the largest Opensimulator grid with large amounts of data which. unfortunately, the standard mysql tools can be very slow. So we are studying other possibilities for migration of the databases with other tools that are much more efficient. In concept: we will backup the grid in the background keeping the grid online. We decided to change the migration tactics so that our residents can continue to use the grid during their end-of-year holiday
Some of you may experience failed teleports and simulator errors on startup for the next 24 hours. This is because of the time it takes new dns records to be cached around the world. Some common solutions are to flush dns cache or change dns servers to one that is current.

_________________
{L_IMAGE}


Top
 Profile  
 
 Post subject: Re: database migrations..!! whats the latest?
PostPosted: Tue Dec 26, 2017 12:23 pm 
Furious Typer

Joined: Tue Jan 31, 2012 12:40 pm
Posts: 95
SQL Server may be faster, but the licensing would probably be about the same as the total current OSG hardware monthly cost. SQL Server Express is a freebie but it has a lot of limitations; no way it would handle the amount of data OSG has in assets.


Top
 Profile  
 
 Post subject: Re: database migrations..!! whats the latest?
PostPosted: Tue Dec 26, 2017 7:21 pm 
Site Admin
User avatar

Joined: Sun Jun 27, 2010 10:34 am
Posts: 155
Location: France
ms sql server hahaha ...

_________________
Paela Argus,
Webmanagement and maintenance servers grid, Osgrid

https://www.osgrid.org


Top
 Profile  
 
 Post subject: Re: database migrations..!! whats the latest?
PostPosted: Wed Dec 27, 2017 11:26 am 
Furious Typer
User avatar

Joined: Fri Aug 19, 2011 7:10 pm
Posts: 242
Location: UK
I assume that the main servers are running on Windows, then? MaridDB would probably be more than capable, and is fully SQL compatible, meaning a change of server rather than a migration.

EDIT: Dunno if it's Linux only, though.

_________________
50's sim based at Rumbled on OSGrid
happily running on Debian Linux on a VPS since June 10 2013


Top
 Profile  
 
 Post subject: Re: database migrations..!! whats the latest?
PostPosted: Sat Feb 03, 2018 9:43 am 
Site Admin
User avatar

Joined: Sun Jun 27, 2010 10:34 am
Posts: 155
Location: France
we use only linux

_________________
Paela Argus,
Webmanagement and maintenance servers grid, Osgrid

https://www.osgrid.org


Top
 Profile  
 
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 1   [ 5 posts ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
610nm Style by Daniel St. Jules of Gamexe.net