mysql-service.properties

jdbcPort=3306

win64 {	
    mysqlHome="mysql-5.5.24-winx64"
	mysqlD="mysqld.exe"
	mysqlProgram="mysql.exe"
	mysqladmin="mysqladmin.exe"
	mysqldump="mysqldump.exe"
	zipName="${mysqlHome}.zip"
	/* http://downloads.skysql.com/archive/index/p/mysql/v/5.5.24 */
	zipURL="http://downloads.skysql.com/archives/mysql-5.5/${zipName}"
}

linux {	
	mysqlD="mysqld"
	mysqlProgram="mysql"
	mysqladmin="mysqladmin"
	mysqldump="mysqldump"
}



dbName="tamirDB"
dbUser="tamir" 
dbPassW="1234"


/* Use the following format - leave an empty string (startDetectionQuery="") for using the default startDetection ( by port )  : 
 startDetectionQuery="select count(XXX) as cc from table_name" 
*/
startDetectionQuery=""

	
/* 
   actionType can be one of the four following: mysqladmin,mysql,mysqldump or import
   Examples :
   
   // In this case, dbName is a property which is defined in this properties file
   // All the occurrences of MYSQLHOST in actionQuery, will be replaced with the private IP address on which this service instance resides
   [  
		"actionType" : "mysqladmin", 
		"actionQuery" : "create" ,
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Creating db - Name  : ${dbName} ... "
	] ,
	
	
	// In this case, dbUser and dbPassW are properties which are defined in this properties file 
    // All the occurrences of MYSQLHOST in actionQuery, will be replaced with the private IP address on which this service instance resides	
	[ 
		"actionType" : "mysql", 		
		"actionQuery" : "\"CREATE USER '${dbUser}'@'localhost' IDENTIFIED BY '${dbPassW}';\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Creating db user ${dbUser} at localhost, passw ${dbPassW} in ${dbName} db... " 
	],
   
   // In this case:
   //    dbName,currDBZip,currImportSql are properties which are defined in this properties file 
   //    currDBZip is the local name of the zip file ( after download )  
   //    currImportSql is the name of the sql file which is stored in currDBZip. 
   //     All the occurrences of REPLACE_WITH_DB_NAME in currImportSql, will be replaced with ${dbName}
   [ 
		"actionType" : "import", 
		"importedZip" : "${currDBZip}",
		"importedFile" : "${currImportSql}",
		"importedFileUrl" : "http://dropbox/1/222/mysql.zip",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Importing  to ${dbName} ..."
	]	
	
   // In this case:
   //    dbName is a property which is defined in this properties file.
   //    if actionDbName is an empty string,  then --all-databases will be used
   //    actionArgs contain the flags that you want to use with this mysqldump command
   //    Do NOT database flags, because they will be set according to the actionDbName.
   //    So do NOT use the following  : --all-databases,-A,--databases, -B
   //    Do NOT -u flag flags, because it will be set according to the actionUser
   [ 
		"actionType" : "mysqldump", 
		"actionArgs" : "--add-drop-database -c --lock-all-tables -F",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"dumpPrefix" : "myDumpFile_",
		"debugMsg" : "Invoking mysqldump ..." 
	]		
   
*/	
postStartActions  = [
	[  
		"actionType" : "mysqladmin", 
		"actionQuery" : "create" ,
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Creating db - Name  : ${dbName} ... "
	],
	
	[ 
		"actionType" : "mysql", 		
		"actionQuery" : "\"CREATE USER '${dbUser}'@'localhost' IDENTIFIED BY '${dbPassW}';\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Creating db user ${dbUser} at localhost, passw ${dbPassW} in ${dbName} db... " 
	],
	
	[ 
		"actionType" : "mysql", 		
		"actionQuery" : "\"CREATE USER '${dbUser}'@'MYSQLHOST' IDENTIFIED BY '${dbPassW}';\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Creating db user ${dbUser} at MYSQLHOST, passw ${dbPassW} in ${dbName} db... " 
	],	
	
	
	[ 
		"actionType" : "mysql", 		
		"actionQuery" : "\"CREATE USER '${dbUser}'@'%' IDENTIFIED BY '${dbPassW}';\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Creating db user ${dbUser} at all hosts, passw ${dbPassW} in ${dbName} db... " 
	],

	
	[ 
		"actionType" : "mysql", 
		"actionQuery" : "\"grant usage on *.* to ${dbUser}@localhost identified by '${dbPassW}';\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Granting usage to user ${dbUser} at localhost, passw ${dbPassW} in ${dbName} db..."
	],

	[ 
		"actionType" : "mysql", 
		"actionQuery" : "\"grant usage on *.* to ${dbUser}@MYSQLHOST identified by '${dbPassW}';\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Granting usage to user ${dbUser} at MYSQLHOST, passw ${dbPassW} in ${dbName} db..."
	],		
	
	[ 
		"actionType" : "mysql", 
		"actionQuery" : "\"grant usage on *.* to ${dbUser}@'%' identified by '${dbPassW}';\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Granting usage to user ${dbUser} at all hosts, passw ${dbPassW} in ${dbName} db..."
	],		
	  

	[ 
		"actionType" : "mysql", 
		"actionQuery" : "\"grant all privileges on *.* to ${dbUser}@'localhost' with grant option;\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Granting all privileges to user ${dbUser} in ${dbName} db at localhost... "
	],	

	[ 
		"actionType" : "mysql", 
		"actionQuery" : "\"grant all privileges on *.* to ${dbUser}@'MYSQLHOST' with grant option;\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Granting all privileges to user ${dbUser} in ${dbName} db at MYSQLHOST... "
	],		
			
	[ 
		"actionType" : "mysql", 
		"actionQuery" : "\"grant all privileges on *.* to ${dbUser}@'%' with grant option;\"",
		"actionUser"  : "root",
		"actionDbName" : "${dbName}",
		"debugMsg" : "Granting all privileges to user ${dbUser} in ${dbName} db at all hosts ... "
	]
	
]