I have a django project which when deployed provides mysql-nss services. This dule use database setup requires automatic deployment by any basic server user. The first part is the creation of an sql database on localhost, followed by the configuration of mysql-nss for the server.
Each client machine that wants to authentication then requires not just pointing at the new server's mysql database, but a very specific list of SQL commands which access the data. This specify leads me to believe that the server and client setups should be packaged for deployment.
Should I use JuJu charms for server/client, should I use Debian packages to set everything just so, including over-riding the mysql-nss-bg package's config files. Or should I force users to learn pupper or similar technology to manage their clients and simply just provide a template config with the required sql commands?
The least complex, most secure solution is preferable.