[Discuss] Migration Environment Survey (host profiling) HOWTO

Wed Jun 15 16:00:41 EDT 2011

On Wed, Jun 15, 2011 at 9:22 AM, Matt Shields <matt-urrlRJtNKRMsHrnhXWJB8w at public.gmane.org> wrote:

>
> 2. Missing quite a few common languages, ie Java.
>
>
agreed

> 3. DotNetNuke is a framework not a language, but for a site survey they
> could add a separate question asking about what frameworks are used.
> PHP - CakePHP, Zend, CodeIgniter...
> Perl - Catalyst...
> Java - Spring, Strusts...
> Python - Django, Pylons, TurboGears...
> .NET - are there any?
>
> I noticed that too.  And you're absolutely right.  If you don't know the
frameworks involved then I think it's going to be risky to do a migration.

I should Google for Data Center Migration Risks to see what I can come up
with in terms of wisdom, best practices etc.

> Another category missing is which application/web servers are used?
> Apache
> Lighttpd
> Nginx
> Tomcat
> GlassFish
> Resin
> .... and the list goes on
>

Yep.

>
> 4. For MySQL you can use the following query
> SELECT CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 /
> 1024),2))," MB") AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA
> like '%YOUR_DB_NAME%' ;
>
> Thanks - worth bookmarking.

> Matthew Shields
> Owner
> BeanTown Host - Web Hosting, Domain Names, Dedicated Servers, Colocation,
> Managed Services
> www.beantownhost.com
> www.sysadminvalley.com
> www.jeeprally.com
>
>
>
>
Matt (or anyone else) if you're interested in providing a quote for our
migration project, please email me off-list

Greg Rundlett
my public PGP key<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5E07A26B877CEBF6>

<div class=3D"gmail_quote">On Wed, Jun 15, 2011 at 9:22 AM, Matt Shields <s=
pan dir=3D"ltr"><<a href=3D"mailto:matt-urrlRJtNKRMsHrnhXWJB8w at public.gmane.org">matt at mattshield=
s.org</a>></span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"m=
argin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class=3D"gmail_quote"><div><div></div><div class=3D"h5"><br></div></di=
v><div>2. Missing quite a few common languages, ie Java.</div><div><br></di=
v></div></blockquote><div><br></div><div>agreed</div><div>=A0</div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex;">
<div class=3D"gmail_quote"><div></div><div>3. DotNetNuke is a framework not=
 a language, but for a site survey they could add a separate question askin=
g about what frameworks are used.=A0</div>
<div>PHP - CakePHP, Zend, CodeIgniter...</div><div>Perl - Catalyst...</div>=
<div>Java - Spring, Strusts...</div><div>Python - Django, Pylons, TurboGear=
s...</div><div>.NET - are there any?</div><div><br></div></div></blockquote=
>
<div>I noticed that too. =A0And you're absolutely right. =A0If you don&=
#39;t know the frameworks involved then I think it's going to be risky =
to do a migration.</div><div><br></div><div>I should Google for Data Center=
 Migration Risks to see what I can come up with in terms of wisdom, best pr=
actices etc.</div>
<div><br></div><div>=A0</div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class=3D"=
gmail_quote"><div></div><div>Another category missing is which application/=
web servers are used?=A0</div>

<div>Apache</div><div>Lighttpd</div><div>Nginx</div><div>Tomcat</div><div>G=
lassFish</div><div>Resin</div><div>.... and the list goes on</div></div></b=
lockquote><div><br></div><div>Yep.=A0</div><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class=3D"gmail_quote"><div><br></div><div>4. For MySQL you can use the=
 following query</div><div>SELECT CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LE=
NGTH - DATA_FREE) / 1024 / 1024),2))," MB") AS Size FROM INFORMAT=
ION_SCHEMA.TABLES where TABLE_SCHEMA like '%YOUR_DB_NAME%' ;</div>

<div><br></div></div></blockquote><div>Thanks - worth bookmarking.</div><di=
v>=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bor=
der-left:1px #ccc solid;padding-left:1ex;"><div class=3D"gmail_quote"><div>=
</div>
Matthew Shields<br>Owner<br>BeanTown Host - Web Hosting, Domain Names, Dedi=
cated Servers, Colocation, Managed Services<br><a href=3D"http://www.beanto=
wnhost.com/" target=3D"_blank">www.beantownhost.com</a><br><a href=3D"http:=
//www.sysadminvalley.com/" target=3D"_blank">www.sysadminvalley.com</a><div=
>

<a href=3D"http://www.jeeprally.com/" target=3D"_blank">www.jeeprally.com</=
a></div><br><br><div>=A0</div></div>
</blockquote></div>Matt (or anyone else) if you're interested in provid=
ing a quote for our migration project, please email me off-list<br><div><me=
ta http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8"><br c=
lear=3D"all">
Greg Rundlett<br><a href=3D"http://pgp.mit.edu:11371/pks/lookup?op=3Dget&am=
p;search=3D0x5E07A26B877CEBF6" target=3D"_blank">my public PGP key</a><br><=
br><br></div>

_______________________________________________
gnhlug-discuss mailing list
gnhlug-discuss-Z8c80N6yweDq5qozqU1N3A at public.gmane.org
http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss/