article thumbnail

Auto-Increment Counter Persistence in MySQL 8: Comparing the Evolution From MySQL 5.7

Percona

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. sec) service mysql restart mysql> select * from users; ERROR 2006 (HY000): MySQL server has gone away No connection. Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00 Trying to reconnect.

Servers 113
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.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Expanding the Cloud - Amazon S3 Reduced Redundancy Storage.

All Things Distributed

Werner Vogels weblog on building scalable and robust distributed systems. Amazon Simple Storage Service (S3) was launched in 2006 as "Storage for the Internet" with the promise to make web-scale computing easier for developers. a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications.

Storage 72
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
article thumbnail

Data Mining Problems in Retail

Highly Scalable

To a certain extent, such a high diversity of recommendation techniques is attributed to several implementation challenges like a sparsity of customer ratings, computational scalability, and lack of information on new items and customers. Thomas, 2006. FAD74] Conditional logit analysis of qualitative choice behavior, D. McFadden, 1974.

Retail 152
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).