{"id":3820,"date":"2015-09-03T11:56:41","date_gmt":"2015-09-03T11:56:41","guid":{"rendered":"http:\/\/evolphin.com\/help\/?p=3820"},"modified":"2020-05-18T10:53:39","modified_gmt":"2020-05-18T14:53:39","slug":"hadr-database-writer","status":"publish","type":"post","link":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/","title":{"rendered":"HADR Database Writer"},"content":{"rendered":"\n

How To Find Database Writer?<\/h2>\n\n\n\n
  1. Goto Zoom database redo directory location.\n
      \n
    • Redo directory location can be found in file <zoom_installation_dir>\/conf\/server.xml<\/code> inside the dbspec<\/span> tag.<dbspec><\/code><\/strong>
      ....................<\/code>
      ....................<\/code>
      <redoLogDir>\/Volumes\/NAS\/ZOOM_HADR\/ACME-SERVER\/db\/redo<\/strong><\/span><\/redoLogDir>  <--- Redo directory location<\/span>
      \n..................
      \n<\/dbspec><\/strong>
      \n<\/span><\/code><\/li>\n<\/ul>\n<\/li>
    • Open file \"dlg-data.lck\"<\/code><\/li>
    • Peer name mentioned in this file is the database writer.<\/li><\/ol>\n\n\n\n
      \"dlg-data.lck\"<\/code> file is created when Zoom server first starts up.  The Zoom server which starts up first will become the database writer and all other Zoom server will become read only peers. <\/span><\/div>\n\n\n\n
      Now throughout the life time that server will be the database writer( aka. db writer)<\/div>\n\n\n\n

      Change Database Writer<\/h2>\n\n\n\n

      Please strictly follow the below mentioned steps in same order else it might result in database corruption:<\/p>\n\n\n\n

      1. Stop the existing database writer server.<\/li>
      2. Open and edit “dlg-data.lck” file.<\/li>
      3. Remove the existing database writer name from “dlg-data.lck” file. And write the name of new database writer. Just add the Zoom server name (peer name ) in the first line of this file in the same case<\/strong> as mentioned in hadr spec of server.xml<\/strong>. File should contain only the database writer name in the first line and nothing else.<\/li>
      4. Save the file.<\/li>
      5. Start the Old database writer server.<\/li>
      6. Restart the new database writer server.<\/li>
      7. Check the Zoom server logs of old database writer and new database  writer to verify the changes.<\/li>
      8. On read only servers which are not database writer you will find a line in server logs on Zoom server startup something like:\n
        Server “XYZ-2” is in DB read-only mode. The DB writer server “XYZ-1” last started in write mode on “Sep 3 2015 02:33:15 PM”.
        If above mentioned line is present in server log when it starts that means the servers is in Read only mode. “XYZ-2” is the name of the current server and XYZ-1 is the name of existing database writer server.
        XYZ-1 and XYZ2 are just sample names.<\/code><\/div>\n<\/li><\/ol>\n\n\n\n
        \n

        If “dlg-data.lck” is deleted and afterwards any Zoom server restarts and found it missing, will become the database writer.<\/p>\n

        It is strictly recommended to not deleted this file once it is generated while all Zoom servers are running.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        How To Find Database Writer? Goto Zoom database redo directory location. Redo directory location can be found in file <zoom_installation_dir>\/conf\/server.xml inside the dbspec tag.<dbspec>………………………………….<redoLogDir>\/Volumes\/NAS\/ZOOM_HADR\/ACME-SERVER\/db\/redo<\/redoLogDir>  <— Redo directory location ……………… <\/dbspec> Open file “dlg-data.lck” Peer name mentioned in this file is the database writer. “dlg-data.lck” file is created when Zoom server first starts up.  The Zoom server which […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[105,84],"tags":[127,128,71],"class_list":["post-3820","post","type-post","status-publish","format-standard","hentry","category-hadr","category-zoom-server","tag-db-writer","tag-hadr","tag-zoom-4"],"yoast_head":"\nHADR Database Writer - Evolphin Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"HADR Database Writer - Evolphin Documentation\" \/>\n<meta property=\"og:description\" content=\"How To Find Database Writer? Goto Zoom database redo directory location. Redo directory location can be found in file <zoom_installation_dir>\/conf\/server.xml inside the dbspec tag.<dbspec>........................................<redoLogDir>\/Volumes\/NAS\/ZOOM_HADR\/ACME-SERVER\/db\/redo<\/redoLogDir>  <--- Redo directory location .................. <\/dbspec> Open file "dlg-data.lck" Peer name mentioned in this file is the database writer. "dlg-data.lck" file is created when Zoom server first starts up.  The Zoom server which […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/\" \/>\n<meta property=\"og:site_name\" content=\"Evolphin Documentation\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-03T11:56:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-18T14:53:39+00:00\" \/>\n<meta name=\"author\" content=\"Rahul Bhargava\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rahul Bhargava\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/\"},\"author\":{\"name\":\"Rahul Bhargava\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#\\\/schema\\\/person\\\/e5f3dc53ac5f026ed258e224e75447f7\"},\"headline\":\"HADR Database Writer\",\"datePublished\":\"2015-09-03T11:56:41+00:00\",\"dateModified\":\"2020-05-18T14:53:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/\"},\"wordCount\":340,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#organization\"},\"keywords\":[\"db writer\",\"HADR\",\"zoom 4\"],\"articleSection\":[\"HADR\",\"Zoom Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/\",\"name\":\"HADR Database Writer - Evolphin Documentation\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#website\"},\"datePublished\":\"2015-09-03T11:56:41+00:00\",\"dateModified\":\"2020-05-18T14:53:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/administration-server\\\/zoom-server\\\/hadr-database-writer\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/evolphin.com\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HADR Database Writer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/\",\"name\":\"Evolphin Documentation\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/evolphin.com\\\/help\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#organization\",\"name\":\"Evolphin Documentation\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/evolphin.com\\\/help\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/cropped-evolphin-logo-dolphin_sm.png\",\"contentUrl\":\"https:\\\/\\\/evolphin.com\\\/help\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/cropped-evolphin-logo-dolphin_sm.png\",\"width\":200,\"height\":200,\"caption\":\"Evolphin Documentation\"},\"image\":{\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/evolphin.com\\\/help\\\/#\\\/schema\\\/person\\\/e5f3dc53ac5f026ed258e224e75447f7\",\"name\":\"Rahul Bhargava\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g\",\"caption\":\"Rahul Bhargava\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"HADR Database Writer - Evolphin Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/","og_locale":"en_US","og_type":"article","og_title":"HADR Database Writer - Evolphin Documentation","og_description":"How To Find Database Writer? Goto Zoom database redo directory location. Redo directory location can be found in file <zoom_installation_dir>\/conf\/server.xml inside the dbspec tag.<dbspec>........................................<redoLogDir>\/Volumes\/NAS\/ZOOM_HADR\/ACME-SERVER\/db\/redo<\/redoLogDir>  <--- Redo directory location .................. <\/dbspec> Open file \"dlg-data.lck\" Peer name mentioned in this file is the database writer. \"dlg-data.lck\" file is created when Zoom server first starts up.  The Zoom server which […]","og_url":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/","og_site_name":"Evolphin Documentation","article_published_time":"2015-09-03T11:56:41+00:00","article_modified_time":"2020-05-18T14:53:39+00:00","author":"Rahul Bhargava","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rahul Bhargava","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/#article","isPartOf":{"@id":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/"},"author":{"name":"Rahul Bhargava","@id":"https:\/\/evolphin.com\/help\/#\/schema\/person\/e5f3dc53ac5f026ed258e224e75447f7"},"headline":"HADR Database Writer","datePublished":"2015-09-03T11:56:41+00:00","dateModified":"2020-05-18T14:53:39+00:00","mainEntityOfPage":{"@id":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/"},"wordCount":340,"commentCount":0,"publisher":{"@id":"https:\/\/evolphin.com\/help\/#organization"},"keywords":["db writer","HADR","zoom 4"],"articleSection":["HADR","Zoom Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/","url":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/","name":"HADR Database Writer - Evolphin Documentation","isPartOf":{"@id":"https:\/\/evolphin.com\/help\/#website"},"datePublished":"2015-09-03T11:56:41+00:00","dateModified":"2020-05-18T14:53:39+00:00","breadcrumb":{"@id":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/evolphin.com\/help\/administration-server\/zoom-server\/hadr-database-writer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/evolphin.com\/help\/"},{"@type":"ListItem","position":2,"name":"HADR Database Writer"}]},{"@type":"WebSite","@id":"https:\/\/evolphin.com\/help\/#website","url":"https:\/\/evolphin.com\/help\/","name":"Evolphin Documentation","description":"","publisher":{"@id":"https:\/\/evolphin.com\/help\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/evolphin.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/evolphin.com\/help\/#organization","name":"Evolphin Documentation","url":"https:\/\/evolphin.com\/help\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/evolphin.com\/help\/#\/schema\/logo\/image\/","url":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2020\/04\/cropped-evolphin-logo-dolphin_sm.png","contentUrl":"https:\/\/evolphin.com\/help\/wp-content\/uploads\/2020\/04\/cropped-evolphin-logo-dolphin_sm.png","width":200,"height":200,"caption":"Evolphin Documentation"},"image":{"@id":"https:\/\/evolphin.com\/help\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/evolphin.com\/help\/#\/schema\/person\/e5f3dc53ac5f026ed258e224e75447f7","name":"Rahul Bhargava","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/952acf4ec94a228ca32ed9b65cee4cc97a33509ea04500e768b71da346e58971?s=96&d=mm&r=g","caption":"Rahul Bhargava"}}]}},"_links":{"self":[{"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/posts\/3820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/comments?post=3820"}],"version-history":[{"count":1,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/posts\/3820\/revisions"}],"predecessor-version":[{"id":14848,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/posts\/3820\/revisions\/14848"}],"wp:attachment":[{"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/media?parent=3820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/categories?post=3820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/evolphin.com\/help\/wp-json\/wp\/v2\/tags?post=3820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}