{"id":31679,"date":"2018-01-17T13:39:00","date_gmt":"2018-01-17T21:39:00","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/2019-1-2\/installing-upgrading\/licensing\/failover-service-and-configuration-tables\/"},"modified":"2020-08-06T14:36:12","modified_gmt":"2020-08-06T21:36:12","slug":"failover-service-and-configuration-tables","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/","title":{"rendered":"Failover service and configuration tables"},"content":{"rendered":"

Overview<\/span><\/strong><\/p>\n

This document describes the relationship between server_registry, service_status, and failover_service table. These tables hold information and status of all the servers as well as the services running on a standalone server, or on a specific server in a cluster. Ephesoft\u2019s failover mechanism provides high-availability support for services across servers and helps recover servers from crashes. If one of the servers fails, then the failover mechanism initializes another live server in a multi-server environment and starts to provide service through the newly initialized server.<\/p>\n

The status of the server can be seen in the server_registry table and services can be seen in the service_status table along with the server ID which is currently assigned for that service. These tables are automatically populated.<\/p>\n

 <\/p>\n

\n

Server_Registry\u00a0\u00a0 –<\/span><\/strong> This table keeps a record of active and inactive servers. This contains details of server whether its clustered environment or standalone server, this will have entries of all the servers. Below is a brief description of columns in this table.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Column Name<\/strong><\/td>\nColumn Description<\/strong><\/td>\n<\/tr>\n
ID<\/td>\nThis is the primary key of server_registry.<\/td>\n<\/tr>\n
Creation_Date<\/td>\nThis contains creation date of the current record in this table.<\/td>\n<\/tr>\n
Last_Modified<\/td>\nThis contains last modification date e.g. Change in execution capacity, active status etc.<\/td>\n<\/tr>\n
IS_Active<\/td>\nThis shows whether server currently active or down. For active server value will be 1 and 0 for in-active server.(only if its clustered environment)<\/td>\n<\/tr>\n
App_Context<\/td>\nThis contains the application context like \/dcma.<\/td>\n<\/tr>\n
Execution_Capacity<\/td>\nThis shows the current execution capacity for the server. Here execution capacity is workflow process capacity i.e. Number of batches processing at a time on a server in a cluster.<\/td>\n<\/tr>\n
IP_Address<\/td>\nThis contains server\u2019s host name or ip address.<\/td>\n<\/tr>\n
Port_Number<\/td>\nThis contains the port number on which application is running like: 8080<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\n

Service_Status –<\/span><\/strong>\u00a0 This table keeps mapping information of services currently allocated to different servers.<\/p>\n\n\n\n\n\n\n\n\n
Column Name<\/strong><\/td>\nColumn Description<\/strong><\/td>\n<\/tr>\n
ID<\/td>\nID is primary key of service_status.<\/td>\n<\/tr>\n
Creation_Date<\/td>\nThis contains creation date of the current record in this table.<\/td>\n<\/tr>\n
Last_Modified<\/td>\nThis contains last modification date e.g. If any server is down, then currently assigned services will be taken up by other available server and server_registry_id<\/strong> (Referring ID column of Server_Registry table<\/strong>) will be updated accordingly. Switching service to any other available server is an automated process.<\/td>\n<\/tr>\n
Service_Type<\/td>\nThis defines type of available services:<\/p>\n

APP_SCRIPT \u2013 <\/strong>This represents Application level script execution service. Refer this wiki for more detailed information about Application level script.<\/p>\n

More Info<\/a><\/p>\n

\n

ETL_SERVICE \u2013 <\/strong>This represents reporting service. Only one server runs reporting service in a cluster. Server_Registry_Id column in this table will tell you about the server which is currently assigned for reporting service. Refer this wiki for more detailed information about Reporting.<\/p>\n

More Info<\/a><\/p>\n

\n

FOLDER_MONITOR \u2013 <\/strong>This represents Folder monitor service and this service is responsible for creating new batches if any file\/folder is placed in UNC folder. This service keeps watching the UNC\/Drop folder for any new file\/folder dropped\/placed in UNC\/Drop folder. Once this service finds any new file\/folder in drop\/UNC folder then it creates new batch\/entry in batch_instance database table and later Workflow engine picks and process that batch.<\/p>\n

\n

LICENSE_SERVICE \u2013 <\/strong>This represents the license service. Refer this wiki for more detailed information about license server failover mechanism.<\/p>\n

More Info<\/a><\/p>\n

\n

PICKUP_SERVICE \u2013 <\/strong>This represents pickup service. Pickup service is responsible to pick batches in New and Ready state for further processing. Refer this wiki for more detailed information about pickup cron\/job configuration.<\/p>\n

More Info<\/a><\/td>\n<\/tr>\n

Server_Registry_Id<\/td>\nID of server which is currently assigned for this service. Referring ID column of Service_Registry table. <\/strong>This is the foreign key to server_registry table.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Failover_Service –<\/span><\/strong>\u00a0 This table contains details of services that will be taken up by the next available server if the currently assigned server is offline. Below is a screenshot showing that the Folder_Monitor service can be taken up by either server_registry_id 1, 2, and 3 but the server that is currently working as Folder_Monitor service can be verified in Service_Status table.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\u00a0<\/strong><\/p>\n

 <\/p>\n","protected":false},"featured_media":0,"parent":31674,"menu_order":4,"comment_status":"closed","ping_status":"open","template":"","doc_tag":[],"yoast_head":"\nFailover service and configuration tables | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Failover service and configuration tables\" \/>\n<meta property=\"og:description\" content=\"Overview This document describes the relationship between server_registry, service_status, and failover_service table. These tables hold information and status of all […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-06T21:36:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/01\/service_status.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/\",\"name\":\"Failover service and configuration tables | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2018-01-17T21:39:00+00:00\",\"dateModified\":\"2020-08-06T21:36:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Install and Upgrade\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"System Requirements\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Licensing Requirements\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Additional Resources\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"Failover service and configuration tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Failover service and configuration tables | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Failover service and configuration tables","og_description":"Overview This document describes the relationship between server_registry, service_status, and failover_service table. These tables hold information and status of all […]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/","og_site_name":"Ephesoft Docs","article_modified_time":"2020-08-06T21:36:12+00:00","og_image":[{"url":"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/01\/service_status.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/","name":"Failover service and configuration tables | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2018-01-17T21:39:00+00:00","dateModified":"2020-08-06T21:36:12+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/failover-service-and-configuration-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"Install and Upgrade","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/"},{"@type":"ListItem","position":4,"name":"System Requirements","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/"},{"@type":"ListItem","position":5,"name":"Licensing Requirements","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/"},{"@type":"ListItem","position":6,"name":"Additional Resources","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/"},{"@type":"ListItem","position":7,"name":"Failover service and configuration tables"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31679"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=31679"}],"version-history":[{"count":0,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31679\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31674"}],"next":[{"title":"License Validation","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/license-validation\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31681"}],"prev":[{"title":"License Server Failover","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/licensing\/additional-resources\/license-server-failover-mechanism\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31680"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=31679"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=31679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}