Service Mesh的延伸 之论道Database Mesh 分享人：张亮 日期：2018年07月25日Service Mesh风头正劲Service Mesh产品多样化Service Mesh的优势 云原生 零入侵 可观察性 面向运维服务化之后，数据库怎么办？ 服务 • 无状态 • 根据规则路由 • 业务方处理事务 数据库 • 有状态 • 根据SQL路由 • 数据库自动处理事务数据库的进化趋势 • SQL • ACID+BASE • 分布式 NewSQLNewSQL的分类 New Architecture Transparent Sharding Middleware Database-as-a-Service What's Really New with NewSQL?数据库中间层的优势 系统 •事务 运维 • DBA 开发 • SQL数据库中间层应具备的能力 Sidecar 数据库 任意 单一 单一 连接数 高 低 高 异构语言 仅Java 任意 任意 性能 损耗低 损耗略高 损耗低 无中心化 是 否 是 静态入口 无 有 无 Sidecar的优势Database Mesh架构图Sharding-Sphere 核心功能 数据分片 分布式事务 数据库治理 弹性伸缩 管控界面 实现方案 Sharding-JDBC Sharding-Proxy Sharding-Sidecar

Decanter dispatcher. 1.2.19. JDBC The Decanter JDBC collector periodically executes a query on a database and sends the query result to the dispatcher. Apache Karaf Decanter 2.x - Documentation - 19 connect to the database. You can create this datasource using the Karaf jdbc:create command (provided by the jdbc feature). • the query property contains the SQL query to perform on the database and retrieve from the collectors) into a database. The Decanter JDBC appender transforms the data as a json string. The appender stores the json string and the timestamp into the database. The decanter-appender-jdbc

thrift client(cross-language support, both tcp and http), a Java Database Connectivity(JDBC) interface over thrift, or an Open Database Connectivity (ODBC) interface over a JDBC-to-ODBC bridge to communicate JDBC Authentication Provider. strin g 1.6.0 kyuubi.authenticati on.jdbc.password Database password for JDBC Authentication Provider. strin g 1.6.0 kyuubi.authenticati on.jdbc.query Database user for JDBC Authentication Provider. strin g 1.6.0 Key Default Meaning Type Since kyuubi.authenticati

thrift client(cross-language support, both tcp and http), a Java Database Connectivity(JDBC) interface over thrift, or an Open Database Connectivity (ODBC) interface over a JDBC-to-ODBC bridge to communicate JDBC Authentication Provider. strin g 1.6.0 kyuubi.authenticati on.jdbc.password Database password for JDBC Authentication Provider. strin g 1.6.0 kyuubi.authenticati on.jdbc.query Database user for JDBC Authentication Provider. strin g 1.6.0 Key Default Meaning Type Since kyuubi.authenticati

thrift client(cross-language support, both tcp and http), a Java Database Connectivity(JDBC) interface over thrift, or an Open Database Connectivity (ODBC) interface over a JDBC-to-ODBC bridge to communicate JDBC Authentication Provider. strin g 1.6.0 kyuubi.authenticati on.jdbc.password Database password for JDBC Authentication Provider. strin g 1.6.0 kyuubi.authenticati on.jdbc.query Database user for JDBC Authentication Provider. strin g 1.6.0 Key Default Meaning Type Since kyuubi.authenticati

thrift client(cross-language support, both tcp and http), a Java Database Connectivity(JDBC) interface over thrift, or an Open Database Connectivity (ODBC) interface over a JDBC-to-ODBC bridge to communicate Driver class name for JDBC Authentication Provider. kyuubi.authentication.jdbc.password Database password for JDBC Authentication Provider. kyuubi.authentication.jdbc.query Query JDBC URL for JDBC Authentication Provider. kyuubi.authentication.jdbc.user Database user for JDBC Authentication Provider. kyuubi.authentication.ldap.baseDN LDAP base

thrift client(cross-language support, both tcp and http), a Java Database Connectivity(JDBC) interface over thrift, or an Open Database Connectivity (ODBC) interface over a JDBC-to-ODBC bridge to communicate 23:50:52.968 INFO metastore.HiveMetaStore: 2: get_database: default 2020-11-16 23:50:52.968 INFO HiveMetaStore.audit: ugi=kentyao ip=unknown-ip-addr cmd=get_database: default 2020-11-16 23:50:52.970 INFO metastore metastore.HiveMetaStore: 2: get_database: default 2020-11-16 23:50:52.970 INFO HiveMetaStore.audit: ugi=kentyao ip=unknown-ip-addr cmd=get_database: default 2020-11-16 23:50:52.972 INFO metastore.HiveMetaStore:

thrift client(cross-language support, both tcp and http), a Java Database Connectivity(JDBC) interface over thrift, or an Open Database Connectivity (ODBC) interface over a JDBC-to-ODBC bridge to communicate 23:50:52.968 INFO metastore.HiveMetaStore: 2: get_database: default 2020-11-16 23:50:52.968 INFO HiveMetaStore.audit: ugi=kentyao ip=unknown-ip-addr cmd=get_database: default 2020-11-16 23:50:52.970 INFO metastore metastore.HiveMetaStore: 2: get_database: default 2020-11-16 23:50:52.970 INFO HiveMetaStore.audit: ugi=kentyao ip=unknown-ip-addr cmd=get_database: default 2020-11-16 23:50:52.972 INFO metastore.HiveMetaStore:

thrift client(cross-language support, both tcp and http), a Java Database Connectivity(JDBC) interface over thrift, or an Open Database Connectivity (ODBC) interface over a JDBC-to-ODBC bridge to communicate 23:50:52.968 INFO metastore.HiveMetaStore: 2: get_database: default 2020-11-16 23:50:52.968 INFO HiveMetaStore.audit: ugi=kentyao ip=unknown-ip-addr cmd=get_database: default 2020-11-16 23:50:52.970 INFO metastore metastore.HiveMetaStore: 2: get_database: default 2020-11-16 23:50:52.970 INFO HiveMetaStore.audit: ugi=kentyao ip=unknown-ip-addr cmd=get_database: default 2020-11-16 23:50:52.972 INFO metastore.HiveMetaStore:

thrift client(cross-language support, both tcp and http), a Java Database Connectivity(JDBC) interface over thrift, or an Open Database Connectivity (ODBC) interface over a JDBC-to-ODBC bridge to communicate 23:50:52.968 INFO metastore.HiveMetaStore: 2: get_database: default 2020-11-16 23:50:52.968 INFO HiveMetaStore.audit: ugi=kentyao ip=unknown-ip-addr cmd=get_database: default 2020-11-16 23:50:52.970 INFO metastore metastore.HiveMetaStore: 2: get_database: default 2020-11-16 23:50:52.970 INFO HiveMetaStore.audit: ugi=kentyao ip=unknown-ip-addr cmd=get_database: default 2020-11-16 23:50:52.972 INFO metastore.HiveMetaStore: