TiDB在⾦金金融聚合⽀支付业务的实践 个⼈人简介 • 宋涛 • Ping++ DBA • 负责Ping++数据库相关⼯工作、数据库⾃自动化运维建设 TiDB在Ping++⾦金金融聚合⽀支付业务的实践 • TiDB在Ping++的应⽤用场景分析 - OLAP：saas服务下实时数仓的⽀支撑 - HTAP：基于TiDB Docker的聚合⽀支付私有化部署⽅方案 Docker的聚合⽀支付私有化部署⽅方案 • 关于TiDB的线上运维 - TiDB体系 - 业务零感知运维 Ping++原数据架构及瓶颈 实时数仓数据源挑战： • 数⼗十亿交易易量量 • 多维度联合分析 • 实时分析+报表下载 场景⼀一：实时数仓数据源⽀支撑 数仓数据源选型过程： • RDS快速上线
 最⼤大承载3个⽉月交易易量量分析 • ADS 偶发性数据延时 •

connection if it doesn’t get a pong within 20 seconds. You can adjust this behavior with ping_interval and ping_timeout. How do I respond to pings? websockets takes care of responding to pings with pongs recv(), consider awaiting wait_closed() to detect quickly when the connec- tion is closed. – You may ping() or pong() if you wish but it isn’t needed in general. • Create a server with serve() which is similar create_protocol argument. • Call recv() and send() to receive and send messages at any time. • You may ping() or pong() if you wish but it isn’t needed in general. • If you aren’t using connect() as a context

module, dictionary, or a list of modules and/or dicts. See UI modules for more details. websocket_ping_interval: If set to a number, all websockets will be pinged every n seconds. This can help keep the closed. websocket_ping_timeout: If the ping interval is set, and the server doesn’t receive a ‘pong’ in this many seconds, it will close the websocket. The default is three times the ping interval, with a a minimum of 30 seconds. Ignored if the ping interval is not set. Authentication and security settings: cookie_secret: Used by RequestHandler.get_secure_cookie and set_secure_cookie to sign cookies.

module, dictionary, or a list of modules and/or dicts. See UI modules for more details. websocket_ping_interval: If set to a number, all websockets will be pinged every n seconds. This can help keep the closed. websocket_ping_timeout: If the ping interval is set, and the server doesn’t receive a ‘pong’ in this many seconds, it will close the websocket. The default is three times the ping interval, with a a minimum of 30 seconds. Ignored if the ping interval is not set. Authentication and security settings: cookie_secret: Used by RequestHandler.get_secure_cookie and set_secure_cookie to sign cookies.

URI path in argument. – Call recv() and send() to receive and send messages at any time. – You may ping() or pong() if you wish but it isn’t needed in general. • Create a server with serve() which is similar create_protocol argument. • Call recv() and send() to receive and send messages at any time. • You may ping() or pong() if you wish but it isn’t needed in general. 9 websockets Documentation, Release 4.0 check the connection. try: pong_waiter = await ws.ping() await asyncio.wait_for(pong_waiter, timeout=10) except asyncio.TimeoutError: # No response to ping in 10 seconds, disconnect. break else: # do something

URI path in argument. – Call recv() and send() to receive and send messages at any time. – You may ping() or pong() if you wish but it isn’t needed in general. • Create a server with serve() which is similar send() to receive and send messages at any time. 15 websockets Documentation, Release 5.0 • You may ping() or pong() if you wish but it isn’t needed in general. • If you aren’t using connect() as a context check the connection. try: pong_waiter = await ws.ping() await asyncio.wait_for(pong_waiter, timeout=10) except asyncio.TimeoutError: # No response to ping in 10 seconds, disconnect. break else: # do something

URI path in argument. – Call recv() and send() to receive and send messages at any time. – You may ping() or pong() if you wish but it isn’t needed in general. • Create a server with serve() which is similar send() to receive and send messages at any time. 15 websockets Documentation, Release 6.0 • You may ping() or pong() if you wish but it isn’t needed in general. • If you aren’t using connect() as a context check the connection. try: pong_waiter = await ws.ping() await asyncio.wait_for(pong_waiter, timeout=10) except asyncio.TimeoutError: # No response to ping in 10 seconds, disconnect. break else: # do something

module, dictionary, or a list of modules and/or dicts. See UI modules for more details. • websocket_ping_interval: If set to a number, all websockets will be pinged every n seconds. This can help keep the closed. • websocket_ping_timeout: If the ping interval is set, and the server doesn’t receive a ‘pong’ in this many seconds, it will close the websocket. The default is three times the ping interval, with a a minimum of 30 seconds. Ignored if the ping interval is not set. Authentication and security settings: 54 Chapter 6. DocumentationTornado Documentation, Release 6.5.1 • cookie_secret: Used by RequestHandler

module, dictionary, or a list of modules and/or dicts. See UI modules for more details. • websocket_ping_interval: If set to a number, all websockets will be pinged every n seconds. This can help keep the closed. • websocket_ping_timeout: If the ping interval is set, and the server doesn’t receive a ‘pong’ in this many seconds, it will close the websocket. The default is three times the ping interval, with a a minimum of 30 seconds. Ignored if the ping interval is not set. Authentication and security settings: • cookie_secret: Used by RequestHandler.get_secure_cookie and set_secure_cookie to sign cookies

module, dictionary, or a list of modules and/or dicts. See UI modules for more details. • websocket_ping_interval: If set to a number, all websockets will be pinged every n seconds. This can help keep the closed. • websocket_ping_timeout: If the ping interval is set, and the server doesn’t receive a ‘pong’ in this many seconds, it will close the websocket. The default is three times the ping interval, with a a minimum of 30 seconds. Ignored if the ping interval is not set. Authentication and security settings: • cookie_secret: Used by RequestHandler.get_secure_cookie and set_secure_cookie to sign cookies