|
|
| Line 1: |
Line 1: |
| {|
| | |
| |Test Num
| |
| |Category
| |
| |Test Description
| |
| |Expected Output
| |
| |How to test
| |
| |Assigned-to
| |
| |----
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |1
| |
| |Installation
| |
| |Make sure that the new watchdog is installed and configured successfully
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |2
| |
| |Upgrade
| |
| |Make sure that pgpool II with new watchdog can be installed on a system running pgpool II with the old watchdog
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |3
| |
| |Configuration
| |
| |Make sure that pgpool II can be configured successfully with one primary and one stand-by configuration
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |4
| |
| |Setup
| |
| |Three pgpool instanses (Host-1, Host-2, Host-3) are running on different machine using Ubutu 13:04. Connect to Host-1 and execute a sample query
| |
| |Configruation
| |
| |
| |
| |
| |
| |----
| |
| |4.1
| |
| |Functional testing
| |
| |Shutdown Host-1's pgpool instanse and execute query again
| |
| |Host-2 should take and respond to query
| |
| |
| |
| |
| |
| |----
| |
| |4.2
| |
| |Functional testing
| |
| |Shutdown Host-2's pgpool instanse and execute query again
| |
| |Host-3 should take and respond to query
| |
| |
| |
| |
| |
| |----
| |
| |4.3
| |
| |Functional testing
| |
| |Start Host-1's pgpool instanse and execute query again
| |
| |Need to see which host will respond to query
| |
| |
| |
| |
| |
| |----
| |
| |5
| |
| |Failover scenarions / Setup
| |
| |Three pgpool instanses (Host-1, Host-2, Host-3) are running on different machine using Ubutu 13:04. Connect to Host-1 and execute a sample query
| |
| |Configruation
| |
| |
| |
| |
| |
| |----
| |
| |5.1
| |
| |Failover scenarios
| |
| |Un-Plug Host-1's network cable and execute query again
| |
| |Host-2 should take and respond to query
| |
| |
| |
| |
| |
| |----
| |
| |5.2
| |
| |Failover scenarios
| |
| |Un-Plug Host-2's network cable and execute query again
| |
| |Host-3 should take and respond to query
| |
| |
| |
| |
| |
| |----
| |
| |5.3
| |
| |Failover scenarios
| |
| |Plug Host-1's network cable execute query again
| |
| |Need to see which host will respond to query
| |
| |
| |
| |
| |
| |----
| |
| |6
| |
| |Functional testing / Setup
| |
| |Three pgpool instanses (Host-1, Host-2, Host-3) are running on different machine using Ubutu 13:04. Connect to Host-1 and execute a long query
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |6.1
| |
| |Functional testing
| |
| |Shutdown / Power Off Host-1's instanse and execute query again
| |
| |Host-2 should take over and start responding, need to see the already running query response.
| |
| |
| |
| |
| |
| |----
| |
| |6.2
| |
| |Functional testing
| |
| |Shutdown / Power Off Host-2's instanse and execute query again
| |
| |Host-3 should take over and start responding, need to see the already running query response.
| |
| |
| |
| |
| |
| |----
| |
| |6.3
| |
| |Functional testing
| |
| |Start Host-1's pgpool instanse and execute query again
| |
| |Need to see which host will respond to query
| |
| |
| |
| |
| |
| |----
| |
| |7.1
| |
| |Cheking other functionality of watchdog
| |
| |Changing active/standby state in case of certain faults detected
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |7.2
| |
| |Cheking other functionality of watchdog
| |
| |Automatic virtual IP address assigning synchronous to server switching
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |7.3
| |
| |Cheking other functionality of watchdog
| |
| |Automatic registration of a server as standby in recovery
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |8
| |
| |Isolated master scenario / Setup
| |
| |Three pgpool instanses (Host-1, Host-2, Host-3) are running on different machine using Ubutu 13:04. Connect to Host-1 and execute a query
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |8.1
| |
| |Isolated master scenario
| |
| |Break the connectivity between pgpool watchdog primary and stand node by bringing down connectivity on the stand-by.
| |
| |Split brain testing ensures that their is only one master at a time that the clients can connect to. The stand-by should be promoted as the primary and the clients shouldn't be able to connect to the old master.
| |
| |
| |
| |
| |
| |----
| |
| |9
| |
| |Networking Isolation scenarion
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |9.1
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |10
| |
| |Database Failure
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |10.1
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |10.2
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |11
| |
| |Watchdog agent failure
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |11.1
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |11.2
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |----
| |
| |}
| |