Remove 2006 Remove Database Remove Scalability Remove Tuning
article thumbnail

Upcoming Webinar Tuesday, 7/31: Using MySQL for Distributed Database Architectures

Percona

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Such architectures bring many benefits (such as scalability and resiliency), but can also bring a lot of pain if incorrectly designed and executed.

article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. However, ClickHouse is super efficient for timeseries and provides “sharding” out of the box (scalability beyond one node).

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

© ​​ 2006 ​​ Microsoft Corporation. KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? ​​ All rights reserved.

Servers 40