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
<mailto: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 <mailto: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
--
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