<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">I gotcha. Extended testing is a go :)
Thanks for the tips and help!<br>
<br>
On 3/1/2014 9:05 AM, James Stallings II wrote:<br>
</div>
<blockquote
cite="mid:CAOaG_2YkCs0mHz0aOZ-v0jwmKxwUhWp6NfLdJS9tLLc4Kj5USw@mail.gmail.com"
type="cite">
<p dir="ltr">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 <br>
</p>
<div class="gmail_quot<blockquote class=" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>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 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><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></fieldset>
<br>
<pre>_______________________________________________
Opensim-users mailing list
<a moz-do-not-send="true" href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a>
<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></pre>
</blockquote>
<br>
<br>
<pre 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>
</div>
<br>
_______________________________________________<br>
Opensim-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Opensim-users@lists.berlios.de">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>
</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>