Çë½Ìmysql¼¯ÈºÊ±Óöµ½µÄÎÊÌ⣡£¡
ÒÔÏÂÊǹÜÀí½ÚµãµÄÅäÖÃ
[NDBD DEFAULT]
NoOfReplicas=2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD] # ¹ÜÀí½Úµã
HostName=192.168.1.10
[NDBD] # ´æ´¢½Úµã 1
# ±¾»ú£¨¹ÜÀí½Úµã£©µÄ IP µØÖ·
HostName=192.168.1.13
DataDir=/var/lib/mysql-cluster
BackupDataDir=/var/lib/mysql-cluster/backup
[NDBD] # ´æ´¢½Úµã 2
HostName=192.168.1.14
DataDir=/var/lib/mysql-cluster
BackupDataDir=/var/lib/mysql-cluster/backup
# Óм¸¸ö´æ´¢½Úµã£¬¾Íд¼¸ÐÐ[MYSQLD]
[MYSQLD]
[MYSQLD]
ÒÔÏÂÊÇÊý¾Ý¿â½ÚµãµÄÅäÖÃ
[client]
socket = /var/run/mysqld/mysqld.sock
port = 3306
[mysqld]
ndbcluster
ndb-connectstring=192.168.1.10
# ¹ÜÀí½ÚµãµÄ IP µØÖ·
default-storage-engine=NDBCLUSTER
[mysql_cluster]
ndb-connectstring=192.168.1.10 # ¹ÜÀí½ÚµãµÄ IP µØÖ·
°´Àí˵ÅäÖÃÍêºóÎÒÔÚ¹ÜÀí½Úµã¿ÉÒÔ¿´µÃµ½µÄÊÇ
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.13 (Version: 5.0.51, Nodegroup: 0)
id=3 @192.168.1.14 (Version: 5.0.51, Nodegroup:
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......