in reply to substitution using perl -pi -e

Indeed /e executes in the replacement part of the s/// operator. Do you happen to know that

site.type=production;

is valid Perl (5, that is!) code? How so?!?

Incidentally you may use

s/(?<=site.type=)standby/production/gi

instead.