/ 51 Confidential—Restricted Nov 10, 2022 Ozone User Group Summit / 51 2 Confidential—Restricted / 51 THE HYBRID DATA COMPANY We believe that data can make what is impossible today, possible tomorrow SNAPSHOTS ● A single object - multiple versions ● A group of objects as a unit ○ Consistent with each other ○ Point in time, together as a group ● Examples : ○ Application updating multiple rows of of a table to get to a consistent state ○ Application updating a group of tables to move from one state to another ● Easy rollback for a DB/table to last App consistent view 38 © 2022 Cloudera, Inc.

Group Replication原理解析与实践经验 徐春阳 MGR原理 MGR vs SEMI-SYNC MRG实践经验 • 支持多节点并发执行事务。如何保证从各个节点并发执行 的事务在每个节点以相同的顺序被应用/执行.------paxos协 议的功能。 • 自动地事务冲突检测。节点之间不能”同时”操作主键相同 记录,如果冲突，只有一个节点成功。------冲突检测。 ���������sql)��! ��sql! mysql_parse! mysql_execute_comma nd! trans_commit_stmt! MYSQL_BIN_LOG::com mit! group_replication_trans_before_commit! waitTicket! ���������� ���������� ���������� ������paxos� ��������� MGR实践经验 Group_replication_bootstrap_group参数须谨慎 DDL操作注意事项 当心secondary节点变成可写节点 规避大事务 Secondary��������! ������Single primary ����secondary����! ��my.cnf�read_only��������! ������stop group_replicaiton������

Kailun Qin, Ant Group Putting an Invisible Shield on Kubernetes Secrets Agenda • K8s Secrets: Overview • TEE-based K8s Secrets Protection: Solution • Production Experience @ Ant Group • Demo • Summary Introducing mutual (remote / local) attestations between entities Production Experience @ Ant Group KMS Plugin • Workflow • Encryption • Decryption • Engineering decisions • apiserver is responsible

https://badoo.com/ 26 / 97 ClickHouse in Production: Badoo HTTP Server Aggregation Services HDFS Storage MR Aggregation Old Events Pusher Events Storage Old Events Database PHP API Client Graphs Browser Mobile App 27 / 97 ClickHouse in Production: Badoo HTTP Server Aggregation Services HDFS Storage MR Aggregation Old Events Pusher Events Storage Old Events Database PHP API Client Graphs Browser Mobile App 28 / 97 ClickHouse in Production: Badoo HTTP Server Aggregation Services HDFS Storage MR Aggregation Old Events Pusher Events Storage Old Events Database PHP API Client Graphs

Series, DataFrame, etc. automatically align the data for you in computations • Powerful, flexible group by functionality to perform split-apply-combine operations on data sets, for both ag- gregating and Grouping By group by we are referring to a process involving one or more of the following steps: • Splitting the data into groups based on some criteria • Applying a function to each group independently Tablewise Function Application: pipe() 2. Row or Column-wise Function Application: apply() 3. Aggregation API: agg() and transform() 4. Applying Elementwise Functions: applymap() Tablewise function application

another way of expressing the same User.select({ User: ['*'], Tweet: [Count('id', 'count')] }).group_by('id').join(Tweet).order_by(('count', 'desc')) # do an atomic update TweetCount.update(count=F('count') SELECT "id", "creator", "name" FROM "blog" WHERE "id" = ? LIMIT 1 PARAMS: [1] To delete an arbitrary group of records, you can issue a DELETE query. The following will delete all Entry objects that are a year equivalent to the following: query = Blog.select({ Blog: ['*'], Entry: [Count('id')], }).group_by(Blog).join(Entry) The resulting query will return Blog objects with all their normal attributes

# another way of expressing the same User.select({ User: [’*’], Tweet: [Count(’id’, ’count’)] }).group_by(’id’).join(Tweet).order_by((’count’, ’desc’)) # do an atomic update TweetCount.update(count=F(’count’) SELECT "id", "creator", "name" FROM "blog" WHERE "id" = ? LIMIT 1 PARAMS: [1] To delete an arbitrary group of records, you can issue a DELETE query. The following will delete all Entry objects that are a year This is equivalent to the following: query = Blog.select({ Blog: [’*’], Entry: [Count(’id’)], }).group_by(Blog).join(Entry) The resulting query will return Blog objects with all their normal attributes

. . . . . . . . . . . . . . . . . . . . . . 295 7.9 In SQLSever and PostgreSQL, why does the aggregation column without alias throw ex‐ ception? . . . . . . . . . . . . . . . . . . . . . . . . . . . name after sharding, or misconducts caused by operations such as pagination, order by or aggregated group by are just the case in point. 3.1. Sharding 10 Apache ShardingSphere document, v5.0.0-beta Cross‐database extract the parsing context, which can include tables, options, ordering items, grouping items, aggregation functions, pagination information, query conditions and placeholders that may be revised. Query

another way of expressing the same User.select({ User: ['*'], Tweet: [Count('id', 'count')] }).group_by('id').join(Tweet).order_by(('count', 'desc')) # do an atomic update TweetCount.update(count=F('count') "id", "creator", "name" FROM "blog" WHERE "id" = ? LIMIT 1 PARAMS: [1] To delete an arbitrary group of records, you can issue a DELETE query. The following will delete all Entry objects that are a year equivalent to the following: query = Blog.select({ Blog: ['*'], Entry: [Count('id')], }).group_by(Blog).join(Entry) The resulting query will return Blog objects with all their normal attributes

# another way of expressing the same User.select({ User: [’*’], Tweet: [Count(’id’, ’count’)] }).group_by(’id’).join(Tweet).order_by((’count’, ’desc’)) # do an atomic update TweetCount.update(count=F(’count’) SELECT "id", "creator", "name" FROM "blog" WHERE "id" = ? LIMIT 1 PARAMS: [1] To delete an arbitrary group of records, you can issue a DELETE query. The following will delete all Entry objects that are a year This is equivalent to the following: query = Blog.select({ Blog: [’*’], Entry: [Count(’id’)], }).group_by(Blog).join(Entry) The resulting query will return Blog objects with all their normal attributes