SQL node-opracowanie

Nasza ocena:

3
Wyświetleń: 560
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
SQL node-opracowanie - strona 1 SQL node-opracowanie - strona 2

Fragment notatki:

SQL node. We assume that you have placed a copy of the no-install archive in the directory
C:\Documents and Settings\username\My Documents\Downloads on the computer having
the IP address 192.168.0.20, where username is the name of the current user. (You can obtain this
name using ECHO %USERNAME% on the command line.) To install and run MySQL Cluster executables
as Windows services, this user should be a member of the Administrators group.
Extract all the files from the archive. The Extraction Wizard integrated with Windows Explorer is
adequate for this task. (If you use a different archive program, be sure that it extracts all files and
directories from the archive, and that it preserves the archive's directory structure.) When you are
asked for a destination directory, enter C:\, which causes the Extraction Wizard to extract the archive
to the directory C:\mysql-cluster-gpl-noinstall-ver-winarch. Rename this directory to C:
\mysql.
It is possible to install the MySQL Cluster binaries to directories other than C:\mysql\bin; however, if
you do so, you must modify the paths shown in this procedure accordingly. In particular, if the MySQL
Server (SQL node) binary is installed to a location other than C:\mysql or C:\Program Files
\MySQL\MySQL Server 5.6, or if the SQL node's data directory is in a location other than C:
\mysql\data or C:\Program Files\MySQL\MySQL Server 5.6\data, extra configuration
options must be used on the command line or added to the my.ini or my.cnf file when starting the
SQL node. For more information about configuring a MySQL Server to run in a nonstandard location,
see Section 2.3.5, “Installing MySQL on Microsoft Windows Using a noinstall Zip Archive”.
For a MySQL Server with MySQL Cluster support to run as part of a MySQL Cluster, it must be started
with the options --ndbcluster [2296] and --ndb-connectstring [2295]. While you can specify
these options on the command line, it is usually more convenient to place them in an option file.
To do this, create a new text file in Notepad or another text editor. Enter the following configuration
information into this file:
[mysqld]
# Options for mysqld process:
ndbcluster # run NDB storage engine
ndb-connectstring=192.168.0.10 # location of management server
You can add other options used by this MySQL Server if desired (see Section 2.3.5.2, “Creating an
Option File”), but the file must contain the options shown, at a minimum. Save this file as C:\mysql
\my.ini. This completes the installation and setup for the SQL node.
... zobacz całą notatkę



Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz