[Opensim-users] Interested in switching to MariaDB with TokuDB. Any issues?

Sat Mar 1 16:33:39 UTC 2014

I gotcha. Extended testing is a go :) Thanks for the tips and help!

On 3/1/2014 9:05 AM, James Stallings II wrote:
>
> 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 and make sure you
>
> 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 <mewtwo0641 at gmail.com 
>> <mailto:mewtwo0641 at 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 at lists.berlios.de
>>     <mailto:Opensim-users at 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 at lists.berlios.de  <mailto:Opensim-users at lists.berlios.de>
>> https://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 at lists.berlios.de <mailto:Opensim-users at lists.berlios.de>
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://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)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20140301/1071b5f3/attachment.html>