<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hello all,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have some upcoming work that in light of lack of specific documentation to my questions, I figured I would ask the list.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>First and foremost, I have a server migration planned in the next few weeks where we’ve moving off an old metal box to a VM. We’re currently running RT ver. 4.0.9 <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Moving from CentOS 4.3 w/ <o:p></o:p></p><p class=MsoNormal>MySQL 5.0.x<o:p></o:p></p><p class=MsoNormal>Apache 2.0.x<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>CentOS 6.6<o:p></o:p></p><p class=MsoNormal>MariaDB 5.5<o:p></o:p></p><p class=MsoNormal>Apache 2.2.15<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Both 64 bit.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>In all the reading the areas of which I need to migrate are:<o:p></o:p></p><p class=MsoNormal>MySQL Database<o:p></o:p></p><p class=MsoNormal>/opt/rt4/<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m now the 2<sup>nd</sup> or 3<sup>rd</sup> gen DevOPs person to touch this server so I can’t wait for things to go sideways… yeah. That said, I’ve tried to keep up on the mailing lists but have there been any horror stories going from MySQL to MariaDB? The first part of the migration is simply a 1-to-1 move where I am not upgrading the database nor the version. This will make sure everything is migrated properly and all the kinks (if any) are worked out prior to moving up to the latest release 4.2.11. As for moving them, I’ve already got a script that provides me a MySQL dump and a TAR of the web directories so I should be set with that.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The second part of my question; To help better maintain the site, I am wanting a development box to test new features and add-ons once we get upgraded. One of the things that I’m running into is the naming. Right now our RT server is listed as: “rt.domain.com” and my development box I want to have “devrt.domain.com” Is there / does anyone have a SED script to go in and change all the variables of “rt.domain.com” to “devrt.domain.com”? If not, is there an easier way to have a version of your production database on another box and easily deal with a different DNS name for the server?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thank you for your time.<o:p></o:p></p><p class=MsoNormal>=Aaron<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:#1F497D'><img width=151 height=58 id="Picture_x0020_1" src="cid:image003.jpg@01D0CA66.570EB140"><o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:9.0pt;color:#1F497D'>Aaron Hockett</span></b><b><span style='font-size:9.0pt;color:gray'>|</span></b><span style='font-size:9.0pt;color:gray'> Network Operations<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;color:#7F7F7F'>NOC: (866) 366-2638 Opt 1, Opt 1 <b>| </b>Fax</span><span style='font-size:9.0pt;color:gray'> (</span><span lang=DE style='font-size:9.0pt;color:gray'>503) 227-8585</span><span style='font-size:9.0pt;color:gray'><br>LS Networks <b>|</b> 921 SW Washington Street <b>|</b> Suite 370 <b>|</b> Portland, OR 97205<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'><a href="mailto:ahockett@lsnetworks.net"><span style='color:blue'>ahockett@lsnetworks.net</span></a> | <a href="http://www.lsnetworks.net/"><span style='color:blue'>www.lsnetworks.net</span></a> </span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>