© 2018 Percona. 1 Peter Zaitsev Using MySQL for Distributed Database Architectures CEO, Percona PingCAP Infra Meetup, Shanghai, China, May 26, 2018 © 2018 Percona. 2 About Percona Solutions enterprises © 2018 Percona. 3 Presentation Cover Basics Why Going Distributed How to do it © 2018 Percona. 4 Distributed ? MySQL Deployment on More than one System © 2018 Percona. 5 Modern Active Users Possible 15M of Daily Active Users counting time of day skew © 2018 Percona. 8 Distributed Systems Tend To be More Complicated to Develop Against More Complicated to Operate Have

C++20 ❤ SQL John R Bandela, MDOverview u SQL u C++ Example u Implementation techniques u fixed_string u meta_struct u Parsing compile time strings into meta_structsOverview v SQL v C++ Example “CppCon”Query for orders with input from user SELECT orders.id, name, item, price, discount_code FROM orders JOIN customers ON customers.id = customerid WHERE price > {price_from_user};Avoiding SQL Injection item, price, discount_code FROM orders JOIN customers ON customers.id = customerid WHERE price > ?;SQL Library Options u Traditional database library with strings u Domain specific language u Object

Updates to a shared chat / drawing canvas – Game events © Joe Mertz – Mobile to Cloud: Building Distributed Applications • Workarounds have been devised • E.g. Polling – Client continuously polls the server stamp for the next time he wants to send a letter. © Joe Mertz – Mobile to Cloud: Building Distributed Applications • Provides for true two-way ongoing communication between a client and server. Note: – Some old browsers don't implement WebSockets © Joe Mertz – Mobile to Cloud: Building Distributed Applications // Create a new WebSocket var wSocket = new WebSocket("ws://www.example.com/socketserver")

program for a supercomputer? Introduce PGAS Model, RDMA Building Remote Pointer Types Building Distributed Data Structures Extending to GPUsThis Talk Background: how do we write a program for a supercomputer supercomputer? Introduce PGAS Model, RDMA Building Remote Pointer Types Building Distributed Data Structures Extending to GPUsThis Talk Background: how do we write a program for a supercomputer? Introduce Introduce PGAS Model, RDMA Building Remote Pointer Types Building Distributed Data Structures Extending to GPUsThis Talk Background: how do we write a program for a supercomputer? Introduce PGAS Model

Firebird Null Guide NULL behaviour and pitfalls in Firebird SQL Paul Vinkenoog Version 1.2, 30 June 2020 Table of Contents 1. What is NULL? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2. NULL support in Firebird SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . operations will render the entire expression NULL. This guide explores the behaviour of NULL in Firebird SQL, points out common pitfalls and shows you how to deal safely with expressions that contain NULL or

'dbListResults_SQLiteConnection.R' 'dbListTables_SQLiteConnection.R' 'dbQuoteIdentifier_SQLiteConnection_SQL.R' 'dbQuoteIdentifier_SQLiteConnection_character.R' 'dbReadTable_SQLiteConnection_character.R' 'db 'dbSendQuery_SQLiteConnection_character.R' 'dbUnloadDriver_SQLiteDriver.R' 'dbUnquoteIdentifier_SQLiteConnection_SQL.R' 'dbWriteTable_SQLiteConnection_character_character.R' 'dbWriteTable_SQLiteConnection_character_data Needed for compatibility with generic. Otherwise ignored. field.types character vector of named SQL field types where the names are the names of new table’s columns. If missing, types inferred with DBI::dbDataType())

implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public Data Manipulation Language: ........................................................ 13 DQL - Data Query Language: .................................................................. 14 SQLite Installation .............................................................................. 35 SQLite Insert Query ............................................................... 36 Syntax: .....................