This article applies to customers looking to undertake multi user deployments of Mimecast for Outlook which require a SQL database. MySQL Community Server provides a cost effective database platform for use with multi user installations of Mimecast for Outlook. This is especially so where customers would otherwise not have cause to use Microsoft SQL Server.
What You'll Need
- Mimecast for Outlook
- Mimecast for Outlook Configuration Tool
- MySQL Installer - Community Server 5.6.21 or higher
- MySQL Workbench 6.2 CE
- MySQL Connector/Net connector configured for .NET or Windows on both the client machine and server.
The MySQL Community Server connector must be configured prior to installing Mimecast for Outlook. Mimecast is not able to distribute this with the add-in.
When installing MySQL Community Server, consider the following points:
- Choose a suitable server on which to install MySQL Server.
- If the host is dedicated to running MySQL Community Server, select Dedicated Machine as the Config Type (Recommended option). Alternatively select the Server Machine option as the Config Type, where MySQL Server is expected to co-exist with server applications on the same host.
- Ensure the root password at the time of configuring adheres to your organizations password policy. The root password should to be stored in a secure location, and will be required to create the Database Login and Database for the Mimecast for Outlook Add-in later on.
Step 1: Installing MySQL Community Server
To install MySQL Community Server:
- Download and install MySQL Server as instructed. Use the relevant instructions relating to your specific version of MySQL.
Step 2: Configuring MySQL for Client Connections
Once MySQL Server has been successfully installed, you will need to configure MySQL Server to allow client connections from the network. By default MySQL Server will only allow local connections (i.e. connections originating from the local machine).
To configure MySQL for client connctions:
- Install MySQL Workbench.
- Connect to your local instance of MySQL Server.
- Click on the Server | User Privileges menu item.
- Click on the Add Account button.
- Complete the dialog as follows:
Field / Option Value Login Name Root Limit to Host Matching % Password Root password Confirm Password Root Password
- Click the Apply button.
- Close MySQL Workbench.
At this point you should now have a successful installation of MySQL Community Server, which is also accessible from your internal network.
Step 3: Configuring Mimecast for Outlook
To configure Mimecast for Outlook:
- Download and open the Mimecast for Outlook Configuration Tool.
- Click the File | Open menu item and load the Mimecast for Outlook installation MSI.
- Navigate to the SQL Settings section of the tool.
- Select the Override and Customize SQL Settings.
- Change the Database Provider drop down to MySQL.
- Select the Browse button.
- Navigate to and select the MySQL Database Connector.
- Customize the Mimecast for Outlook installer as required.
- Click the File | Save As menu item to save the customized package.
Step 4: Deploying the Mimecast for Outlook clients to use MySQL Community Server
To deploy the Mimecast for Outlook clients:
- Deploy the customized installer for Mimecast for Outlook, created in Step 3, using your preferred deployment technology.
- Test that data is populated into the database when client machines connect.
- Open MySQL Workbench.
- Select the relevant Schema.
- Query the useroption table and validate that the table contains data.
From v6.0 onwards, database upgrades are now handled automatically. Customers should use the SQL Settings area of the Config Tool to connect to their database and create a custom MSI.