<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">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?<br>
<br>
On 3/1/2014 8:21 AM, James Stallings II wrote:<br>
</div>
<blockquote
cite="mid:CAOaG_2Z8YoRj5poSPeu8Vj2s9TT+zYOAYpPreqs7WNNnmeGS0w@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Chris,
<div><br>
</div>
<div>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).</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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 ;)</div>
<div><br>
</div>
<div>You should be fine.</div>
<div><br>
</div>
<div><br>
</div>
<div>Cheers</div>
<div>James</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Sat, Mar 1, 2014 at 8:14 AM, Chris <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:mewtwo0641@gmail.com" target="_blank">mewtwo0641@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hello
everyone,<br>
<br>
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.<br>
<br>
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)?<br>
<br>
Some specific questions I am looking to have answered are:<br>
<br>
* Are there any noticeable performance gains using OpenSim
on MariaDB? With TokuDB as the storage engine?<br>
* Is MySQL Administrator GUI tool compatible with MariaDB?
(Old, I realize, but I prefer it over the MySQL Workbench)<br>
* Are there any known issues I should look out for with
MariaDB and/or Toku DB?<br>
* 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)<br>
<br>
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 :)<br>
<br>
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<br>
<br>
Thank you!<span class="HOEnZb"><font color="#888888"><br>
<br>
-- <br>
OpenSim: 10 Region Standalone on 0.7.6 Dev<br>
Physics: Open Dynamics Engine<br>
OS: Windows 7 (x64)<br>
CPU: AMD Phenom II X4 840 3.2 GHz<br>
Memory: 11 GB DDR3<br>
Database: MySQL 5.1.63 (x64)<br>
<br>
_______________________________________________<br>
Opensim-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Opensim-users@lists.berlios.de"
target="_blank">Opensim-users@lists.berlios.de</a><br>
<a moz-do-not-send="true"
href="https://lists.berlios.de/mailman/listinfo/opensim-users"
target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
</font></span></blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">===================================
<div><a moz-do-not-send="true" href="http://osgrid.org/"
target="_blank">http://osgrid.org/</a><br>
<a moz-do-not-send="true" href="http://simhost.com"
target="_blank">http://simhost.com</a><br>
<a moz-do-not-send="true"
href="http://twitter.com/jstallings2" target="_blank">http://twitter.com/jstallings2</a><br>
<br>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a></pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
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)</pre>
</body>
</html>