Weakly Compressible Magnetohydrodynamic Turbulence in the Solar Wind and the Interstellar Medium