下载PDF
Contentsquare's Successful Migration from Elasticsearch to ClickHouse: A Case Study
技术
- 网络安全和隐私 - 端点安全
- 网络安全和隐私 - 身份认证管理
适用行业
- 建筑物
- 水泥
适用功能
- 采购
- 质量保证
用例
- 楼宇自动化与控制
- 时间敏感网络
服务
- 系统集成
- 测试与认证
挑战
Contentsquare 是一家 SaaS 公司，其现有的 Elasticsearch 设置面临着重大挑战。该公司有 14 个正在生产的 Elasticsearch 集群，每个集群有 30 个节点。然而，他们在水平可扩展性方面遇到了困难，因为他们无法组装更大的集群并保持工作负载的稳定性。集群规模的这种限制意味着他们无法处理任何不适合单个集群的租户，从而严重限制了他们的增长能力。由于技术原因，他们可以处理的流量上限正在减慢公司的增长速度，这是不可接受的。他们有两个选择：要么找到一种方法在多集群设置中有效地托管每个租户，要么迁移到更具可扩展性的技术。
关于客户
Contentsquare 是一家提供数字体验分析的 SaaS 公司。该公司帮助企业了解用户如何以及为何与其应用程序、移动设备和网站进行交互。他们计算数十亿次触摸和鼠标移动，并将这些知识转化为有利可图的行动，从而提高参与度、降低运营成本并最大限度地提高转化率。 Contentsquare 使用行为数据、人工智能和大数据提供自动推荐，使数字团队的每个成员都能轻松衡量其行为的影响，并做出快速、高效的数据驱动决策，以优化客户旅程。
解决方案
Contentsquare 决定迁移到更具可扩展性的技术，并开始研究 OLAP 数据库引擎，以满足其最小查询延迟、丰富的查询语言、旋转磁盘的效率以及部署和操作简单性的要求。经过广泛的工程研究，他们发现 ClickHouse 满足他们的所有要求并开始规划迁移。迁移过程分为三个阶段：熟悉 ClickHouse 并用它构建新产品，使用自定义工具镜像所有现有功能以确保不回归，以及一一迁移客户端。他们在 ClickHouse 之上构建了一个新产品来熟悉该技术，然后迭代地迁移其主要产品，一一重写每个 API 端点以使用 ClickHouse 而不是 Elasticsearch。最后，他们将客户迁移到新的基础设施，并注意不要立即移动每个人来发现潜在的问题。
运营影响
数量效益
相关案例.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Commercial Building Automation Boosts Energy Efficiency
One of the challenges to building automation is the multitude of non-interoperable communications protocols that have evolved over the years. Buildings have several islands of automation. Bridging the islands of different automation without losing the considerable investment in each specialized control network is the main focus in this solution.
