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

[James Stallings II]

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> 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
> https://lists.berlios.de/mailman/listinfo/opensim-users
>



-- 
===================================
http://osgrid.org/
http://simhost.com
http://twitter.com/jstallings2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20140301/14dd38c4/attachment.html>