As Puppet is basically a configuration manager, settings should be passed to the the module you are using. ie this https://forge.puppetlabs.com/puppetlabs/mysql shows a bunch of usages.

I've created a simple project that shows (could it be part of brooklyn-examples, maybe) the shows the different approaches using different provisioners. Please have a look at latest 
https://github.com/andreaturli/brooklyn-provisioners/blob/master/src/main/java/io/brooklyn/puppet/entities/MySqlPuppetSshDriver.java

is that what you mean, @ahgittin ?