{"id":35844,"date":"2021-08-31T11:38:42","date_gmt":"2021-08-31T08:38:42","guid":{"rendered":"https:\/\/orbitsoft.com\/blog\/?p=35844"},"modified":"2023-06-09T02:49:08","modified_gmt":"2023-06-08T23:49:08","slug":"mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system","status":"publish","type":"post","link":"https:\/\/orbitsoft.com\/blog\/mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system\/","title":{"rendered":"MySQL, Redis, Vault: how OrbitSoft saves and protects data in the PosiFlora accounting system"},"content":{"rendered":"
\n
\n
    \n \n
  • \n \n 01<\/span>\n
    \n
    \n Kind of tool<\/span>\n <\/div>\n

    Data base MySQL, Redis, Vault<\/p> <\/div>\n <\/li>\n \n

  • \n \n 02<\/span>\n
    \n
    \n Where we use it<\/span>\n <\/div>\n

    System of accounting and sales control in PosiFlora the flower business<\/p> <\/div>\n <\/li>\n \n

  • \n \n 03<\/span>\n
    \n
    \n Tasks required<\/span>\n <\/div>\n

    Keep different types of data separate from each other<\/p>\n

    Protect confidential data from hacking<\/p>\n

    Allow for the execution of complex analytical requests<\/p>\n

    Reserve capacity for when case load increases<\/p> <\/div>\n <\/li>\n \n

  • \n \n 04<\/span>\n
    \n
    \n Results<\/span>\n <\/div>\n

    Data for over 8,500 users securely protected<\/p>\n

    Processes up to 15 million API queries daily, and 10 times that on holidays<\/p>\n

    Saves data even when it\u2019s entered offline<\/p>\n

    Creates different kinds of reports to assist with business development<\/p> <\/div>\n <\/li>\n <\/ul>\n <\/div>\n <\/div><\/div>\n\n

    Flower store income depends on data storage and analysis <\/h2><\/div>\n\n\n

    PosiFlora is a system of accounting and sales control for the flower business. The majority of customers of PosiFlora are small flower shops.<\/p>\n\n\n\n

    It\u2019s important for florists to save and properly analyze sales data: which flowers sell better, and which worse, what the average sale total comes to, statistics regarding the average customer, etc. If a mistake is made with the data, the business won’t be able to plan sales and purchases, and will lose money. We tell you how OrbitSoft organized the data storage system for PosiFlora, and how we help streamline and improve the flower business.<\/p>\n\n\n

    \n
    \n \"\"\n <\/div>\n <\/figure><\/div>\n\n

    Separate data by type, and use different storage for each <\/h2><\/div>\n\n\n

    There are two ways to store data: put it into one database, or separate it into different databases. Keeping all data in one database is convenient for developers: they need to spend less time updating and searching for the information they need. But this can be unsafe for clients: if you store data for different clients in one database, it\u2019ll be easier to steal; if the database crashes, the system will stop working for all users.<\/p>\n\n\n\n

    At PosiFlora, the most important thing for us is the reliability of customer data. That’s why we separated data by type, and designed the architecture so that each type is stored separately:<\/p>\n\n\n\n

      \n
    • Client data is stored in a MySQL database<\/li>\n\n\n\n
    • Confidential\/sensitive data is stored in a special Vault database<\/li>\n\n\n\n
    • Operational data is stored in a Redis database<\/li>\n<\/ul>\n\n\n\n

      Some more detail regarding each solution:<\/p>\n\n\n

      MySQL for storing customer data <\/h2><\/div>\n\n\n

      The biggest group of data we store is data from PosiFlora clients regarding daily work tasks. The data is entered by florist employees, and they can perform different actions based on it.<\/p>\n\n\n

      \n
      \n \"\"\n <\/div>\n
      How MySQL helps address client needs<\/figcaption>\n <\/figure><\/div>\n\n\n

      We chose MySQL for storing customer data for several reasons. MySQL:<\/p>\n\n\n\n

        \n
      • Allows different types of client data to be kept separated, eliminating the possibility of getting it mixed up.<\/li>\n\n\n\n
      • Allows for the creation of complex analytical queries, so that clients can analyze data and plan their work.<\/li>\n\n\n\n
      • Is easier for analysts to use, as it understands SQL query language.<\/li>\n\n\n\n
      • Data storage slots are easy to expand as more clients are added.<\/li>\n\n\n\n
      • Database is free to use, so it economizes on storage resources.<\/li>\n<\/ul>\n\n\n\n

        Today, we keep the data of over 8,500 customers safe, and process over 100,000 requests daily.<\/p>\n\n\n

        Vault from HashiCorp for storing sensitive data <\/h2><\/div>\n\n\n

        In addition to user data, we store sensitive data that needs a higher degree of protection against hacking. For greater security, we store such data in a special database called Vault.<\/p>\n\n\n

        \n
        \n \"\"\n <\/div>\n
        How Vault saves sensitive data<\/figcaption>\n <\/figure><\/div>\n\n\n

        We chose Vault for increased security for the following reasons:<\/p>\n\n\n\n

          \n
        • Several levels of data protection.<\/li>\n\n\n\n
        • Even if the data is downloaded, it will be in a form such as “785kjjhgdwyegnsSJDC3523JLWK\u201d. An intruder cannot decrypt it without the key.<\/li>\n\n\n\n
        • The key consists of three parts, and is kept by three people.<\/li>\n<\/ul>\n\n\n\n

          The database with sensitive data works separately from other systems, substantially increasing security. Even if something happens to the rest of the data, the sensitive data is protected.<\/p>\n\n\n

          Redis for cached data storage <\/h2><\/div>\n\n\n

          In addition to user data and sensitive data, we store cache data. We store cache data separate from other data, helping maintain higher system speeds.<\/p>\n\n\n

          \n
          \n \"\"\n <\/div>\n
          How Redis helps to speed up the system<\/figcaption>\n <\/figure><\/div>\n\n\n

          We chose Redis because it reacts faster to the opening of a page if the database is given the right address. For example, when a salesperson wants uses the stock tab to check if a desired item is in stock, it takes less than a second. If the operative data were stored in MySQL, output would take longe<\/p>\n\n\n

          Advantages of a distributed storage system <\/h2><\/div>\n\n\n
            \n
          1. Security<\/strong>. Eliminates the possibility that data can overlap due to code errors. One client’s data will never be available to others. Increased security for sensitive data.<\/li>\n\n\n\n
          2. Scalability<\/strong>. Some of the data is stored on one server, some on another. This reduces development costs.<\/li>\n\n\n\n
          3. Data is easy to update.<\/strong> If we add new functions, e.g., if we limit access to data for employees, we can try this out on one client, and then later expand this to other clients. If something goes wrong, we\u2019ll notice the error immediately and fix it. This keeps everything running smoothly for the vast majority of clients.<\/li>\n\n\n\n
          4. High speed of the system.<\/strong> The accounting system doesn’t freeze while operating, even with an influx of holiday clients.<\/li>\n<\/ol>\n\n\n
            \n
            \n

            Technical Block<\/p>\n \t

            Frameworks:<\/p>\n

              \n
            • Back-end: Symfony<\/li>\n
            • Web front-end: Angular<\/li>\n
            • Mobile\/desktop app: Qt<\/li>\n<\/ul>\n

              Programming languages:<\/p>\n

                \n
              • Back-end: PHP 7.3-7.4<\/li>\n
              • Web front-end: TypeScript<\/li>\n
              • Mobile\/desktop app: C++<\/li>\n<\/ul>\n

                Libraries:<\/p>\n

                  \n
                • Neomer\/JSON:API<\/li>\n
                • Doctrine ORM<\/li>\n
                • Enqueue<\/li>\n
                • League\/Flysystem<\/li>\n
                • Monolog<\/li>\n
                • SwiftMailer<\/li>\n
                • Twig<\/li>\n<\/ul>\n

                  Data Base:<\/p>\n

                    \n
                  • MySQL<\/li>\n
                  • Redis<\/li>\n
                  • Apache Kafka<\/li>\n
                  • RabbitMQ<\/li>\n
                  • Couchbase<\/li>\n
                  • SQLite<\/li>\n
                  • ElasticSearch<\/li>\n<\/ul>\n

                    Platforms and third-party software:<\/p>\n

                      \n
                    • Docker, Docker Compose, Docker Swarm<\/li>\n
                    • Consul, from HashiCorp<\/li>\n
                    • Vault, from HashiCorp<\/li>\n
                    • Kafka Connect<\/li>\n
                    • Graylog<\/li>\n
                    • Grafana, Graphite, StatsD<\/li>\n<\/ul> <\/div>\n <\/div><\/div>\n\n
                      \n
                      \n

                      We release projects for online and offline business<\/h2>\n
                      \n

                      We work with businesses of any scale.<\/strong> Our clients include international companies, large and medium-sized businesses, and startups.<\/p>\n

                      Telecom<\/strong>: cellular operators, Internet service providers.<\/p>\n

                      Finance<\/strong>: electronic payment systems, insurance companies and brokers.<\/p>\n

                      Retail<\/strong>: stores, trade networks.<\/p>\n

                      Internet advertising<\/strong>: advertising agencies, advertising networks.<\/p>\n

                      Medicine<\/strong>: clinics, medical services.<\/p> <\/div>\n

                      \n Discuss or order development <\/div>\n <\/div>\n
                      \n \"\"\n <\/div>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"

                      PosiFlora is a system of accounting and sales control for the flower business. The majority of customers of PosiFlora are small flower shops. It\u2019s important for florists to save and properly analyze sales data: which flowers sell better, and which worse, what the average sale total comes to, statistics regarding the average customer, etc. If […]<\/p>\n","protected":false},"author":1,"featured_media":35856,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[196],"yoast_head":"\nMySQL, Redis, Vault: how OrbitSoft saves and protects data in the PosiFlora accounting system - OrbitSoft Blog<\/title>\n<meta name=\"description\" content=\"It\u2019s important for stores to save and properly analyze sales data. We tell you how OrbitSoft organized the data storage system for PosiFlora, and how we help streamline and improve the flower business.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/orbitsoft.com\/blog\/mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"MySQL, Redis, Vault: how OrbitSoft saves and protects data in the PosiFlora accounting system - OrbitSoft Blog\" \/>\n<meta name=\"twitter:description\" content=\"It\u2019s important for stores to save and properly analyze sales data. We tell you how OrbitSoft organized the data storage system for PosiFlora, and how we help streamline and improve the flower business.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/orbitsoft.com\/blog\/wp-content\/uploads\/articlesql.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@orbitsoft\" \/>\n<meta name=\"twitter:site\" content=\"@orbitsoft\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL, Redis, Vault: how OrbitSoft saves and protects data in the PosiFlora accounting system - OrbitSoft Blog","description":"It\u2019s important for stores to save and properly analyze sales data. We tell you how OrbitSoft organized the data storage system for PosiFlora, and how we help streamline and improve the flower business.","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:\/\/orbitsoft.com\/blog\/mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system\/","twitter_card":"summary_large_image","twitter_title":"MySQL, Redis, Vault: how OrbitSoft saves and protects data in the PosiFlora accounting system - OrbitSoft Blog","twitter_description":"It\u2019s important for stores to save and properly analyze sales data. We tell you how OrbitSoft organized the data storage system for PosiFlora, and how we help streamline and improve the flower business.","twitter_image":"https:\/\/orbitsoft.com\/blog\/wp-content\/uploads\/articlesql.jpg","twitter_creator":"@orbitsoft","twitter_site":"@orbitsoft","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/orbitsoft.com\/blog\/mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system\/","url":"https:\/\/orbitsoft.com\/blog\/mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system\/","name":"MySQL, Redis, Vault: how OrbitSoft saves and protects data in the PosiFlora accounting system - OrbitSoft Blog","isPartOf":{"@id":"https:\/\/orbitsoft.com\/blog\/#website"},"datePublished":"2021-08-31T08:38:42+00:00","dateModified":"2023-06-08T23:49:08+00:00","author":{"@id":"https:\/\/orbitsoft.com\/blog\/#\/schema\/person\/e515b3fa91e283750477594c4f028b7b"},"description":"It\u2019s important for stores to save and properly analyze sales data. We tell you how OrbitSoft organized the data storage system for PosiFlora, and how we help streamline and improve the flower business.","breadcrumb":{"@id":"https:\/\/orbitsoft.com\/blog\/mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/orbitsoft.com\/blog\/mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/orbitsoft.com\/blog\/mysql-redis-vault-how-orbitsoft-saves-and-protects-data-in-the-posiflora-accounting-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/orbitsoft.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL, Redis, Vault: how OrbitSoft saves and protects data in the PosiFlora accounting system"}]},{"@type":"WebSite","@id":"https:\/\/orbitsoft.com\/blog\/#website","url":"https:\/\/orbitsoft.com\/blog\/","name":"OrbitSoft Blog","description":"Discover the latest in news and resources for OrbitSoft","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/orbitsoft.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/orbitsoft.com\/blog\/#\/schema\/person\/e515b3fa91e283750477594c4f028b7b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/orbitsoft.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b1b269c579caf059f82b6d114c63fc49?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b1b269c579caf059f82b6d114c63fc49?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/orbitsoft.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/posts\/35844"}],"collection":[{"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/comments?post=35844"}],"version-history":[{"count":7,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/posts\/35844\/revisions"}],"predecessor-version":[{"id":36541,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/posts\/35844\/revisions\/36541"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/media\/35856"}],"wp:attachment":[{"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=35844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=35844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orbitsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=35844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}