Setting up MySQL on Windows as Backend Database

• Overview
• Install and configuring MySQL Server
• Troubleshooting tips

Overview

uses MySQL as the backend database in Backup Server and Replication Server installations to store all the backup metadata information. To get to work with MySQL as a backend database, you need to install MySQL Server either in the same machine where backup server is installed or in another dedicated machine.

Note : The following steps are applicable to Backup Server and Replication Server installations.

Installing and Configuring MySQL Server on Windows

provides you an utility to install and customize the MySQL Server components for backend. This utility will download, install and customizes the MySQL Server v5.5.20, MySQL ODBC Driver v3.51.27 components, creates database and system DSNs for . Since this utility downloads MySQL Server components from Internet, the backup/replication server should have Internet connectivity. This utility is typically available from the same source from where you downloaded the builds.

1. Download Online MySQL Components installer. The installer is typically available in the same source location from where the other builds you downloaded from.


2. Run the downloaded installer file.


3. In the MySQL Server Configuration wizard page, provide valid values for Port Number, MySQL Server root password, installation and database storage location.
   

   NOTE: 's metadata stored in the MySQL databases could use up certain amount of space. To give a rough estimation of the usage, if the backup server stores 1 million backed up files, then the MySQL DB could be of size 1.5 GB. For this disk size estimation, each version file is also considered as a separate file. Therefore, for example, if a client is backing up 1 million files and for each file there are 3 versions stored in the backup server then there will be 3 million backed up files for that client machine. For these 3 million backed up files, the MySQL DB size could be about 4.5 GB. Please make sure that you have enough space in this location for all future backups from all the client machines. As MySQL Server runs as a Windows service, this location should be in local fixed disk drive.



4. If MySQL Server (of same version) is already installed in the system, this utility will show the previous MySQL Server installation details. You can continue the installation by clicking Next button.
   

   IMPORTANT NOTE: is well tested with MySQL Server v5.5.20 & MySQL ODBC driver v3.51.27 only. If you had already installed different MySQL Server and/or MySQL ODBC driver in the server system, we recommend you to install this MySQL Server components in different machine and configure to access MySQL Server from that system.



5. Click on the Next button to start download, install and customize the MySQL Server components. Following are the default MySQL Server components settings created by this utility:
   
   • MySQL Server Instance Name: SGMySQL55
   • MySQL Server Port Number: User Value [default: 3306]
   • MySQL Server Installation Path: User Value [default: C:\Program Files\MySQL\MySQL Server 5.5\]
   • MySQL Server Data Path: User Value [default: C:\Program Files\MySQL\MySQL Server 5.5\Data]
   • MySQL Server Database Name: SGDatabase
   • MySQL Server DSN Name: SGDBConnection
   • MySQL Server Root User Name: root
   • MySQL Server Root User Password: User Value [default: admin]

Specify the attributes during installation

After installing MySQL Server components in the backup/replication server, you need to specify the above values during the installation in the backup/replication server.

Troubleshooting Tips

	is not started (or) repeatedly crashes after startup
Solution : Stop application and start in command line by executing 'bin\.exe' from [_Home] folder. Note the console print from the terminal. Please follow the solutions when the console print are as follows : Can't connect to local MySQL server... Make sure that the MySQL server is running in the machine where MySQL is installed. Execute 'netstat -an | grep 3306' (for linux) or 'netstat -an | find "3306"' (for Windows) in the machine where MySQL server is running and check if the MySQL port 3306 (default mysql port) is in LISTEN state. If MySQL is not running, please start the MySQL Server and then try starting . Data source name not found... Make sure that you have given the correct DSN name during the installation. Open up the "Control Panel -> Administrative Tools -> DataSources (ODBC)" tool. Go to the tab 'System DSN' and select the Data Source Name. Click on the 'Configure' button. Click on the 'Test' button. If there is any problem click on 'Diagnostics' button to get the exact error message. Access denied for user... Check if you have given the correct user name and password for the MySQL Server during installation. Open up the "Control Panel -> Administrative Tools -> DataSources (ODBC)" tool. Go to the tab 'System DSN' and select the Data Source Name. Click on the 'Configure' button. Click on the 'Test' button. If there is any problem click on 'Diagnostics' button to get the exact error message. Host 'xxxxx' is not allowed to connect to this MySQL server... Provide the required permission in the MySQL to allow the backup server to connect the database. You can do this by executing 'GRANT ALL PRIVILEGES ON *.* TO '[user name]'@'[backup server machine name]' IDENTIFIED BY '[password]' WITH GRANT OPTION;' in the MySQL prompt in the machine where MySQL Server is installed. NOTE: If you are deploying the backup servers in a cluster, you need to execute the above command for each of the backup server in the cluster replacing the 'backup server machine name' with the machine name of the backup server. If you find it cumbersome to execute this for each backup server, you could replace the 'backup server machine name' with '%' like: 'GRANT ALL PRIVILEGES ON *.* TO '[user name]'@'%' IDENTIFIED BY '[password]' WITH GRANT OPTION;'