{"id":2016,"date":"2023-10-03T13:10:40","date_gmt":"2023-10-03T13:10:40","guid":{"rendered":"https:\/\/dataxive.com\/?page_id=2016"},"modified":"2024-08-27T10:56:45","modified_gmt":"2024-08-27T10:56:45","slug":"abzorb-case-study","status":"publish","type":"page","link":"https:\/\/dataxive.com\/?page_id=2016","title":{"rendered":"Abzorb Case Study"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2016\" class=\"elementor elementor-2016\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5676f4a elementor-section-height-min-height elementor-section-boxed elementor-section-height-default elementor-section-items-middle\" data-id=\"5676f4a\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-a73ddda\" data-id=\"a73ddda\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-aec98eb elementor-widget elementor-widget-heading\" data-id=\"aec98eb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 08-05-2024 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Abzorb Case Study<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-8d4298a\" data-id=\"8d4298a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-046be14 elementor-widget elementor-widget-image\" data-id=\"046be14\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 08-05-2024 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"600\" height=\"420\" src=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/sql-1.png\" class=\"attachment-large size-large wp-image-903\" alt=\"\" srcset=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/sql-1.png 600w, https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/sql-1-300x210.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5050cb elementor-widget elementor-widget-text-editor\" data-id=\"d5050cb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 08-05-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>SQL Server Managed Services<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec93ec7 elementor-widget elementor-widget-image\" data-id=\"ec93ec7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"503\" src=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Oracle_logo_PNG1-1024x644.png\" class=\"attachment-large size-large wp-image-1437\" alt=\"\" srcset=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Oracle_logo_PNG1-1024x644.png 1024w, https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Oracle_logo_PNG1-300x189.png 300w, https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Oracle_logo_PNG1-768x483.png 768w, https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Oracle_logo_PNG1.png 1278w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f997d58 elementor-widget elementor-widget-text-editor\" data-id=\"f997d58\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Implementing Oracle solutions.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3b61e5b elementor-hidden-desktop elementor-hidden-laptop elementor-hidden-tablet elementor-hidden-mobile elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3b61e5b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5120f4c\" data-id=\"5120f4c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1caf687 elementor-widget elementor-widget-image\" data-id=\"1caf687\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"320\" src=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Rectangle-90-1024x409.png\" class=\"attachment-large size-large wp-image-486\" alt=\"\" srcset=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Rectangle-90-1024x409.png 1024w, https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Rectangle-90-300x120.png 300w, https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Rectangle-90-768x306.png 768w, https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Rectangle-90.png 1316w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c4303ea elementor-hidden-desktop elementor-hidden-laptop elementor-hidden-tablet elementor-hidden-mobile elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c4303ea\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-2ac1402\" data-id=\"2ac1402\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6658eb1 elementor-hidden-desktop elementor-hidden-laptop elementor-hidden-tablet elementor-widget elementor-widget-text-editor\" data-id=\"6658eb1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Our Case Studies<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9fb213 elementor-widget elementor-widget-button\" data-id=\"f9fb213\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"#\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Our Case Studies<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ea91c8 elementor-widget__width-initial elementor-widget elementor-widget-heading\" data-id=\"0ea91c8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Read Our Case Studies<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-181928e\" data-id=\"181928e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-01fbee2 elementor-hidden-desktop elementor-hidden-laptop elementor-hidden-tablet elementor-hidden-mobile elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"01fbee2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-22dc427\" data-id=\"22dc427\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7c721f4 elementor-widget elementor-widget-text-editor\" data-id=\"7c721f4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Dataxive Modernises Abzorb\u2019s Database Platform for Reliability, Performance and Scalability whilst Mitigating Licensing Costs<\/strong><\/p><p>Abzorb\u2019s legacy database infrastructure was coming to end of life and poor performance impacted developer and user experience.<\/p><p><strong>Industry<\/strong><\/p><p>Telecommunication<\/p><p><strong>Location<\/strong><\/p><p>West Yorkshire, England<\/p><p><strong>Technologies<\/strong><\/p><p>CentOS , Docker, Grafana , Prometheus, PostgreSQL<\/p><p><strong>Overview<\/strong><\/p><p>Abzorb is a rapidly growing progressive technology company specialising in telecommunications, for businesses both nationally and internationally. \u00a0Abzorb engaged with Dataxive to address two immediate issues \u2013 PostgreSQL version reaching end-of-life and performance issue impacting their developer and customer experiences.<\/p><p><strong>The challenge<\/strong><\/p><p>Abzorb had growing concerns about their legacy database infrastructure, monitoring, performance, maintenance, availability, and security. Abzorb\u2019s legacy database infrastructure was built by a previous employee comprised of PostgreSQL 11.2 hosted on Cent OS 7 Docker containers. Monitoring was implemented using Prometheus and Grafana via separate containers in Docker Swarm implemented on 5x on-premises servers with 64GB RAM, 32 CPUs and SSD disks storage.<\/p><p><strong>\u201cOur immediate priorities at Abzorb are the End of life for PostgreSQL and performance of our app for developers and customers, especially as we are scaling and growing our customer base.\u201d\u00a0 &#8211;<\/strong> Ben Sugden, Head of Technology, Abzorb and Andrew Main, Developer, Abzorb<\/p><p>Abzorb\u2019s technical teams\u2019 pivot of focus to database platform performance issues, alongside the businesses\u2019 rapid growth, created development bottleneck and Abzorb\u2019s CTO Ben Sugden recognized the need for complete review and revamp of database platform. He knew he needed a database partner with proficiency in PostgreSQL hosted on Docker Swarm to support their teams.<\/p><p>To preserve the customer experience and enable Abzorb\u2019s to focus on innovation and growth rather than spending extensive amount of time fire fighting legacy database platform issues, Dataxive jumped right in!<\/p><p>Dataxive\u2019s expertise in building and managing containerised PostgreSQL databases and understanding of Docker were the perfect fit for Abzorb.<\/p><p><strong>The solution<\/strong><\/p><p>Dataxive began conducting a 360 Assessment starting with Database Inventory, Licensing, Database Security Assessment and a Database Health Check to identify where to provide strategic guidance on database infrastructure offering better performance, security, high availability and scalability whist mitigating any unexpected licensing costs. We used our specialized toolset, revealing essential areas within Abzorb&#8217;s environment for infrastructure, design, configuration, maintenance, performance and security optimizations.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3db720a elementor-widget elementor-widget-text-editor\" data-id=\"3db720a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Dataxive enables modernised database platform for Abzorb<\/strong><\/p><p>Our complete 360 review of Abzorb&#8217;s Containerised PostgreSQL environment, \u00a0Dataxive proposed a database platform strategy to \u00a0PostgreSQL version upgrade, improve performance, fortify security, fine-tune configurations, ensure availability and enable monitoring.<\/p><p><strong>PostgreSQL Version Upgrade and Mitigate Licensing Risk:<\/strong>\u00a0 Our key suggestions included recreating vendor specific PostgreSQL image intended for development purposes by custom build new custom docker image for Abzorb using CentOS 7 and Open Source version of PostgreSQL 13 to mitigate unexpected licensing cost.<\/p><p><strong>Database Performance:<\/strong>\u00a0 Our key suggestions included performance optimisations through auto-vacuuming, partitioning, table bloat, indexing guidelines, and other configuration tweaks at Server, OS and database level.<\/p><p><strong>Security best practices and compliance:<\/strong>\u00a0 Dataxive advised on using latest version of software, regular updates, configuration settings, best practices, and toolsets to improve configuration and stability, helping Abzorb strengthen their security.<\/p><p><strong>24\/7 database monitoring:<\/strong>\u00a0 We implemented database monitoring using Open Source tools such as Prometheus, Grafana and Postgres-exporter with custom metrics.<\/p><p><strong>Database Maintenance and Availability:<\/strong>\u00a0 Dataxive suggested measures for database backup, disaster recovery, high availability, fault tolerance and protection. We suggested increasing replica for improving high availability, configured monitoring to identify trends to make database configuration tweaks and trained developers.<\/p><p><strong>Reduced costs<\/strong>: Our recommendations empowered Abzorb teams to concentrate on innovation, raising awareness of potential vulnerabilities while mitigating risk of unexpected costs.<\/p><p><strong>Business outcomes<\/strong><\/p><p>The business goal for Abzorb was stability of their data management platform alongside their rapid growth\u2014all without compromising revenue or their developer\u2019s and player\u2019s experience. Our database gurus diligently developed custom docker images to mitigate licensing risk, enabled monitoring and offered advice allowing Abzorb to elevate their player and developer experiences across the platform while enhancing operational data management processes. With the insights from Dataxive\u2019s assessments, Abzorb had better visibility into their database environment, vulnerabilities, performance enhancements, and process improvements.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9c192f9 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"9c192f9\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-569f728\" data-id=\"569f728\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-e557605 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e557605\" data-element_type=\"section\" data-settings=\"{&quot;sticky&quot;:&quot;top&quot;,&quot;sticky_offset&quot;:100,&quot;sticky_parent&quot;:&quot;yes&quot;,&quot;sticky_on&quot;:[&quot;desktop&quot;,&quot;laptop&quot;,&quot;tablet&quot;,&quot;mobile&quot;],&quot;sticky_effects_offset&quot;:0}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-2cbfcb3\" data-id=\"2cbfcb3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-65ed495 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"65ed495\" data-element_type=\"widget\" data-settings=\"{&quot;headings_by_tags&quot;:[&quot;h5&quot;],&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;numbers&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_laptop&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor-pro - v3.18.0 - 20-12-2023 *\/\n.elementor-widget-table-of-contents .elementor-toc__header-title{color:var(--header-color)}.elementor-widget-table-of-contents.elementor-toc--collapsed .elementor-toc__toggle-button--collapse,.elementor-widget-table-of-contents:not(.elementor-toc--collapsed) .elementor-toc__toggle-button--expand{display:none}.elementor-widget-table-of-contents .elementor-widget-container{min-height:var(--box-min-height);border:var(--box-border-width,1px) solid var(--box-border-color,#9da5ae);border-radius:var(--box-border-radius,3px);background-color:var(--box-background-color);transition:min-height .4s;overflow:hidden}.elementor-toc__header{display:flex;align-items:center;justify-content:space-between;padding:var(--box-padding,20px);background-color:var(--header-background-color);border-bottom:var(--separator-width,1px) solid var(--box-border-color,#9da5ae)}.elementor-toc__header-title{font-size:18px;margin:0;color:var(--header-color)}.elementor-toc__toggle-button{cursor:pointer;display:inline-flex}.elementor-toc__toggle-button i{color:var(--toggle-button-color)}.elementor-toc__toggle-button svg{height:1em;width:1em;fill:var(--toggle-button-color)}.elementor-toc__spinner-container{text-align:center}.elementor-toc__spinner{font-size:2em}.elementor-toc__spinner.e-font-icon-svg{height:1em;width:1em}.elementor-toc__body{padding:var(--box-padding,20px);max-height:var(--toc-body-max-height);overflow-y:auto}.elementor-toc__body::-webkit-scrollbar{width:7px}.elementor-toc__body::-webkit-scrollbar-thumb{background-color:#babfc5;border-radius:10px}.elementor-toc__list-wrapper{list-style:none;padding:0}.elementor-toc__list-item{margin-bottom:.5em}.elementor-toc__list-item.elementor-item-active{font-weight:700}.elementor-toc__list-item .elementor-toc__list-wrapper{margin-top:.5em;margin-left:var(--nested-list-indent,1em)}.elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}.elementor-toc__list-item-text-wrapper{display:flex;align-items:center}.elementor-toc__list-item-text-wrapper:before,.elementor-toc__list-item-text-wrapper i{margin-right:8px;color:var(--marker-color)}.elementor-toc__list-item-text-wrapper svg{margin-right:8px;fill:var(--marker-color);height:var(--marker-size,.5em);width:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper i{font-size:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper:before{font-size:var(--marker-size,1em)}.elementor-toc--content-ellipsis .elementor-toc__list-item-text{white-space:nowrap;overflow:hidden;text-overflow:ellipsis}.elementor-toc__list-items--collapsible>.elementor-toc__list-wrapper>.elementor-toc__list-item>.elementor-toc__list-wrapper{display:none}.elementor-toc__heading-anchor{position:absolute}.elementor-toc__body .elementor-toc__list-item-text{color:var(--item-text-color);-webkit-text-decoration:var(--item-text-decoration);text-decoration:var(--item-text-decoration)}.elementor-toc__body .elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__body .elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}ol.elementor-toc__list-wrapper{counter-reset:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item{counter-increment:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item-text-wrapper:before{content:counters(item,\".\") \". \"}<\/style>\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h5 class=\"elementor-toc__header-title\">\n\t\t\t\tContents\t\t\t<\/h5>\n\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__65ed495\" aria-expanded=\"true\" aria-label=\"Open table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__65ed495\" aria-expanded=\"true\" aria-label=\"Close table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div id=\"elementor-toc__65ed495\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-10a3fcb\" data-id=\"10a3fcb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5b7fbe5 elementor-widget elementor-widget-image\" data-id=\"5b7fbe5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"26\" height=\"528\" src=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Group-388-1.png\" class=\"attachment-large size-large wp-image-499\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-70df7e7 elementor-widget elementor-widget-image\" data-id=\"70df7e7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"26\" height=\"528\" src=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Group-388-1.png\" class=\"attachment-large size-large wp-image-499\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c234abd elementor-widget elementor-widget-image\" data-id=\"c234abd\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"26\" height=\"528\" src=\"https:\/\/dataxive.com\/wp-content\/uploads\/2023\/03\/Group-388-1.png\" class=\"attachment-large size-large wp-image-499\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-d964c6d\" data-id=\"d964c6d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fccbb0f elementor-widget elementor-widget-text-editor\" data-id=\"fccbb0f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>OUR CASE STUDIES<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-670fe17 elementor-widget elementor-widget-heading\" data-id=\"670fe17\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h6 class=\"elementor-heading-title elementor-size-default\">Read Our Case Studies\n<\/h6>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-43bdb9c elementor-widget elementor-widget-text-editor\" data-id=\"43bdb9c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h6><strong>Dataxive Modernises Abzorb\u2019s Database Platform for Reliability, Performance and Scalability whilst Mitigating Licensing Costs<\/strong><\/h6><p>Abzorb\u2019s legacy database infrastructure was coming to end of life and poor performance impacted<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-295722a elementor-widget elementor-widget-heading\" data-id=\"295722a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">Dataxive\u2019s Story? <\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ad5fe6 elementor-widget elementor-widget-text-editor\" data-id=\"0ad5fe6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h6><strong>Industry<\/strong><\/h6><p>Telecommunication<\/p><h5><strong>Location<\/strong><\/h5><p>West Yorkshire, England<\/p><h5><strong>Technologies<\/strong><\/h5><p>CentOS , Docker, Grafana , Prometheus, PostgreSQL<\/p><h5><strong>Overview<\/strong><\/h5><p>Abzorb is a rapidly growing progressive technology company specialising in telecommunications, for businesses both nationally and internationally. \u00a0Abzorb engaged with Dataxive to address two immediate issues \u2013 PostgreSQL version reaching end-of-life and performance issue impacting their developer and customer experiences.<\/p><h5><strong>The challenge<\/strong><\/h5><p>Abzorb had growing concerns about their legacy database infrastructure, monitoring, performance, maintenance, availability, and security. Abzorb\u2019s legacy database infrastructure was built by a previous employee comprised of PostgreSQL 11.2 hosted on Cent OS 7 Docker containers. Monitoring was implemented using Prometheus and Grafana via separate containers in Docker Swarm implemented on 5x on-premises servers with 64GB RAM, 32 CPUs and SSD disks storage.<\/p><p><strong>\u201cOur immediate priorities at Abzorb are the End of life for PostgreSQL and performance of our app for developers and customers, especially as we are scaling and growing our customer base.\u201d\u00a0 &#8211;<\/strong> Ben Sugden, Head of Technology, Abzorb and Andrew Main, Developer, Abzorb<\/p><p>Abzorb\u2019s technical teams\u2019 pivot of focus to database platform performance issues, alongside the businesses\u2019 rapid growth, created development bottleneck and Abzorb\u2019s CTO Ben Sugden recognized the need for complete review and revamp of database platform. He knew he needed a database partner with proficiency in PostgreSQL hosted on Docker Swarm to support their teams.<\/p><p>To preserve the customer experience and enable Abzorb\u2019s to focus on innovation and growth rather than spending extensive amount of time fire fighting legacy database platform issues, Dataxive jumped right in!<\/p><p>Dataxive\u2019s expertise in building and managing containerised PostgreSQL databases and understanding of Docker were the perfect fit for Abzorb.<\/p><h6><strong>The solution<\/strong><\/h6><p>Dataxive began conducting a 360 Assessment starting with Database Inventory, Licensing, Database Security Assessment and a Database Health Check to identify where to provide strategic guidance on database infrastructure offering better performance, security, high availability and scalability whist mitigating any unexpected licensing costs. We used our specialized toolset, revealing essential areas within Abzorb&#8217;s environment for infrastructure, design, configuration, maintenance, performance and security optimizations.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-52539a6 elementor-widget elementor-widget-text-editor\" data-id=\"52539a6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h6><strong>Dataxive enables modernised database platform for Abzorb<\/strong><\/h6><p>Our complete 360 review of Abzorb&#8217;s Containerised PostgreSQL environment, \u00a0Dataxive proposed a database platform strategy to \u00a0PostgreSQL version upgrade, improve performance, fortify security, fine-tune configurations, ensure availability and enable monitoring.<\/p><h6><strong>PostgreSQL Version Upgrade and Mitigate Licensing Risk:<\/strong>\u00a0<\/h6><p>Our key suggestions included recreating vendor specific PostgreSQL image intended for development purposes by custom build new custom docker image for Abzorb using CentOS 7 and Open Source version of PostgreSQL 13 to mitigate unexpected licensing cost.<\/p><h6><strong>Database Performance:<\/strong>\u00a0<\/h6><p>Our key suggestions included performance optimisations through auto-vacuuming, partitioning, table bloat, indexing guidelines, and other configuration tweaks at Server, OS and database level.<\/p><h6><strong>Security best practices and compliance:<\/strong><\/h6><p>Dataxive advised on using latest version of software, regular updates, configuration settings, best practices, and toolsets to improve configuration and stability, helping Abzorb strengthen their security.<\/p><h6><strong>24\/7 database monitoring:<\/strong>\u00a0<\/h6><p>We implemented database monitoring using Open Source tools such as Prometheus, Grafana and Postgres-exporter with custom metrics.<\/p><h6><strong>Database Maintenance and Availability:<\/strong>\u00a0<\/h6><p>Dataxive suggested measures for database backup, disaster recovery, high availability, fault tolerance and protection. We suggested increasing replica for improving high availability, configured monitoring to identify trends to make database configuration tweaks and trained developers.<\/p><h6><strong>Reduced costs<\/strong>:<\/h6><p>Our recommendations empowered Abzorb teams to concentrate on innovation, raising awareness of potential vulnerabilities while mitigating risk of unexpected costs.<\/p><h5><strong>Business outcomes<\/strong><\/h5><p>The business goal for Abzorb was stability of their data management platform alongside their rapid growth\u2014all without compromising revenue or their developer\u2019s and player\u2019s experience. Our database gurus diligently developed custom docker images to mitigate licensing risk, enabled monitoring and offered advice allowing Abzorb to elevate their player and developer experiences across the platform while enhancing operational data management processes. With the insights from Dataxive\u2019s assessments, Abzorb had better visibility into their database environment, vulnerabilities, performance enhancements, and process improvements.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Abzorb Case Study SQL Server Managed Services Implementing Oracle solutions. Our Case Studies Our Case Studies Read Our Case Studies Dataxive Modernises Abzorb\u2019s Database Platform for Reliability, Performance and Scalability whilst Mitigating Licensing Costs Abzorb\u2019s legacy database infrastructure was coming to end of life and poor performance impacted developer and user experience. Industry Telecommunication Location [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-2016","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/dataxive.com\/index.php?rest_route=\/wp\/v2\/pages\/2016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dataxive.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dataxive.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dataxive.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dataxive.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2016"}],"version-history":[{"count":39,"href":"https:\/\/dataxive.com\/index.php?rest_route=\/wp\/v2\/pages\/2016\/revisions"}],"predecessor-version":[{"id":2691,"href":"https:\/\/dataxive.com\/index.php?rest_route=\/wp\/v2\/pages\/2016\/revisions\/2691"}],"wp:attachment":[{"href":"https:\/\/dataxive.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}