易截截图软件、单文件、免安装、纯绿色、仅160KB

MySQL Cluster Multi Computer Installation

    
Each MySQL Cluster host computer running an SQL node must have
installed on it a MySQL binary. For management nodes and data
nodes, it is not necessary to install the MySQL server binary, but
management nodes require the management server daemon
(ndb_mgmd
) and data nodes require the data node
daemon (ndbd
; in MySQL Cluster NDB 7.0 and
later, you can use ndbmtd
instead). It is also
a good idea to install the management client
(ndb_mgm
) on the management server host. This
section covers the steps necessary to install the correct binaries
for each type of Cluster node.

    Sun Microsystems, Inc. provides precompiled binaries that support
Cluster. However, we also include information relating to
installing a MySQL Cluster after building MySQL from source. For
setting up a cluster using MySQL's binaries, the first step
in the installation process for each cluster host is to download
the latest MySQL Cluster NDB 6.2, MySQL Cluster NDB 6.3, or MySQL
Cluster NDB 7.0 binary archive
(mysql-cluster-gpl-6.2.19-linux-i686-glibc23.tar.gz
,
mysql-cluster-gpl-6.3.31-linux-i686-glibc23.tar.gz
,
or
mysql-cluster-gpl-7.0.11-linux-i686-glibc23.tar.gz
,
respectively) from the
MySQL Cluster downloads
area
. We assume that you have placed this file in each
machine's /var/tmp
directory. (If you do
require a custom binary, see
Installing from the Development Source Tree
.)

Data and SQL Node Installation — .tar.gz
Binary. 
On each of the machines designated to host data or SQL nodes,
perform the following steps as the system
root
user:

Check your /etc/passwd
and
/etc/group
files (or use whatever
tools are provided by your operating


相关文档:

Mysql查询时,对于数值型字段加单引号会引起的误解~

假设有表 tb1
ID | name|
----+--------+
1   |2toon|
2   |1*xyz|
语句1:
 select * from  tb1 where ID='2toon' or name ='2toon';
mysql服务器在某模式下,可以执行这条句,就成功返回两条记录,原因在于 ID=‘2toon’ 加了单引号,mysql解释为 ID=2.
语句2
select * fro ......

解决MySQL不允许从远程访问的方法

1。 改表法。可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"
mysql -u root -p   
mysql>use mysql;   
mysql>update user set& ......

修改mysq连接数和启动mysql服务

my.cnf 或者是 my.ini
在[MySQL(和PHP搭配之最佳组合)d]配置段添加:
max_connections = 1000
保存,重启MySQL(和PHP搭配之最佳组合)服务。
然后用命令:
MySQL(和PHP搭配之最佳组合)admin -uroot -p variables 
输入root数据库账号的密码后可看到 
| max_connections | 1000 |
启动mysql服务
RedHat ......

mysql和sqlserver中查看当前库中所有表和字段信息

>>mysql:
1、查看所有表名:
show tables [from db_name];
2、查看字段信息
SHOW FULL COLUMNS from db_name.table_name
获取以下信息
Field :字段名
Type:字段类型
Collation:字符集 (mysql 5.0以上有)
Null :是否可以为NULL
Key:索引(PRI,unique,index)
Default:缺省值
Extra:额外(是否 aut ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号