Looking into running multiple instances of MySQL and wondering if the mysql database (which stores the information_schema table) is the same for all instances or if they would all have their own.
I'm assuming it's the latter, but wanted to check (means rewriting a backup script if that's the case).
You'll have separate data files (including the MySQL db) for each instance.
When creating additional instances you need to assign them their own distinct data directory and either copy the data files from the original instance or, preferably, use mysql_install_db to initialize the necessary files.
A quick and dirty list of steps can be found here, though the author doesn't really discuss creating the start/stop scripts in /etc/init.d, which are discussed here.
