Strict Standards: Declaration of action_plugin_blog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/blog/action.php on line 13

Strict Standards: Declaration of action_plugin_indexmenu::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/indexmenu/action.php on line 13

Strict Standards: Declaration of action_plugin_importoldchangelog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldchangelog/action.php on line 8

Strict Standards: Declaration of action_plugin_importoldindex::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldindex/action.php on line 8

Strict Standards: Declaration of action_plugin_include::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/include/action.php on line 19

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 208

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 211

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 421

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 594

Strict Standards: Declaration of cache_instructions::retrieveCache() should be compatible with cache::retrieveCache($clean = true) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/cache.php on line 291

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/auth.php on line 154

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 73
mysqlサーバー [開発チーム]

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517
Writing /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/data/cache/c/c3e8452dc9acba9cfb9a212cfe43e480.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517
Writing /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/data/cache/c/c3e8452dc9acba9cfb9a212cfe43e480.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.
Writing /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/data/cache/c/c3e8452dc9acba9cfb9a212cfe43e480.xhtml failed

▼インストール方法


# apt-get install mysql-server-5.0

http://d.hatena.ne.jp/eight-tree/20080809

▼別サーバーからの接続許可

「ユーザー」と「ホスト」と「パスワード」の設定

grant all privileges on prende.* to prende@prende_web1 IDENTIFIED BY 'p!rende!';


もし、上記をリセットしたいなら、指定した「ユーザー」で下記を実行

delete from user where user='prende';

設定の反映

/etc/init.d/mysql restart

クラスター関連参考サイト

▼Cluster(クラスター)設定【管理ノード1台版】

まず、管理用サーバー(最低1台)とデータサーバー[Data兼SQLノード](最低2台)を用意

※管理ノード ・・・ クラスタを管理するためのマシン。2台以上が望ましい
※Dataノード ・・・ データを管理するマシン。後述する「NoOfReplicas?」の倍数台必要。最低2台
※SQLノード ・・・ SQLを処理するマシン。Dataノードとの共存が可能

今回は

  • 管理ノード…192.168.0.147
  • Data・SQLノード…192.168.0.148・192.168.0.149

の構成で作成


各サーバーにmysqlをインストール

# apt-get install mysql-server-5.0

Data兼SQLノードサーバで、設定ファイルをバックアップを作成し、編集します

# cp /etc/mysql/my.cnf /etc/mysql/my.cnf.back
# vi /etc/mysql/my.cnf


[client]
default-character-set=utf8

・
・
[mysqld]
・
・
language        = /usr/share/mysql/english
⇒language        = /usr/share/mysql/

ndbcluster
ndb-connectstring=管理ノードサーバーのIP

default-character-set=utf8
skip-character-set-client-handshake
・
・
#bind-address           = 127.0.0.1
・
・
[MYSQL_CLUSTER]
ndb-connectstring=管理ノードサーバーのIP
・
・

管理ノード用サーバーで、設定ファイルをコピーします

# cp /usr/share/mysql/ndb-config-2-node.ini /etc/mysql/ndb_mgmd.cnf
# cp /etc/mysql/ndb_mgmd.cnf /etc/mysql/ndb_mgmd.cnf.back

バックアップをとったら、編集します

# Example Ndbcluster storage engine config file.
#
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster

[ndb_mgmd]
Id=1
HostName= 192.168.0.147 ※管理ノード用

[ndbd]
Id= 2
HostName= 192.168.0.148 ※データとSQLノード用

[ndbd]
Id= 3
HostName= 192.168.0.149 ※データとSQLノード用

[mysqld]
Id= 4
HostName= 192.168.0.148 ※データとSQLノード用

[mysqld]
Id= 5
HostName= 192.168.0.149 ※データとSQLノード用

[mysqld]
#Id= 6

[mysqld]
#Id= 7

# choose an unused port number
# in this configuration 63132, 63133, and 63134
# will be used
[tcp default]
PortNumber= 63132

各設定ファイルの編集が完了したら、各ノードを起動します
管理ノード起動

# /usr/sbin/ndb_mgmd -f /etc/mysql/ndb_mgmd.cnf

確認します

#ndb_mgm -e show  
または
#usr/bin/ndb_mgm 
show

結果

Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2 (not connected, accepting connect from prende_db1)
id=3 (not connected, accepting connect from prende_db2)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @prende_web1  (Version: 5.0.51)

[mysqld(API)]   2 node(s)
id=4 (not connected, accepting connect from prende_db1)
id=5 (not connected, accepting connect from prende_db2)


データSQLノード起動

# /etc/init.d/mysql restart
# /usr/sbin/ndbd --initial   ※管理ノードの設定ファイルを変更したらinitial
# /etc/init.d/mysql-ndb start ※マネージメント指定(--initial --ndb-mgmd-host=192.168.0.147)

▼Cluster(クラスター)設定【管理ノード複数版】

管理ノード2台の場合、上記とは少々設定ファイルの書き方が違いますのでご注意ください
各サーバー情報を書き込む際は、IPか「hosts」で書いたもので指定を行います

各サーバーにmysqlをインストール

# apt-get install mysql-server-5.0

Data兼SQLノードサーバで、設定ファイルをバックアップを作成し、編集します

# cp /etc/mysql/my.cnf /etc/mysql/my.cnf.back
# vi /etc/mysql/my.cnf
・
・
[mysqld]
・
・
language        = /usr/share/mysql/english
⇒language        = /usr/share/mysql/japanese

ndbcluster
ndb-connectstring=kuma_web1

ndbcluster
ndb-connectstring=kuma_web2

default-character-set=utf8
skip-character-set-client-handshake
・
・
#bind-address           = 127.0.0.1
・
・
[MYSQL_CLUSTER]
ndb-connectstring=kuma_web1
[MYSQL_CLUSTER]
ndb-connectstring=kuma_web2
・
・

管理ノード用サーバーで、設定ファイルをコピーします

# cp /usr/share/mysql/ndb-config-2-node.ini /etc/mysql/ndb_mgmd.cnf
# cp /etc/mysql/ndb_mgmd.cnf /etc/mysql/ndb_mgmd.cnf.back

バックアップをとったら、編集します

# Example Ndbcluster storage engine config file.
#
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster

[ndb_mgmd]
Id=1
HostName=kuma_web1

[ndb_mgmd]
Id=2
HostName=kuma_web2

[ndbd]
Id= 3
HostName=kuma_db1

[ndbd]
Id= 4
HostName=kuma_db2

[mysqld]
Id= 5
HostName=kuma_db1

[mysqld]
Id= 6
HostName=kuma_db2

# choose an unused port number
# in this configuration 63132, 63133, and 63134
# will be used
[tcp default]
PortNumber= 63132

各設定ファイルの編集が完了したら、各ノードを起動します
管理ノード起動

# /usr/sbin/ndb_mgmd -f /etc/mysql/ndb_mgmd.cnf

確認します

#ndb_mgm -e show  
または
#usr/bin/ndb_mgm 
show

Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2 (not connected, accepting connect from kuma_db1)
id=3 (not connected, accepting connect from kuma_db2)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @kuma_web1  (Version: 5.0.51)

[mysqld(API)]   2 node(s)
id=4 (not connected, accepting connect from kuma_db1)
id=5 (not connected, accepting connect from kuma_db2)

データSQLノード起動

# /etc/init.d/mysql-ndb-mgm start
# /etc/init.d/mysql-ndb start --initial
# /etc/init.d/mysql restart
# /usr/sbin/ndbd (--initial)※管理ノードの設定ファイルを変更したらinitial
# /etc/init.d/mysql restart

起動終了後、管理ノードで確認をもう一度行い、下記のようにきちんと表示されればOK
IPは設定によって変化しますので、その部分は気にせずに

#ndb_mgm -e show  
または
#usr/bin/ndb_mgm 
show

Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=3    @10.249.115.64  (Version: 5.0.51, Nodegroup: 0, Master)
id=4    @10.254.90.64  (Version: 5.0.51, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1    @10.248.250.229  (Version: 5.0.51)
id=2    @10.249.3.178  (Version: 5.0.51)

[mysqld(API)]   2 node(s)
id=5    @10.249.115.64  (Version: 5.0.51)
id=6    @10.254.90.64  (Version: 5.0.51)

▼DB・テーブル・ユーザーの作成

mysqlに移動します

# mysql -u root -p
mysql> 

各データベースに、同じ名前のデータベースを作成します

mysql> create database ***;

ユーザーの作成

mysql> grant all privileges on zero.* to zero@'192.168.0.0/255.255.255.0' IDENTIFIED BY 'password';

※今回、ユーザーにすべての権限(insert・uodate・delete)を与えているため「all」と表記


テーブルの作成(マスターサーバーのみ

mysql> create table test_table(id int, name varchar(255)) ENGINE=NDBCLUSTER;

※必ず「ENGINE=NDBCLUSTER」を付ける

▼データベースとテーブルの確認

接続先追加

Password:
prende:~# mysql
Welcome TO the MySQL monitor.  Commands end WITH ; OR \g.
Your MySQL connection id IS 24
Server version: 5.0.32-Debian_7etch8-log Debian etch distribution
 
Type 'help;' OR '\h' FOR help. Type '\c' TO clear the buffer.
 
mysql>
mysql> SHOW DATABASES
    -> ;
+--------------------+
| DATABASE           |
+--------------------+
| information_schema |
| mysql              |
| zero               |
+--------------------+
3 rows IN SET (0.05 sec)
 
mysql> GRANT ALL privileges ON zero.* TO zero@"192.168.0.%";
Query OK, 0 rows affected (0.21 sec)
 
mysql>

▼こまんど?

■Master側

コマンドを打って、出た結果をSlave側のコマンドで代入する

mysql> show master status\G;

■Slave側

mysql> CHANGE MASTER TO MASTER_HOST='192.168.0.131', MASTER_USER='zero', MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000010', MASTER_LOG_POS=704;

なにかで入力してた…けど、エラーがでたんですょ!

mysql> load data from master;

▼できた!!!!!!!!

http://www.metainfo.jp/memo/?cat=64&paged=3
http://sourceforge.jp/projects/senna/lists/archive/dev/2005-April/000035.html
こちら

#!/bin/sh

mkdir ../MySQL-Cluster-6.3

cd ../MySQL-Cluster-6.3


wget http://mysql.mirrors.pair.com/Downloads/MySQL-Cluster-6.3/MySQL-Cluster-gpl-server-6.3.26-0.rhel5.i386.rpm
wget http://mysql.mirrors.pair.com/Downloads/MySQL-Cluster-6.3/MySQL-Cluster-gpl-shared-6.3.26-0.rhel5.i386.rpm
wget http://mysql.mirrors.pair.com/Downloads/MySQL-Cluster-6.3/MySQL-Cluster-gpl-client-6.3.26-0.rhel5.i386.rpm
wget http://mysql.mirrors.pair.com/Downloads/MySQL-Cluster-6.3/MySQL-Cluster-gpl-management-6.3.26-0.rhel5.i386.rpm
wget http://mysql.mirrors.pair.com/Downloads/MySQL-Cluster-6.3/MySQL-Cluster-gpl-storage-6.3.26-0.rhel5.i386.rpm
wget http://mysql.mirrors.pair.com/Downloads/MySQL-Cluster-6.3/MySQL-Cluster-gpl-tools-6.3.26-0.rhel5.i386.rpm

apt-get install alien << EOF
Y
EOF

alien *.rpm


dpkg -i *client*.deb
dpkg -i *gpl-server*.deb
dpkg -i *shared*.deb
dpkg -i *management*.deb
dpkg -i *gpl-tools*.deb

mkdir -p /var/lib/mysqlcluster/backup

cd /var/lib/mysqlcluster

echo "ファイルを作成します"

sleep 5

vi config.ini
mysqlサーバー.txt · 最終更新: 2010/07/27 15:47 (外部編集)
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 81