This month my host company will upgrade mysql database to version 5 and make PHP5 part of the standard working environment. I’m not expecting any kind of problems for now. Maybe a little downtime while they are doing geek stuff with the database.
Until now, I didn't heard that anyone had troubles with ExpressionEngine. They sad he works only faster after upgrading. We'll see.