Update ignore_dbs for MySQL 5.6

'lost+found' directories are no longer needed in the ignored list.
Include 'performance_schema' system database (by default ON in >=5.6.6).
Set 'performance_schema = ON' in default Trove configuration template and
add a validation rule for it so that users can turn it OFF if they so
desire.

Change-Id: Iecc114594091eabf8a0664e066b9de22f95d1e81
Closes-Bug: 1486721
Related-Bug: 1370646

apidocs/src/samples/db-get-default-instance-configuration-response-json.txt

@@ -1,5 +1,5 @@
 HTTP/1.1 200 OK
 Content-Type: application/json
-Content-Length: 1082
+Content-Length: 1110
 Date: Mon, 18 Mar 2013 19:09:17 GMT
 

apidocs/src/samples/db-get-default-instance-configuration-response.json

@@ -37,7 +37,8 @@
             "tmp_table_size": "16M",
             "tmpdir": "/var/tmp",
             "user": "mysql",
-            "wait_timeout": "120"
+            "wait_timeout": "120",
+            "performance_schema": "ON"
         }
     }
 }

trove/common/cfg.py

@@ -130,8 +130,7 @@ common_opts = [
     cfg.ListOpt('ignore_users', default=['os_admin', 'root'],
                 help='Users to exclude when listing users.'),
     cfg.ListOpt('ignore_dbs',
-                default=['lost+found', '#mysql50#lost+found', 'mysql',
-                         'information_schema'],
+                default=['mysql', 'information_schema', 'performance_schema'],
                 help='Databases to exclude when listing databases.'),
     cfg.IntOpt('agent_call_low_timeout', default=5,
                help="Maximum time (in seconds) to wait for Guest Agent 'quick'"

trove/templates/mysql/config.template

@@ -43,6 +43,7 @@ max_connections = {{ (100 * flavor['ram']/512)|int }}
 default_storage_engine = innodb
 local-infile = 0
 server_id = {{server_id}}
+performance_schema = ON
 
 [mysqldump]
 quick = 1

trove/templates/mysql/validation-rules.json

@@ -226,6 +226,11 @@
             "name": "collation_server",
             "restart_required": false,
             "type": "string"
+        },
+        {
+            "name": "performance_schema",
+            "restart_required": true,
+            "type": "boolean"
         }
     ]
 }