Let me know if you have any questions or if this helps you! Also, if you're a ruby programmer, you might want to take a look at my providers... They're slightly messy, I think. They work, though.
The main difference between the old package and the debian specific ones is that my types always use Debian's /etc/mysql/debian.cnf as a defaults file. This file is created when you install mysql from the Debian repository and is mainly used for maintenance. So ideal for puppet usage.