I have done some similar things, but I'd recommend doing some clean-room experiments far from any live data, if for no other reason than to work out the particulars :)
Best of luck! Cheers James On Sat, Mar 1, 2014 at 8:29 AM, Chris <mewtwo0...@gmail.com> wrote: > Thanks James! :) I will definitely be doing all this in a test > environment isolated from my main production server until I've worked the > ins and outs of it... er... out. Would you happen to know if there are any > issues importing a .sql dump that was taken from an install with the > Federated Engine disabled to one where it is enabled? (And perhaps vice > versa?) and using MySQL Admin to do it? > > > On 3/1/2014 8:21 AM, James Stallings II wrote: > > Hi Chris, > > MariaDB is a drop-in replacement for MySQL; we use it at OSgrid and have > been for a few years now. I'm completely unfamiliar with TokuDB, but to the > rest of your questions, pretty much 'yes'. sqldumps should be 100% > compatible with some limitations; primarily database types (I think MariaDB > uses the Federated Engine in place of InnoDB). > > The MySQLAdmin toolset works, but lacks the ability to monitor the > service and a few other trivial things; it will carp when you run it but it > does work. Things it can't do will be greyed out. For most of what I've > used it for casually it has worked fine. Anything else can be done using > mysladministrator or the mysql text client. > > Make backups, do your homework on the MySQL/MariaDB differences (they > are few but you should be aware of them), and of course make good backups > along the way ;) > > You should be fine. > > > Cheers > James > > > > On Sat, Mar 1, 2014 at 8:14 AM, Chris <mewtwo0...@gmail.com> wrote: > >> Hello everyone, >> >> I am interested in switching my MySQL 5.1.63 install over to one of the >> various MariaDB installs; I was wondering if anyone here has any experience >> with MariaDB and whether or not there are any issues in using it with >> OpenSim? I plan on utilizing one of the builds based on MySQL 5.1.xx; >> probably MariaDB 5.3. My reasons for this is because I am not quite ready >> to switch over to MySQL 5.5 code base just yet. >> >> Also I am interested in utilizing the TokuDB storage engine with MariaDB. >> I noticed that in my current database OpenSim is mainly using InnoDB with >> MyISAM being used for the land related tables; would there be any issues in >> switching them over to TokuDB (At the very least the InnoDB tables)? >> >> Some specific questions I am looking to have answered are: >> >> * Are there any noticeable performance gains using OpenSim on MariaDB? >> With TokuDB as the storage engine? >> * Is MySQL Administrator GUI tool compatible with MariaDB? (Old, I >> realize, but I prefer it over the MySQL Workbench) >> * Are there any known issues I should look out for with MariaDB and/or >> Toku DB? >> * Are the .sql dump files produced by either compatible with each other? >> (I plan on using a .sql dump outputted by MySQL to get my database over to >> the MariaDB install... and might need to utilize a .sql dump file outputted >> by MariaDB to go back to MySQL if I need to switch back for whatever reason) >> >> This is all going to undergo install and testing on a separate machine >> with its own 'new' database of course. I won't be touching my production >> database for a while until I'm completely comfortable with the new setup :) >> >> Initial set up and testing is to be done on a Windows 7 x64 system, >> .NET, with 4 GB of RAM; eventually to be migrated to another system, Win 7 >> x64, .NET, 7 GB of RAM on OS 0.7.6 Release >> >> Thank you! >> >> -- >> OpenSim: 10 Region Standalone on 0.7.6 Dev >> Physics: Open Dynamics Engine >> OS: Windows 7 (x64) >> CPU: AMD Phenom II X4 840 3.2 GHz >> Memory: 11 GB DDR3 >> Database: MySQL 5.1.63 (x64) >> >> _______________________________________________ >> Opensim-users mailing list >> Opensim-users@lists.berlios.de >> https://lists.berlios.de/mailman/listinfo/opensim-users >> > > > > -- > =================================== > http://osgrid.org/ > http://simhost.com > http://twitter.com/jstallings2 > > > > _______________________________________________ > Opensim-users mailing > listOpensim-users@lists.berlios.dehttps://lists.berlios.de/mailman/listinfo/opensim-users > > > > -- > OpenSim: 10 Region Standalone on 0.7.6 Dev > Physics: Open Dynamics Engine > OS: Windows 7 (x64) > CPU: AMD Phenom II X4 840 3.2 GHz > Memory: 11 GB DDR3 > Database: MySQL 5.1.63 (x64) > > > _______________________________________________ > Opensim-users mailing list > Opensim-users@lists.berlios.de > https://lists.berlios.de/mailman/listinfo/opensim-users > -- =================================== http://osgrid.org/ http://simhost.com http://twitter.com/jstallings2
_______________________________________________ Opensim-users mailing list Opensim-users@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-users