int main(int argc, char *argv[]) { TestConnections * Test = new TestConnections(argc, argv); int global_result = 0; Test->read_env(); Test->print_env(); printf("Connecting to RWSplit %s\n", Test->maxscale_IP); Test->connect_rwsplit(); printf("Setup firewall to block mysql on master\n"); fflush(stdout); Test->repl->block_node(0); printf("Trying query to RWSplit, expecting failure, but not a crash\n"); fflush(stdout); execute_query(Test->conn_rwsplit, (char *) "show processlist;"); printf("Setup firewall back to allow mysql\n"); fflush(stdout); Test->repl->unblock_node(0); sleep(10); global_result += check_maxscale_alive(); Test->close_rwsplit(); printf("Reconnecting and trying query to RWSplit\n"); fflush(stdout); Test->connect_rwsplit(); global_result += execute_query(Test->conn_rwsplit, (char *) "show processlist;"); Test->close_rwsplit(); Test->copy_all_logs(); return(global_result); }
int main(int argc, char *argv[]) { TestConnections * Test = new TestConnections(argc, argv); Test->set_timeout(30); Test->tprintf("Connecting to RWSplit\n"); Test->conn_rwsplit = open_conn_no_db(Test->rwsplit_port, Test->maxscale_IP, Test->maxscale_user, Test->maxscale_password, Test->ssl); if (Test->conn_rwsplit == NULL) { Test->add_result(1, "Error connecting to MaxScale\n"); delete Test; return 1; } Test->tprintf("Removing 'test' DB\n"); execute_query(Test->conn_rwsplit, (char *) "DROP DATABASE IF EXISTS test;"); Test->tprintf("Closing connections and waiting 5 seconds\n"); Test->close_rwsplit(); sleep(5); Test->tprintf("Connection to non-existing DB (all routers)\n"); Test->connect_maxscale(); Test->close_maxscale_connections(); Test->tprintf("Connecting to RWSplit again to recreate 'test' db\n"); Test->conn_rwsplit = open_conn_no_db(Test->rwsplit_port, Test->maxscale_IP, Test->maxscale_user, Test->maxscale_password, Test->ssl); if (Test->conn_rwsplit == NULL) { printf("Error connecting to MaxScale\n"); delete Test; return 1; } Test->tprintf("Creating and selecting 'test' DB\n"); Test->try_query(Test->conn_rwsplit, (char *) "CREATE DATABASE test; USE test"); Test->tprintf("Creating 't1' table\n"); Test->add_result(create_t1(Test->conn_rwsplit), "Error creation 't1'\n"); Test->close_rwsplit(); Test->tprintf("Reconnectiong\n"); Test->add_result(Test->connect_maxscale(), "error connection to Maxscale\n"); Test->tprintf("Trying simple operations with t1 \n"); Test->try_query(Test->conn_rwsplit, (char *) "INSERT INTO t1 (x1, fl) VALUES(0, 1);"); Test->set_timeout(240); Test->add_result(execute_select_query_and_check(Test->conn_rwsplit, (char *) "SELECT * FROM t1;", 1), "Error execution SELECT * FROM t1;\n"); Test->close_maxscale_connections(); int rval = Test->global_result; delete Test; return rval; }
int main(int argc, char *argv[]) { TestConnections * Test = new TestConnections(argc, argv); Test->set_timeout(30); Test->galera->connect(); tolerance = 0; // connect to the MaxScale server (rwsplit) Test->connect_rwsplit(); Test->execute_maxadmin_command((char *) "shutdown monitor \"Galera Monitor\""); if (Test->conn_rwsplit == NULL ) { Test->add_result(1, "Can't connect to MaxScale\n"); int rval = Test->global_result; delete Test; exit(1); } else { Test->try_query(Test->conn_rwsplit, "DROP TABLE IF EXISTS t1;"); Test->try_query(Test->conn_rwsplit, "create table t1 (x1 int);"); get_global_status_allnodes(&selects[0], &inserts[0], Test->galera, silent); Test->try_query(Test->conn_rwsplit, "select * from t1;"); get_global_status_allnodes(&new_selects[0], &new_inserts[0], Test->galera, silent); print_delta(&new_selects[0], &new_inserts[0], &selects[0], &inserts[0], Test->galera->N); Test->try_query(Test->conn_rwsplit, "insert into t1 values(1);"); get_global_status_allnodes(&new_selects[0], &new_inserts[0], Test->galera, silent); print_delta(&new_selects[0], &new_inserts[0], &selects[0], &inserts[0], Test->galera->N); // close connections Test->close_rwsplit(); } Test->galera->close_connections(); int rval = Test->global_result; delete Test; return rval; }
int main(int argc, char *argv[]) { TestConnections * Test = new TestConnections(argc, argv); Test->set_timeout(20); Test->repl->connect(); Test->tprintf("Connecting to RWSplit %s\n", Test->maxscale_ip()); Test->connect_rwsplit(); unsigned int conn_num; unsigned int all_conn = 0; Test->tprintf("Sleeping 5 seconds\n"); sleep(5); Test->tprintf("Checking number of connections ot backend servers\n"); for (int i = 0; i < Test->repl->N; i++) { conn_num = get_conn_num(Test->repl->nodes[i], Test->maxscale_ip(), Test->maxscale_hostname, (char *) "test"); Test->tprintf("connections: %u\n", conn_num); if ((i == 0) && (conn_num != 1)) { Test->add_result(1, " Master should have only 1 connection, but it has %d connection(s)\n", conn_num); } all_conn += conn_num; } if (all_conn != 2) { Test->add_result(1, "there should be two connections in total: one to master and one to one of slaves, but number of connections is %d\n", all_conn); } Test->close_rwsplit(); Test->repl->close_connections(); int rval = Test->global_result; delete Test; return rval; }