|
|
| 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
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |----
| |
| − | |}
| |
