© 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 of Thousands of Updates/Sec Traverse Tens of Millions of Rows/Sec Comfortably Handle Several TB Database size © 2018 Percona. 7 Lets Do Some Math 100.000 QPS 10 Queries per User Interaction 10 Paired with Replicated Data © 2018 Percona. 24 Where Replication Happens Storage Level Database Level Application Level © 2018 Percona. 25 Storage Level Replication Replication in SAN/NAS

MaterializeMySQL Database engine in ClickHouse WinterZhang(张健) About me • Active ClickHouse Contributor • MaterializeMySQL Database Engine • Custom HTTP Handler • MySQL Database Engine • BloomFilter query MySQL Database Engine • Mapping to MySQL database • Fetch table list from MySQL • Fetch table struct from MySQL • Fetch data from MySQL when execute query MaterializeMySQL Database Engine • to MySQL database • Consume MySQL BINLOG and store to MergeTree • Experimental feature (20.8, recommend latest stable version) MaterializeMySQL Database Engine MaterializeMySQL Database Engine

Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Database Structure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 3. Standard Database Page Header. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4. Database Header Page — Type 0x01

TIDB THE LARGE SCALE RELATIONAL DATABASE SOLUTION PRODUCT REVIEW 2022 Piloting tomorrow’s creativity https://www.iconic.inc Iconic Data Japan (IDJ) is a multi-national data services company that ICONIC DATA, DATATECH ICONIC DATA © ALL RIGHTS RESERVED. 1 AS A SOLUTION TIDB 2 TiDB is a new database solution that is targeted primarily to clients that need to handle very large databases, with very very large frequency of queries. If those two problems describe your business then this database solution is very attractive, as it also features a number of other features that make it stand out from

Introduction 1 Differences between database auditing and the audit plugin 1 Obtain the database auditing feature 2 The range of database auditing 2 The events of database auditing 3 Recorded information 20 RESTRICTED_AUDIT_ADMIN 20 Migration from audit plugin to database auditing 20 TiDB Database Auditing User Guide Introduction Database auditing is an important feature in TiDB Enterprise Edition, the data security and compliance for enterprises. The database auditing feature can help managers in enterprises track the source and impact of database operations to ensure that data would not be illegally

1 SQLite, Firefox, and our small IMDB movie database CS3200 Database design (sp18 s2) Version 1/17/2018 2 Overview • This document covers 2 issues: • How to install SQLite manager in Firefox browser: the most widely used database. For example, Firefox uses it to store your book marks. You are going to install a small tool that allows you to explicitly create and manage a database with Firefox. • How How to load the small IMDB movie database: • I posted a small file that contains subset of data from the IMDB movie website ("300 – Small IMDB - SQLite.sql"). You will upload these data into your local

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases