Cg_pham at 08:53, 6 February 2012

2012-02-06T08:53:03Z

Cg_pham at 08:52, 6 February 2012

2012-02-06T08:52:05Z

← Older revision		Revision as of 08:52, 6 February 2012
Line 1:		Line 1:
	{{HelpFiles_Deployment}}		{{HelpFiles_Deployment}}
	[[Category:~~Server installation prerequisites~~]]		[[Category:Category:1._Server_installation_prerequisites]]


	===MySQL database installation guide===		==MySQL database installation guide==

	==MySql distribution to install==		===MySql distribution to install===

	Version 5.0		Version 5.0

Cg_pham at 08:51, 6 February 2012

2012-02-06T08:51:06Z

← Older revision		Revision as of 08:51, 6 February 2012
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		{{HelpFiles_Deployment}}
			[[Category:Server installation prerequisites]]

Catglobe: jrfconvert import

2011-03-07T08:59:03Z

jrfconvert import

New page

[[Category:HelpBooks]]

===MySQL database installation guide===

==MySql distribution to install==

Version 5.0

==How to get MySql==

http://dev.mysql.com/downloads/mysql/5.0.html

==Installing MySql on Windows==

Installation Package : indows (x86) ZIP/Setup.exe

Install MySql with the Automated Installer : Unzip the package, and run setup.exe file

Installation Steps : After double clicking the setup file, the Setup Wizard is started. Click Next button to start on Step 1.

[[Image:2780.png]]

Step 1 - Choose the setup type

Click Custom radio button in order to select the needed features to install. Click Next button to go to step 2.

[[Image:2782.png]]

Step 2 - Custom Setup

Click Developer Components button and choose This feature will not be available to have developer components not to be installed.

[[Image:2784.png]]

Click Change… button to modify the location for installing MySql (if necessary). Click Next button to go to Step 3

[[Image:2786.png]]

Step 3 - Install the program

Read the current settings summary before starting to install. Click Install button to start installing.

[[Image:2787.png]]

The installation progress is shown.

[[Image:2788.png]]

At the final step of the installation progress, you are asked to sign up to MySql.com.

[[Image:2789.png]]

Finalizing the wizard

Check Configure the MySql Server now checkbox to start configuration wizard or uncheck to start it later.

[[Image:2790.png]]

==Configuration Wizard==

Click Next button to go to Step 1.

[[Image:2791.png]]

Step 1 - Select configuration type

Click Detailed Configuration radio button and press Next button to go to step 2.

[[Image:2792.png]]

Step 2 – Select a server type

Click Server Machine radio button to have server applications to run on the current machine. Press Next button to go to Step 3.

[[Image:2793.png]]

Step 3 – Select database usage

Click Non – Transactional Database Only radio button to activate only the non – transaction MyISAM storage engine. Press Next button to go to Step 4.

[[Image:2795.png]]

Step 4 – Number of concurrent connections

Click Manual Setting radio button and set the approximate number of concurrent connections to the server to 100. Click Next to go to Step 5.

[[Image:2796.jpg]]

Step 5 - Enable TCP/IP Networking and Strict mode

[[Image:2797.jpg]]

Step 6 - Set the default character set

[[Image:2798.jpg]]

Step 7 - Set the Windows options

Check Install As Windows Service checkbox and change the service name (if necessary).

Check Launch the MySql Server automatically checkbox.

Check Include Bin Directory in Windows PATH checkbox in order to be able to access MySql via the command line.

[[Image:2799.jpg]]

Step 8 - Set the security options

It is very important to check Enable root access from remote machines checkbox in order to make the Data Cache Specification module work.

[[Image:2800.jpg]]

Finalizing steps

[[Image:2801.png]]

[[Image:2802.png]]

==System variables settings==

File to modify

§ …\MySQL\MySQL Server 5.0\my.ini

§ (C:\Program Files\MySQL\MySQL Server 5.0\my.ini if you have not changed the default directory for installing MySql)

System variables

§ query_cache_size=0M

§ max_connections = 100

§ table_cache = 256

§ tmp_table_size = 100MB

§ myisam_sort_buffer_size=5MB

§ key_buffer_size = 100MB

After changing any system variables, restart MySql service.

==Disk issues==

Data directory should be on a fast drive.

System variable to modify

§ datadir="…/Data/"

Before modifying the value of datadir, stop MySql service.

After setting the datadir system variable to a different place, move the Data subfolder (…\MySQL\MySQL Server 5.0\data) to that location and then restart the service.
__NOTOC__

MySQL database installation guide - Revision history

Cg_pham at 08:53, 6 February 2012

Cg_pham at 08:52, 6 February 2012

Cg_pham at 08:51, 6 February 2012

Catglobe: jrfconvert import