2013, Blog, Database and Scalability - Technology Performance Pulse

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

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. Connection id: 2 Current database: db1 + -+ -+ | id | username | + -+ -+ | 1 | user1 | | 2 | user2 | + -+ -+ 2 rows in set (0.01 Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00

Servers

Servers Storage Database Open Source

MariaDB vs MySQL: Key Differences and Use Cases

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). What is MariaDB? Elevate your MariaDB environment with Percona Support for MariaDB. Contact us to learn more!

Open Source

Open Source Servers Storage Scalability

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. This blog article traces key developments that coincided with MongoDB’s move away from open source software, and it examines how SSPL influence might have lured others in the same direction.

Open Source

Open Source Programming Database Servers

Back-to-Basics Weekend Reading - Join Processing in Relational.

All Things Distributed

APRIL 12, 2013

Werner Vogels weblog on building scalable and robust distributed systems. Back-to-Basics Weekend Reading - Join Processing in Relational Databases. By Werner Vogels on 12 April 2013 04:00 AM. Joins are one of the fundamental relational database query operations. blog comments powered by Disqus. Comments ().

Processing

Processing Database Efficiency Scalability

Exerting Fine Grain Control Over Your Cloud Resources - All Things.

All Things Distributed

JULY 7, 2013

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 07 July 2013 06:30 PM. As customers move increasing amounts of compute and database workloads over to AWS, they have expressed an increased desire for finer grain control over their underlying resources. Comments (). productionâ??

Cloud

Cloud AWS Database Scalability

Back-to-Basics Weekend Reading - Epidemics - All Things Distributed

All Things Distributed

JANUARY 25, 2013

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 25 January 2013 06:00 PM. My paper to read this weekend was the Alan Demers seminal paper on epidemic techniques for database replication. reliable and scalable distributed systems. scalable distributed systems.

Database

Database Scalability C++ Systems

Back-to-Basics Weekend Reading - Principles of Transaction.

All Things Distributed

MARCH 29, 2013

Werner Vogels weblog on building scalable and robust distributed systems. Back-to-Basics Weekend Reading - Principles of Transaction-Oriented Database Recovery. By Werner Vogels on 29 March 2013 03:30 PM. A good early paper to start again is the Survey that HÃ¤rder en Reuter did on Database Recovery in 1983. Comments ().

Database

Database Scalability Engineering Systems

Back-to-Basics Weekend Reading - Practical Applications of.

All Things Distributed

APRIL 5, 2013

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 05 April 2013 08:30 AM. At the end of the 80s Ceri and Widom were researching the fundamentals of integrity constraints in databases. blog comments powered by Disqus. Comments (). Contact Info. Werner Vogels. CTO - Amazon.com.

Scalability

Scalability Database Systems

Expanding the Cloud: Faster, More Flexible Queries with DynamoDB

All Things Distributed

APRIL 17, 2013

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 17 April 2013 10:30 AM. This gives you the ability to perform richer queries while still meeting the low-latency demands of responsive, scalable applications. All Things Distributed. Comments (). Today, Iâ??m As an example, letâ??s

Cloud

Cloud Latency Games Scalability

Elastic Beanstalk a la Node - All Things Distributed

All Things Distributed

MARCH 11, 2013

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 11 March 2013 04:00 PM. These developers typically use EC2 instances combined with one of our database services to create web services used for data retrievals or to create dynamic mobile interfaces. blog comments powered by Disqus.

AWS

AWS Mobile Games Java

InnoDB Performance Optimization Basics

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance

Performance Hardware Tuning Storage

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

Percona

JULY 30, 2018

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.

Architecture

Architecture Database Open Source Internet

How To Choose a Website Builder For Your Web Development Company?

Official Blog - World Web Technology

NOVEMBER 27, 2023

To create a personal blog, you’ll need a drag-and-drop editor. It should have built-in auto-save and premade blogging themes. Other features include templates, drag-and-drop service, e-commerce and blogging, mobile responsiveness, and integrated hosting. Shopify introduced its feature – Shopify Payments in 2013.

Website

Website Development Mobile Storage

DynamoDB One Year Later - All Things Distributed

All Things Distributed

MARCH 7, 2013

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 07 March 2013 08:00 PM. Many of our customers have, with the click of a button, created DynamoDB deployments in a matter of minutes that are able to serve trillions of database requests per year. All Things Distributed. Comments ().

Ecommerce

Ecommerce Storage Scalability Hardware

Taking DynamoDB beyond Key-Value: Now with Faster, More Flexible, More Powerful Query Capabilities

All Things Distributed

DECEMBER 12, 2013

We launched DynamoDB last year to address the need for a cloud database that provides seamless scalability, irrespective of whether you are doing ten transactions or ten million transactions, while providing rock solid durability and availability. Since then, we have been working on adding flexible querying. Going beyond Key-Value.

Games

Games Scalability Database Retail

Expanding the Cloud - Introducing AWS OpsWorks, a Powerful.

All Things Distributed

FEBRUARY 18, 2013

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 18 February 2013 11:30 PM. For example, you can create an application that consists of multiple Python apps installed on Django connected to a CouchDB database. For a hands-on overview of AWS OpsWork visit the AWS developer blog.

AWS

AWS Cloud Architecture Infrastructure

Should You Use ClickHouse as a Main Operational Database?

Percona

JANUARY 14, 2019

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

Database

Database Analytics Blockchain Healthcare

Technology Performance Pulse

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

MariaDB vs MySQL: Key Differences and Use Cases

Trending Sources

Is MongoDB Open Source? Is Planet Earth Flat?

Back-to-Basics Weekend Reading - Join Processing in Relational.

Exerting Fine Grain Control Over Your Cloud Resources - All Things.

Back-to-Basics Weekend Reading - Epidemics - All Things Distributed

Back-to-Basics Weekend Reading - Principles of Transaction.

Back-to-Basics Weekend Reading - Practical Applications of.

Expanding the Cloud: Faster, More Flexible Queries with DynamoDB

Elastic Beanstalk a la Node - All Things Distributed

InnoDB Performance Optimization Basics

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

How To Choose a Website Builder For Your Web Development Company?

DynamoDB One Year Later - All Things Distributed

Taking DynamoDB beyond Key-Value: Now with Faster, More Flexible, More Powerful Query Capabilities

Expanding the Cloud - Introducing AWS OpsWorks, a Powerful.

Should You Use ClickHouse as a Main Operational Database?

Stay Connected