Product Documentation

Configuring the MySQL and Microsoft SQL Server Version Setting

Aug 31, 2016

You can specify the version of Microsoft® SQL Server® and the MySQL server for a load balancing virtual server that is of type MSSQL and MySQL respectively. The version setting is recommended if you expect some clients to not be running the same version as your MySQL or Microsoft SQL Server product. The version setting provides compatibility between the client-side and server-side connections by ensuring that all communication conforms to the server's version.

To set the Microsoft SQL Server version parameter by using the command line interface

At the command prompt, type the following commands to set the Microsoft SQL Server version parameter for a load balancing virtual server and verify the configuration:

  • set lb vserver <name> -mssqlServerVersion <mssqlServerVersion>
  • show lb vserver <name>

Example

> set lb vserver myMSSQLvip -mssqlServerVersion 2008R2 
 Done 
> show lb vserver myMSSQLvip 
	myMSSQLvip (190.0.2.12:1433) - MSSQL	Type: ADDRESS  
 . . . 
 . . . 
	MSsql Server Version: 2008R2 
	. . . 
	. . . 
 Done 
>

To set the MySQL Server version parameter by using the command line interface

At the command prompt, type the following commands to set the MySQL Server version parameter for a load balancing virtual server and verify the configuration:

  • set lb vserver <name> -mysqlServerVersion <string>
  • show lb vserver <name>

Example

> set lb vserver mysqlsvr -mysqlserverversion 5.5.30 
 Done 
> sh lb vserver mysqlsvr 
	 mysqlsvr (2.22.2.222:3306) - MYSQL      Type: ADDRESS 
 . . . 
 . . . 
	 Mysql Server Version: 5.5.30 
	. . . 
	. . . 
 Done 
>

To set the MySQL or Microsoft SQL Server version parameter by using the configuration utility

  1. Navigate to Traffic Management > Load Balancing > Virtual Servers.
  2. Open a virtual server of type MySQL or MSSQL, and set the server version.