[rt-devel] Migration to rt3 ... final episode

[Jim Rowan]

My suggestions:

You are aware of the issues around Apache2/mod_perl2/RH9, right?

Do the evaluation before your production switch, not during.  Sounds
like you have a big installation and you want to minimize down time.
You are taking on more risk this way as well.  (What happens if you get
stuck?)

If performance matters enough to do a test, do a fair comparison.  That
means two installs on the same hardware.  That also means taking the
time to tune both databases.  Neither one is appropriately tuned out of
the box.  I know that postgres performance can increase significantly; I
suspect mysql can also.

You might want to throw more than just performance into your database
evaluation.  Do you have equivalent expertise in both?  Do you have
other database instances already?  Do you believe them both to be equal
in terms of features that matter?  Equal quality?

If you have both machines at your disposal, consider (strongly) the
option of using both in production; one as a dedicated database machine
and one as the web server.  Make the bigger one the database server; the
more memory you can give it the faster the overall system will be.  512
is almost certainly not enough.  I think I would put the gig of memory
in the quad machine and make it the db server...