UESPWiki:Administrator Noticeboard/Archives/Wiki DB Switch

This is an archive of past UESPWiki:Administrator Noticeboard discussions. Do not edit the contents of this page, except for maintenance such as updating links.

Wiki DB Switch

I've switched the UESP Wiki to use the db1 database server (again). While everything seems fine let me know if you notice anything abnormal you notice over the next few days. There should be a small increase in site performance though I doubt it will be noticable. -- Daveh 10:11, 11 November 2008 (EST)

The site's maps (Oblivion, SI, and Morrowind) also need access to the database -- or else there are problems like this. I've edited the map code to point to the new db1 server instead of localhost. But it looks like the "maps" user in mysql doesn't have permission to access the database remotely. For now, I've implemented a temporary fix (accessing the DB using the same user as the wiki), but a better longterm solution would be to re-enable the "maps" user. --Nephele^Talk 18:13, 11 November 2008 (EST)

Overall performance definitely seems to be a touch better. On some pages (like the Wanted Pages list), the improvement has been huge: it's gone from taking some 20s to load down to about 2s. –Rpeh^{•T•C•E•} 05:25, 13 November 2008 (EST)