Download Creator (Creation Date)

How to Configure a Remote MySQL Database
This page last changed on Apr 03, 2009 by stephanielewellen.
How to Configure a Remote MySQL Database
As an alternative to the VDI MySQL Cluster database, it is possible to use a remote MySQL database. This needs to be a
MySQL version 5.0 (or higher) or a MySQL Cluster version 6.2.15 (or higher). You can use either the 32-bit or the 64-bit
version. It is important that a transactional storage engine is available, which will usually be InnoDB or NDB.
VDI MySQL Cluster database vs. Remote MySQL Database
Sun VDI allows you to either make use of the MySQL Cluster database that is bundle with the software or
is able to integrate into an existing MySQL database. The first option requires almost no knowledge of SQL
databases in general and MySQL in particular. It is well suited for small to medium deployments. For larger
deployments, if a MySQL database exist already or if specific security related requirements exist choosing
the remote MySQL database option more likely the right choice. Find details on the remote database
configuration below.
Steps
1. Configure the Primary Sun VDI Host.
a. See Configure the Primary Sun VDI Host Steps 1-3 above.
b. Choose 2 Remote Database.
i. Specify the DNS name of your MySQL server.
ii. Specify the port on which your MySQL server is listening.
iii. Specify a privileged database administrator. This user needs to have the privileges to create databases
and add users. If you do not have such a user yet follow the instructions below How to Create a
Privileged Database User in order to add one.
iv. Specify the password for the database administrator that you have specified.
v. Specify whether you want to connect to your MySQL server via SSL or not.
vi. Specify the name of the VDI database that will be created or just accept the default 'vda'.
vii. Specify the name of a user that will be associated with and used to access the VDI database. Alternatively
you can simply accept the default 'vdadb'.
viii. Specify a password for the VDI database user.
2. Configure the Secondary Sun VDI Hosts.
a. Follow Configure the Secondary Sun VDI Hosts Steps 1-5 above.
b. Choose 2 Remote Database.
i. Specify the DNS name of your MySQL server.
ii. Specify the port on which your MySQL server is listening.
iii. Specify whether you want to connect to your MySQL server via SSL or not.
iv. Specify the name of your VDI database which has been specified when configuring your Primary Sun VDI
host.
v. Specify the name of the user that has access to the VDI database. This is the user you have specified
when configuring your Primary Sun VDI host (the default is 'vdadb').
vi. Specify the password for your VDI database user.
• How to Create a Privileged Database User
You may want to set up a privileged database user who has, among other things, the privileges to create databases
and other users.
Use the 'mysql' command line tool to enter the mysql interactive mode as root. Then execute the following
statements (replace '<user>' and '<password>' accordingly):
GRANT ALL PRIVILEGES ON *.* TO '<user>'@'localhost' IDENTIFIED BY '<password>' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO '<user>'@'%' IDENTIFIED BY '<password>' WITH GRANT OPTION;
For more information, follow the instructions outlined by MySQL in Adding New User Accounts to MySQL.
Document generated by Confluence on Jun 24, 2009 06:55
Page 38