Open Source Conference 2022 Online/Spring RDBMSとNoSQLのメリットを併せ持つクラウドネイティブなNewSQLデータベース 「TiDB」をKubernetesで動かしてみよう！ Executive Technical Advisor / Makoto Hasegawa 2 Makoto Hasegawa Working at // PingCAP(JP) で TiDB を動かしてみたくなりましたか？ 是非触ってみてください！? やってみよう！ Open Source Conference 2022 Online/Spring RDBMSとNoSQLのメリットを併せ持つクラウドネイティブなNewSQLデータベース 「TiDB」をKubernetesで動かしてみよう！ Executive Technical Advisor / Makoto

OpenPie Confidential • 在世界范围内的统计信息显示，Nosql和数据湖已经不在数据分析 领域占有主要市场 • Nosql和数据湖缺少很多支持数据分析的重要特性 o 缺少在高并发场景下的隔离性和一致性 o 和现有的BI工具很难集成 • 关系型数据库已经重新成为数据分析的主要平台 NoSQL 和数据湖已经不再是数据分析的主要平台 @2022 OpenPie. All All rights reserved. OpenPie Confidential • Nosql本身对于高级分析支持差 o 图形，地理信息 • Nosql对于复杂查询的支持差 NoSQL和数据湖很难胜任数据分析的工作场景 @2022 OpenPie. All rights reserved. OpenPie Confidential • 使用数据湖为基础进行数据分析需要多个组件进行集成部署，多个 ，多个 组件的配合需要大量的开发工作 • 许多缺乏 ANSI SQL 支持，需要专门的技术技能 • 专用引擎/工具（例如图形数据库）通常难以与记录系统集成，限制 了分析和创新的操作化 NoSQL和数据湖为基础的基础设施需要的分析工具不容易集成和部署 @2022 OpenPie. All rights reserved. OpenPie Confidential • 公有云无限的计算池可以提供理想的弹性计算资源

and MySQL Vitess combines and extends the important features of MySQL with the scalability of a NoSQL database. Vitess can help you with a variety of problems, including: • Scaling a MySQL database, Start a single keyspace cluster So you searched keyspace on Google and got a bunch of stuff about NoSQL… what’s the deal? It took a few hours, but after diving through the ancient Vitess scrolls you figure dedicated hardware. It combines and extends many important SQL features with the scalability of a NoSQL database. Vitess can help you with the following problems: 1. Scaling a SQL database by allowing

and MySQL Vitess combines and extends the important features of MySQL with the scalability of a NoSQL database. Vitess can help you with a variety of problems, including: • Scaling a MySQL database, Start a single keyspace cluster So you searched keyspace on Google and got a bunch of stuff about NoSQL… what’s the deal? It took a few hours, but after diving through the ancient Vitess scrolls you figure dedicated hardware. It combines and extends many important SQL features with the scalability of a NoSQL database. Vitess can help you with the following problems: 1. Scaling a SQL database by allowing

Start a single keyspace cluster So you searched keyspace on Google and got a bunch of stuff about NoSQL… what’s the deal? It took a few hours, but after diving through the ancient Vitess scrolls you figure dedicated hardware. It combines and extends many important SQL features with the scalability of a NoSQL database. Vitess can help you with the following problems: 1. Scaling a SQL database by allowing following sections compare Vitess to two common alternatives, a vanilla MySQL implementation and a NoSQL implemen- tation. Vitess vs. Vanilla MySQL Vitess improves a vanilla MySQL implementation in several

database/sql interface How to use MySQL How to use SQLite How to use PostgreSQL How to use beedb ORM NOSQL Summary Data storage and session Session and cookies 2 1.7.2 1.7.3 1.7.4 1.7.5 1.8 1.8.1 it makes it easy to access databases idiomatically in Go. NoSQL has been a hot topic in recent years. More websites are deciding to use NoSQL databases as their main database instead of just for the purpose purpose of caching. I will introduce you to two NoSQL databases, which are MongoDB and Redis, in section 5.6. Links Directory Previous Chapter: Chapter 4 Summary Next section: database/sql interface

联机运行 99.999% 可用性 • 关键字/值 + 复杂的关系查询 • SQL + Memcached + JavaScript + Java + HTTP/REST & C++ SQL + NoSQL • 开源 + 商业版本 • 通用硬件 + 管理、监视工具 总体拥有成本低 4/16/2017 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 25 MySQL Cluster •通过分布式联接支持分析 •通过并行表扫描支持非索引搜索 •MySQL Cluster 7.4 DBT2 FlexAsych – 2 亿次 NoSQL 读取/秒（32 个节点） 4/16/2017 31 MySQL Cluster 7.4 NoSQL 性能 2 亿次 NoSQL 读取/秒 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 •内存优化表 – 持久 – 可与基于磁盘的表混合使用 利用分片改善写入性能？  延迟要求  每毫秒的成本？  正常运行时间要求  每分钟的停机成本？  故障与维护？  应用程序敏捷性  开发者语言和框架？  SQL 还是 NoSQL？ 4/16/2017 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 33 增强开发运维人员的敏捷性， 减少停机时间 自动化管理 • 启动/停止节点或整个 群集 •

Start a single keyspace cluster So you searched keyspace on Google and got a bunch of stuff about NoSQL… what’s the deal? It took a few hours, but after diving through the ancient Vitess scrolls you figure dedicated hardware. It combines and extends many important SQL features with the scalability of a NoSQL database. Vitess can help you with the following problems: 1. Scaling a SQL database by allowing following sections compare Vitess to two common alternatives, a vanilla MySQL implementation and a NoSQL implemen- tation. Vitess vs. Vanilla MySQL Vitess improves a vanilla MySQL implementation in several

其他特定的应用程序存储建议 OpenShift Container Platform 内部 etcd：为了获得最好的 etcd 可靠性，首选使用具有最低一致 性延迟的存储技术。 数据库：数据库（RDBMS 、nosql DBs 等等）倾向于使用专用块存储来获得最好的性能。 5.4. 选择图形驱动程序 容器运行时将镜像和容器存储在图形驱动程序中（可插拔式存储技术），如 DeviceMapper 和 OverlayFS。它们都有各自的优缺点。 中，使用这些 (no)SQL 数据库进行了大量测试： Postgresql SQL v9.6 MongoDB noSQL v3.2 这些数据库的存储源自聚合模式存储集群。 用于 Postgresql SQL 基准测试 pgbench，用于数据库基准测试。对于 MongoDB noSQL 基准测试 YCSB Yahoo!Cloud Serving Benchmark 用于基准测试，workloada pen-behind performance.st rict-o-direct 第 第 15 章 章 在 在 GLUSTERFS 存 存储 储上 上进 进行 行优 优化 化 53 MongoDB noSQL 是 performance.st at-prefetch performance.re ad-ahead performance.wr ite-behind performance.re addir-ahead

Start a single keyspace cluster So you searched keyspace on Google and got a bunch of stuff about NoSQL… what’s the deal? It took a few hours, but after diving through the ancient Vitess scrolls you figure dedicated hardware. It combines and extends many important SQL features with the scalability of a NoSQL database. Vitess can help you with the following problems: 1. Scaling a SQL database by allowing following sections compare Vitess to two common alternatives, a vanilla MySQL implementation and a NoSQL implemen- tation. Vitess vs. Vanilla MySQL Vitess improves a vanilla MySQL implementation in several