大容量redis存储方案--Pika 陈宗志 360基础架构组技术经理 SACC2017 简介 • 13年入职360 基础架构组 – Bada – Pika – Zeppelin – Mario, Pink, slash, floyd • https://github.com/Qihoo360 SACC2017 概要 • 存在问题 • 分析问题 SACC2017 Pika 的出现并不是为了替代 Redis，而是 Redis 的场景补充。 Pika 力求在完全兼容 Redis 协议、继承 Redis 便 捷运维设计的前提下通过持久化存储的方式解决 Redis 在大容量场景下的问题 Pika 定位 SACC2017 Redis 问题 • 恢复时间长 • 一主多从, 主从切换代价大 • 缓冲区写满问题 SACC2017 问题分析 • 成本问题 • 可用性问题 • 同步问题 • 易用性问题 SACC2017 问题分析 • 尽可能兼容redis 协议 • 使用基于磁盘的存储引擎rocksdb 实现多 数据接口接口 • 网络库 • 添加binlog 模块 SACC2017 Pika 整体结构 SACC2017 网络模块--Pink •

Copying the viewport area Additional features Copying coordinates Miscellaneous buttons Viewing Curve Geometries Spatial data, often represented as either geometric or geographical values, can be visualized changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing

changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing curved paths, or areas defined by a radius from a certain point. Miscellaneous buttons Viewing Curve Geometries DBeaver User Guide 23.2. Page 114 of 700. DBeaver supports XML and JSON column types

Copying the viewport area Additional features Copying coordinates Miscellaneous buttons Viewing Curve Geometries Spatial data, often represented as either geometric or geographical values, can be visualized changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing

Copying the viewport area Additional features Copying coordinates Miscellaneous buttons Viewing Curve Geometries Spatial data, often represented as either geometric or geographical values, can be visualized changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing

Copying the viewport area Additional features Copying coordinates Miscellaneous buttons Viewing Curve Geometries Spatial data, often represented as either geometric or geographical values, can be visualized changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing

Copying the viewport area Additional features Copying coordinates Miscellaneous buttons Viewing Curve Geometries Spatial data, often represented as either geometric or geographical values, can be visualized changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing

Copying the viewport area Additional features Copying coordinates Miscellaneous buttons Viewing Curve Geometries Spatial data, often represented as either geometric or geographical values, can be visualized changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing

Copying the viewport area Additional features Copying coordinates Miscellaneous buttons Viewing Curve Geometries Spatial data, often represented as either geometric or geographical values, can be visualized changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing

Copying the viewport area Additional features Copying coordinates Miscellaneous buttons Viewing Curve Geometries Spatial data, often represented as either geometric or geographical values, can be visualized changes how this data is read to show the accurate information on the map. You can now visualize the curve geometries in DBeaver's spatial data viewer. This enhancement allows you to work with complex spatial CURVEPOLYGON MULTICURVE . MULTISURFACE You can use SQL functions like and to create and view curve geometries. st_geomfromtext st_curvetoline Tip: This feature can be specifically useful when dealing