Sun Systems engineers describe deploying the MySQL 5.1 RDBMS on a Sun Fire server running Microsoft Windows 2003 Server in a BigAdmin article entitled "MySQL 5.1 Database Deployment over CIFS on Sun Storage 7000 Unified Storage System". In the presented scenario, a volume of a Sun Storage 7000 Unified Storage System is mounted using CIFS as a repository for database files. Specifically, a Sun Storage 7210 was deployed, but the procedures presented can be applied to any of the products in the Sun Storage 7000 Unified Storage System family.

This is a technical paper and meant for those with an understanding of Microsoft Windows and MySQL. Screenshots are provided throughout for an easy understanding of the procedure.

Specific topics covered in the paper:

METHODOLOGY

Hardware and Software Components

Microsoft Windows 2003 Server

• Server Hardware: Sun Fire X4200 server with 2x AMD Opteron 252, 2.59 GHz processor and 4.8 Gbyte RAM
• Software: Microsoft Windows Server 2003 Enterprise x64 Edition, Service Pack 1; MySQL v5.1.29 Release Candidate Release. The installation was performed with the content of the archive mysql-5.1.29-rc-winx64.zip

Sun Storage 7000 Unified Storage System

• 2x AMD64 Opteron Quad-core CPU, 2.14 GHz
• 32 Gbyte RAM
• Sun Storage 7000 Unified Storage System version 2008.10
• One ZFS storage pool with a mirrored capacity of 4.6 Tbyte was created from 42x 250 Gbyte SATA disks on the Sun Storage 7210 Unified Storage System and used for the tests described in this paper.
• One 17 Gbyte SSD drive served as a write-optimized device of the Sun Storage 7210 Unified Storage System.

PREPARATION

Sun Storage 7210 Unified Storage System: Allocation of Storage Resources

This includes:

-1) Making the Sun Storage 7210 Unified Storage System a member of an Active Directory domain. -2) Creating a project. -3) Creating one volume that is published using CIFS. -4) Starting the CIFS service.

• Microsoft Windows Server: Granting Privileges for the Service Account

INSTALLATION OF THE MYSQL RDBMS SOFTWARE

• Installing the MySQL Software
• Configuring the MySQL Server Using the Instance Configuration Wizard
• Configuring MySQL Server to Use a CIFS Share for Database Files

More Information

Sun Storage 7000 Unified Storage System

MySQL [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter