| ユーザフォーラムで議論/質問 | マニュアル検索 | ハイライト | ハイライトオフ | ポータル | php spot |
mysqlnd_ms_query_is_select(PECL mysqlnd_ms >= 1.0.0) mysqlnd_ms_query_is_select — Find whether to send the query to the master, the slave or the last used MySQL server 説明
int
mysqlnd_ms_query_is_select
( string
$query
)Finds whether to send the query to the master, the slave or the last used MySQL server. The plugins built-in read/write split mechanism will be used to analyze the query string to make a recommendation where to send the query. The built-in read/write split mechanism is very basic and simple. The plugin will recommend sending all queries to the MySQL replication master server but those which begin with SELECT, or begin with a SQL hint which enforces sending the query to a slave server. Due to the basic but fast algorithm the plugin may propose to run some read-only statements such as SHOW TABLES on the replication master. パラメータ
返り値
A return value of
If read write splitting has been disabled by setting
mysqlnd_ms.disable_rw_split, the function will
always return 例
例1 mysqlnd_ms_query_is_select() example
<?php 上の例の出力は以下となります。 INSERT INTO test(id) VALUES (1) should be run on the master. SELECT 1 FROM DUAL should be run on a slave. /*ms=last_used*/SELECT 2 FROM DUAL should be run on the server that has run the previous query |
各種マニュアル:
PHPマニュアル |
PEARマニュアル |
Smarty(英語)マニュアル |
PHP-GTKマニュアル |
「mysqlnd_ms_query_is_select - Find whether to send the query to the master, the slave or the last used MySQL server」をGoogle検索
|