{"id":59710,"date":"2024-09-20T02:41:43","date_gmt":"2024-09-20T02:41:43","guid":{"rendered":"https:\/\/www.cloudthat.com\/resources\/?post_type=resources&#038;p=59710"},"modified":"2024-10-18T12:23:12","modified_gmt":"2024-10-18T12:23:12","slug":"achieved-a-35-improvement-in-database-query-performance-and-reduced-latency-with-migration-to-amazon-rds","status":"publish","type":"resources","link":"https:\/\/www.cloudthat.com\/resources\/case-study\/achieved-a-35-improvement-in-database-query-performance-and-reduced-latency-with-migration-to-amazon-rds","title":{"rendered":"Achieved a 35% Improvement in Database Query Performance and Reduced Latency with Migration to Amazon RDS"},"content":{"rendered":"<p>Zceppa is a location marketing platform that boosts online visibility and engagement for multi-location brands. Their all-in-one solution enhances each location\u2019s presence in the digital space, driving increased offline traffic and sales. With Zceppa, brands can master every touchpoint of the digital-to-offline buying journey, fostering growth and success across their network.<\/p>\n","protected":false},"author":325,"featured_media":59789,"parent":0,"template":"","cat_resources":[6],"technology":[32],"published_by":"324","primary-authors":["918","884","348","314"],"secondary-authors":["325"],"acf":{"banner_image":59790,"resources_label":"","download_url":"https:\/\/content.cloudthat.com\/resources\/wp-content\/uploads\/2024\/09\/Zceppa-caseStudy-TwoPager.pdf","client_logo":59788,"highlights":{"first_part":{"icon":336,"title":"35%","subtitle":"Performance Improvement"},"second_part":{"icon":335,"title":"99.99%","subtitle":"Uptime"},"third_part":{"icon":334,"title":"40% ","subtitle":"Reduction in Maintenance"}},"the_challenge":"The client faced performance and scalability issues with self-managed MySQL databases on EC2, along with high maintenance overhead, challenges in ensuring high availability and disaster recovery, and difficulties in maintaining security and compliance. Centralized monitoring was also inefficient, prompting a migration to Amazon RDS for MySQL to streamline operations, improve performance, and enhance security and monitoring.","client_testimonial":{"image":"","description":"","author":""},"solutions":"\u2022 Provisioned AWS DMS to migrate MySQL databases from Amazon EC2 to Amazon RDS, addressing performance and maintenance challenges.\r\n\u2022 Set up AWS DMS endpoints and defined migration tasks to ensure accurate data transfer and deployed an Amazon RDS read replica for improved performance and high availability.\r\n\u2022 Verified data integrity post-migration, isolated API servers in private subnets for enhanced security, and configured Amazon CloudWatch and Amazon SNS for efficient monitoring and alerts.","the_results":"Migration to Amazon RDS boosted query performance by 35%, ensured 99.99% uptime with rapid failovers, and enhanced security, while automated processes cut maintenance by 40% and real-time monitoring improved response times by 60%.","about_client_left_side":[{"field_63315a4dc06e1":"15085","field_63315a5bc06e2":"Industry\u00a0","field_63315a61c06e3":"Marketing Platform"},{"field_63315a4dc06e1":"15083","field_63315a5bc06e2":"Expertise\u00a0","field_63315a61c06e3":"Amazon VPC, Amazon S3, AWS DMS, Amazon RDS, AWS KMS, Amazon CloudWatch"},{"field_63315a4dc06e1":"15084","field_63315a5bc06e2":"Offerings\/solutions\u00a0","field_63315a61c06e3":" Migrating to Amazon RDS boosted performance, security, and scalability."}]},"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/resources\/59710"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/resources"}],"about":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/types\/resources"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/users\/325"}],"version-history":[{"count":2,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/resources\/59710\/revisions"}],"predecessor-version":[{"id":59791,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/resources\/59710\/revisions\/59791"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/media\/59789"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/media?parent=59710"}],"wp:term":[{"taxonomy":"cat_resources","embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/cat_resources?post=59710"},{"taxonomy":"technology","embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/technology?post=59710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}