[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pecl-cvs
Subject:    [PECL-CVS] =?utf-8?q?svn:_/pecl/mysqlnd=5Fms/trunk/tests/_mysqlnd=5Fms=5Fset=5Fqos=5Fage.phpt?=
From:       Ulf_Wendel <uw () php ! net>
Date:       2011-11-30 18:43:29
Message-ID: svn-uw-1322678609-320202-1721823320 () svn ! php ! net
[Download RAW message or body]

uw                                       Wed, 30 Nov 2011 18:43:29 +0000

Revision: http://svn.php.net/viewvc?view=revision&revision=320202

Log:
Quality of service filter and replication lag/max age

Changed paths:
    A   pecl/mysqlnd_ms/trunk/tests/mysqlnd_ms_set_qos_age.phpt

Added: pecl/mysqlnd_ms/trunk/tests/mysqlnd_ms_set_qos_age.phpt
===================================================================
--- pecl/mysqlnd_ms/trunk/tests/mysqlnd_ms_set_qos_age.phpt	                        \
                (rev 0)
+++ pecl/mysqlnd_ms/trunk/tests/mysqlnd_ms_set_qos_age.phpt	2011-11-30 18:43:29 UTC \
(rev 320202) @@ -0,0 +1,110 @@
+--TEST--
+mysqlnd_ms_set_qos(), max age/lag
+--SKIPIF--
+<?php
+if (version_compare(PHP_VERSION, '5.3.99-dev', '<'))
+	die(sprintf("SKIP Requires PHP >= 5.3.99, using " . PHP_VERSION));
+
+require_once('skipif.inc');
+require_once("connect.inc");
+
+if (($master_host == $slave_host)) {
+	die("SKIP master and slave seem to the the same, see tests/README");
+}
+
+_skipif_check_extensions(array("mysqli"));
+_skipif_connect($master_host_only, $user, $passwd, $db, $master_port, \
$master_socket); +_skipif_connect($slave_host_only, $user, $passwd, $db, $slave_port, \
$slave_socket); +
+include_once("util.inc");
+
+$ret = mst_is_slave_of($slave_host_only, $slave_port, $slave_socket, \
$master_host_only, $master_port, $master_socket, $user, $passwd, $db); +if \
(is_string($ret)) +	die(sprintf("SKIP Failed to check relation of configured master \
and slave, %s\n", $ret)); +
+if (false == $ret)
+	die("SKIP Configured master and slave might not be part of a replication \
cluster\n"); +
+$sql = mst_get_gtid_sql($db);
+if ($error = mst_mysqli_setup_gtid_table($master_host_only, $user, $passwd, $db, \
$master_port, $master_socket)) +  die(sprintf("SKIP Failed to setup GTID on master, \
%s\n", $error)); +
+
+$settings = array(
+	"myapp" => array(
+		'master' => array(
+			"master1" => array(
+				'host' 		=> $master_host_only,
+				'port' 		=> (int)$master_port,
+				'socket' 	=> $master_socket,
+			),
+		),
+		'slave' => array(
+			"slave1" => array(
+				'host' 	=> $slave_host_only,
+				'port' 	=> (int)$slave_port,
+				'socket' => $slave_socket,
+			),
+		 ),
+
+		'lazy_connections' => 1,
+	),
+
+);
+if ($error = mst_create_config("test_mysqlnd_ms_set_qos_gtid_sql_error.ini", \
$settings)) +	die(sprintf("SKIP %s\n", $error));
+?>
+--INI--
+mysqlnd_ms.enable=1
+mysqlnd_ms.ini_file=test_mysqlnd_ms_set_qos_gtid_sql_error.ini
+--FILE--
+<?php
+	require_once("connect.inc");
+	require_once("util.inc");
+
+	$link = mst_mysqli_connect("myapp", $user, $passwd, $db, $port, $socket);
+	if (mysqli_connect_errno()) {
+		printf("[001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
+	}
+
+	if (!$link->query("DROP TABLE IF EXISTS test") ||
+		!$link->query("CREATE TABLE test(id INT)") ||
+		!$link->query("INSERT INTO test(id) VALUES (1)"))
+		printf("[002] [%d] %s\n", $link->errno, $link->error);
+
+	/* GTID */
+	if (true !== ($ret = mysqlnd_ms_set_qos($link, MYSQLND_MS_QOS_CONSISTENCY_EVENTUAL, \
MYSQLND_MS_QOS_OPTION_AGE, 4))) { +		printf("[004] [%d] %s\n", $link->errno, \
$link->error); +	}
+
+	if ($res = mst_mysqli_query(6, $link, "SELECT id FROM test"))
+		var_dump($res->fetch_all());
+
+	printf("[007] [%d] '%s'\n", $link->errno, $link->error);
+
+	print "done!";
+?>
+--CLEAN--
+<?php
+	if (!unlink("test_mysqlnd_ms_set_qos_gtid_sql_error.ini"))
+	  printf("[clean] Cannot unlink ini file \
'test_mysqlnd_ms_set_qos_gtid_sql_error.ini'.\n"); +
+	require_once("connect.inc");
+	require_once("util.inc");
+	if ($error = mst_mysqli_drop_test_table($master_host_only, $user, $passwd, $db, \
$master_port, $master_socket)) +		printf("[clean] %s\n");
+
+	if ($error = mst_mysqli_drop_gtid_table($master_host_only, $user, $passwd, $db, \
$master_port, $master_socket)) +		printf("[clean] %s\n", $error));
+?>
+--EXPECTF--
+Warning: mysqli::query(): (mysqlnd_ms) Failed parse SQL for checking GTID. Cannot \
find #GTID placeholder in %s on line %d +array(1) {
+  [0]=>
+  array(1) {
+    [0]=>
+    string(1) "1"
+  }
+}
+[007] [0] ''
+done!
\ No newline at end of file



-- 
PECL CVS Mailing List 
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]