The MySQL library is not scheduled to be removed till PHP v6. even once PHP v6 is released, your scripts will probably still work, the host will probably not upgrade the server PHP version for some time.
Most hosts also offer an option to use an older PHP version if you ask, In 1 & 1 for example, there is a control panel option to use php v4.2 or use the Current PHP v5