{"id":27912,"date":"2020-10-09T17:03:05","date_gmt":"2020-10-09T15:03:05","guid":{"rendered":"https:\/\/www.intellias.com\/?p=27912"},"modified":"2024-01-18T16:32:50","modified_gmt":"2024-01-18T15:32:50","slug":"it-auditing-consulting-for-a-top-online-retailer","status":"publish","type":"post","link":"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/","title":{"rendered":"IT Auditing &#038; Consulting for a Top Online Retailer"},"content":{"rendered":"<h2 id=\"business-challenge\">Business challenge<\/h2>\n<p>Starting as an online electronics store, our client grew into the top online retailer in Ukraine and the owner of the biggest eCommerce retail platform. This platform helps businesses provide products and services to customers all over Ukraine. As our client\u2019s business grew considerably, the database architecture it relied on was in heavy use by customers and was unable to keep pace with the company\u2019s operational growth and usage. The eCommerce database design was outdated and the size of the database itself (measured in the gigabytes) was growing substantially, rapidly, and unsustainably, slowing down performance on a regular basis.<\/p>\n<p>Our client needed a fresh look by an outside expert at their eCommerce database design and enterprise architecture. With broad experience in IT infrastructure consulting services and the know-how to build and deliver stable and scalable databases, Intellias was brought in to analyze the client\u2019s current environment and eCommerce database design, provide database consulting services, and offer performance improvement recommendations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27916\" src=\"https:\/\/d17ocfn2f5o4rl.cloudfront.net\/wp-content\/uploads\/2020\/10\/ecommerce-databases.jpg\" alt=\"IT Auditing &amp; Consulting for a Top Online Retailer\" width=\"770\" height=\"450\" srcset=\"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/ecommerce-databases.jpg 770w, https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/ecommerce-databases-300x175.jpg 300w, https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/ecommerce-databases-768x449.jpg 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/p>\n<h2 id=\"solution-delivered\">Solution delivered<\/h2>\n<p>Skillfully executing a database audit and consulting on a project of this scale requires a deep understanding of the client\u2019s architecture, detailed knowledge of various database management systems, and an appreciation of the client\u2019s growth strategy. After thoroughly analyzing the current environment and eCommerce database design infrastructure, our DevOps expert defined the following criteria that helped us define a viable strategy for migrating the client\u2019s database to a new database management system:<\/p>\n<ul>\n<li>Starting database volume of 100 GB with expected quarterly growth of 50 percent<\/li>\n<li>Initial expected throughput of 100 RPS<\/li>\n<li>Virtual machines in use feature 4 CPUs and 16 GB of RAM<\/li>\n<li>Need to eliminate database idle time<\/li>\n<\/ul>\n<p>To achieve greater reliability and scalability, we assessed the MySQL and PostgreSQL data management systems, examining data protection, replication methods, and known cluster issues. Our thorough analysis showed that both MySQL and PostgreSQL have their advantages; however, working with large volumes of data required the high performance and replication methods offered by PostgreSQL.<\/p>\n<p>While elaborating an effective solution to bring maximum value to our client, we focused on making the best use of PostgreSQL. To eliminate data loss during replication, we analyzed the pros and cons of synchronous and asynchronous replication and suggested combining these two approaches within one cluster to guarantee that no data is lost when switching between servers.<\/p>\n<p>We also collected the most critical PostgreSQL cluster issues that could affect the performance of the client\u2019s environment and presented the development team with action items for smoothly setting up a high-availability cluster. To maintain high-availability clusters, Patroni and Stolon were suggested as the most advanced cluster management tools.<\/p>\n<h2 id=\"business-outcome\">Business outcome<\/h2>\n<p>Intellias presented the client with a sound roadmap for migrating to PostgreSQL \u2014 a move that would have a significant impact on our client\u2019s operational growth. Our viable migration strategy ensured greater reliability and scalability for the client\u2019s eCommerce database design and environment. We also provided the client\u2019s development team with IT consultancy and technical support while bringing the strategy to life. For more on this topic, read how Intellias created a roadmap for migrating a <a href=\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/\">retail marketplace platform<\/a> to mitigate risks and push changes to the infrastructure development process.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We conducted an in-depth analysis of eCommerce database environment and recommended performance improvements <\/p>\n","protected":false},"author":17,"featured_media":50525,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[37,79],"class_list":["post-27912","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-case-study","tag-cloud-devops","tag-retail","technologies-ansible","technologies-jenkins","technologies-mysql","technologies-postgresql","technologies-python"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.4 (Yoast SEO v23.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>IT Auditing &amp; Consulting for a Top Online Retailer - Intellias<\/title>\n<meta name=\"description\" content=\"See how Intellias IT infrastructure consulting services fostered the growth of a large eCommerce platform.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IT Auditing &amp; Consulting for a Top Online Retailer\" \/>\n<meta property=\"og:description\" content=\"See how Intellias IT infrastructure consulting services fostered the growth of a large eCommerce platform.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/\" \/>\n<meta property=\"og:site_name\" content=\"Intellias\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-09T15:03:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-18T15:32:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/d17ocfn2f5o4rl.cloudfront.net\/wp-content\/uploads\/2020\/10\/CS-featured-im-IT-Auditing-Consulting-for-a-Top-Online-Retailer.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Oksana Vakshynska\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/Rozetka-DevOps-twitter.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oksana Vakshynska\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/\",\"url\":\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/\",\"name\":\"IT Auditing & Consulting for a Top Online Retailer - Intellias\",\"isPartOf\":{\"@id\":\"https:\/\/intellias.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/IT-Auditing-Consulting-for-a-Top-Online-Retailer.jpg\",\"datePublished\":\"2020-10-09T15:03:05+00:00\",\"dateModified\":\"2024-01-18T15:32:50+00:00\",\"author\":{\"@id\":\"https:\/\/intellias.com\/#\/schema\/person\/ba2e15d0bfd27006a944536dffbea0b2\"},\"description\":\"See how Intellias IT infrastructure consulting services fostered the growth of a large eCommerce platform.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/#primaryimage\",\"url\":\"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/IT-Auditing-Consulting-for-a-Top-Online-Retailer.jpg\",\"contentUrl\":\"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/IT-Auditing-Consulting-for-a-Top-Online-Retailer.jpg\",\"width\":1000,\"height\":428,\"caption\":\"e-commerce add to cart online shopping business technology internet concept.\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/intellias.com\/#website\",\"url\":\"https:\/\/intellias.com\/\",\"name\":\"Intellias\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/intellias.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/intellias.com\/#\/schema\/person\/ba2e15d0bfd27006a944536dffbea0b2\",\"name\":\"Oksana Vakshynska\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"IT Auditing & Consulting for a Top Online Retailer - Intellias","description":"See how Intellias IT infrastructure consulting services fostered the growth of a large eCommerce platform.","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:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/","og_locale":"en_US","og_type":"article","og_title":"IT Auditing & Consulting for a Top Online Retailer","og_description":"See how Intellias IT infrastructure consulting services fostered the growth of a large eCommerce platform.","og_url":"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/","og_site_name":"Intellias","article_published_time":"2020-10-09T15:03:05+00:00","article_modified_time":"2024-01-18T15:32:50+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/d17ocfn2f5o4rl.cloudfront.net\/wp-content\/uploads\/2020\/10\/CS-featured-im-IT-Auditing-Consulting-for-a-Top-Online-Retailer.jpg","type":"image\/jpeg"}],"author":"Oksana Vakshynska","twitter_card":"summary_large_image","twitter_image":"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/Rozetka-DevOps-twitter.jpg","twitter_misc":{"Written by":"Oksana Vakshynska","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/","url":"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/","name":"IT Auditing & Consulting for a Top Online Retailer - Intellias","isPartOf":{"@id":"https:\/\/intellias.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/#primaryimage"},"image":{"@id":"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/#primaryimage"},"thumbnailUrl":"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/IT-Auditing-Consulting-for-a-Top-Online-Retailer.jpg","datePublished":"2020-10-09T15:03:05+00:00","dateModified":"2024-01-18T15:32:50+00:00","author":{"@id":"https:\/\/intellias.com\/#\/schema\/person\/ba2e15d0bfd27006a944536dffbea0b2"},"description":"See how Intellias IT infrastructure consulting services fostered the growth of a large eCommerce platform.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/intellias.com\/it-auditing-consulting-for-a-top-online-retailer\/#primaryimage","url":"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/IT-Auditing-Consulting-for-a-Top-Online-Retailer.jpg","contentUrl":"https:\/\/intellias.com\/wp-content\/uploads\/2020\/10\/IT-Auditing-Consulting-for-a-Top-Online-Retailer.jpg","width":1000,"height":428,"caption":"e-commerce add to cart online shopping business technology internet concept."},{"@type":"WebSite","@id":"https:\/\/intellias.com\/#website","url":"https:\/\/intellias.com\/","name":"Intellias","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/intellias.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/intellias.com\/#\/schema\/person\/ba2e15d0bfd27006a944536dffbea0b2","name":"Oksana Vakshynska"}]}},"_links":{"self":[{"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/posts\/27912"}],"collection":[{"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/comments?post=27912"}],"version-history":[{"count":14,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/posts\/27912\/revisions"}],"predecessor-version":[{"id":69414,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/posts\/27912\/revisions\/69414"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/media\/50525"}],"wp:attachment":[{"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/media?parent=27912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/categories?post=27912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/intellias.com\/wp-json\/wp\/v2\/tags?post=27912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}