互联网常用数据库市场占有率 互联网通用架构体制 谈谈 MySQL 数据库那些事  MySQL MySQL 基本介绍 基本介绍  MySQL MySQL 优化方式 优化方式  MySQL MySQL 技巧分享 技巧分享  Q Q & & AA MyISAM MyISAM 特点 特点 MyISAM vs MyISAM vs InnoDB InnoDB • 数据存储方式简单，使用 • 二进制层次的文件可以移植 二进制层次的文件可以移植 (Linux (Linux   Windows) Windows) • 访问速度飞快，是所有 访问速度飞快，是所有 MySQL MySQL 文件引擎中速度最快的 文件引擎中速度最快的 • 不支持一些数据库特性，比如 事务、外键约束等 不支持一些数据库特性，比如 事务、外键约束等 • Table level lock Table 读写性能都非常优秀 读写性能都非常优秀 • 能够承载大数据量的存储和访问 能够承载大数据量的存储和访问 • 拥有自己独立的缓冲池，能够缓存数据和索引 拥有自己独立的缓冲池，能够缓存数据和索引 MySQL 架构设计—应用架构 强一致性 对读一致性的权衡，如果是对读写实时性要求非常高的话， 就将读写都放在 M1 上面， M2 只是作为 standby 。 比如，订单处理流程，那么对读需要强一致性，实时写实

© 2018 Percona. 1 Peter Zaitsev Analyzing MySQL Logs with ClickHouse CEO, Percona April 27,2018 © 2018 Percona. 2 ClickHouse is my love at the first sight © 2018 Percona. 3 Why ? Fast and and Efficient Built with Purpose Practical Features Easy to Use MySQL inspired © 2018 Percona. 4 MySQL inspired © 2018 Percona. 5 Why Keep and Analyze Raw Logs ? Raw Logs Contain ultimate LZ4) • Typically 100x faster than MySQL on Single Server • Semi-Linear Scalability to 100s of nodes High Performance © 2018 Percona. 8 MySQL Wire Protocol Compatibility with ProxySQL Extra

Sync Clickhouse with MySQL/MongoDB Company: Xiaoxin Tech. Industry: Education Team: Big Data Leader: wangchao@xiaoheiban.cn About 100 billion data this year till now 30 million users We use binlog/oplog CRUD directly Can’t update/delete table frequently in Clickhouse Possible Solutions 2. MySQL Engine Not suitable for big tables Not suitable for MongoDB Possible Solutions 3. Reinit whole Must Listen ● Merge sharding tables ● SolidKey Typical Provider Config { Type: mysql, // mysql, mongodb, redis Listen: binlog, // binlog, kafka DataSource: user:pass@tcp(example

commands Protocol • https://github.com/WowWeeLabs/MiP-BLE-Protocol/blob/master/MiP-Protocol.md Sending commands Protocol • https://github.com/WowWeeLabs/MiP-BLE-Protocol/blob/master/MiP-Protocol.md Sending Reading data Add Listener (Receive DS) Request Data (Send DS) onNotify Reading commands Protocol Reading data Gotcha #2 aka Are you for real? https://www.npmjs.com/package/nativescript-mip-ble

network hosts one protocol, different protocols sit on different networks. (like appchains) One EightFish Network Hosts One Protocol node 1 node 2 node 3 node 4 node … Protocol 1 node 1 node node 2 node 3 node 4 node … Protocol 2 One Protocol Supports Multiple Applications node 1 node 2 node 3 node 4 node … Protocol 1 app 1 app 2 app 3 app n Every app has its own backend backend and frontend implementations. General User Text Persistence protocol https://github.com/eightfish-org/gutp A Case: GUTP MeBlog is a blog platform for users with the features of open-data and ownership

ingressgateway # use istio default controller servers: - port: number: 443 name: https protocol: HTTPs tls: mode: SIMPLE credentialName: productpage-credential hosts: - without jwt token ○ request with invalid jwt token Redeploy bookinfo sample services with http protocol and with sidecar injected 1) Apply deny-all authorization policy 2) Apply prouctpage-viewer policy reviews-viewer policy 5) Apply ratings-viewer policy Redeploy bookinfo sample services with http protocol and with sidecar injected 1) Apply deny-all authorization policy 2) Apply prouctpage-viewer policy

id is passed to IPVS module • Ip_vs_new_conn() inserts eBPF map • Key: (protocol, cip:cport , rsip:rsport) • Value: (protocol, lip:lport, rsip:rsport) • Ip_vs_conn_unlink() deletes entries in eBPF map

the header file for this library - Introduce the library as linked library into the application Protocol Buffers 利用 Rust 重塑移动应用开发 Directly expose the function to IOS/Android? - Hard to maintain - Hard independent service - Command <> Response - Using the protobuf as the data encoding/decoding protocol Tools - cargo-dinghy - rust-android-gradle - cargo-lipo - android-logger 利用 Rust 重塑移动应用开发

打包所有测试需求 Wasm mock server Why use rust ？ Software testing tool • 模拟数据规则 • 自动化测试 • Company's own protocol • Microservices • Multiple backend product line with complex upstream • Common testing platform • 模拟数据规则 • 自动化测试 • Supports http/https/tcp/websocket(MITM) • Can use rust to construct own protocol • Can MITM GRPC • Testing platform • Support HTTP POST wasm API • Support websocket stand in