MySQL Cluster Installation and Upgrades
1530
Multiple data node processes.
While it is possible to run multiple cluster processes concurrently
on a single host, it is not always advisable to do so for reasons of performance and high availability,
as well as other considerations. In particular, in MySQL 5.0, we do not support for production use any
MySQL Cluster deployment in which more than one
ndbd
process is run on a single physical machine.
Note
We may support multiple data nodes per host in a future MySQL release,
following additional testing. However, in MySQL 5.0, such configurations can be
considered experimental only.
Multiple network addresses.
Multiple network addresses per data node are not supported.
Use of these is liable to cause problems: In the event of a data node failure, an SQL node waits for
confirmation that the data node went down but never receives it because another route to that data
node remains open. This can effectively make the cluster inoperable.
Note
It is possible to use multiple network hardware interfaces (such as Ethernet
cards) for a single data node, but these must be bound to the same address.
This also means that it not possible to use more than one
[tcp]
section per
connection in the
config.ini
file. See
Section 17.3.2.7, “MySQL Cluster TCP/
IP Connections”
, for more information.
17.1.5.10. Previous MySQL Cluster Issues Resolved in MySQL 5.0
The following Cluster limitations in MySQL 4.1 have been resolved in MySQL 5.0 as shown below:
• Character set support.
The
NDBCLUSTER
storage engine supports all character sets and
collations available in MySQL 5.0.
• Character set directory.
Beginning with MySQL 5.0.21, it is possible to install MySQL with
Cluster support to a nondefault location and change the search path for font description files using
either the
--basedir
[401]
or
--character-sets-dir
[402]
options. (Previously,
ndbd
in
MySQL 5.0 searched only the default path—typically
/usr/local/mysql/share/mysql/
charsets
—for character sets.)
• Metadata objects.
Prior to MySQL 5.0.6, the maximum number of metadata objects possible was
1600. Beginning with MySQL 5.0.6, this limit is increased to 20320.
• Query cache.
Unlike the case in MySQL 4.1, the Cluster storage engine in MySQL 5.0 supports
MySQL's query cache. See
Section 8.6.3, “The MySQL Query Cache”
.
•
IGNORE
and
REPLACE
functionality.
In MySQL 5.0.19 and earlier,
INSERT IGNORE
,
UPDATE IGNORE
, and
REPLACE
were supported
only for primary keys, but not for unique keys. It was possible to work around this issue by removing
the constraint, then dropping the unique index, performing any inserts, and then adding the unique
index again.
This limitation was removed for
INSERT IGNORE
and
REPLACE
in MySQL 5.0.20. (See Bug
#17431.)
•
auto_increment_increment
and
auto_increment_offset
.
The
auto_increment_increment
[1446]
and
auto_increment_offset
[1449]
server system
variables are supported for
NDBCLUSTER
tables beginning with MySQL 5.0.46.
17.2. MySQL Cluster Installation and Upgrades
This section describes the basics for planning, installing, configuring, and running a MySQL Cluster.
Whereas the examples in
Section 17.3, “MySQL Cluster Configuration”
provide more in-depth
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...