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 40

Database Analytics Blockchain Healthcare 40

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. In a sharded cluster, each shard acts as an independent database responsible for storing and managing specific data.

Best Practices 71

Best Practices Traffic Database Servers 71

High Scalability

NOVEMBER 30, 2018

during the 2017-18 academic year, on top of a 3.3% The scalability of a native graph database. Don't miss all that the Internet has to say on Scalability, click below and become eventually consistent with all scalability knowledge (which means this post has many more items to read so please keep on reading).

Internet 28

Internet Internet Scalability Blockchain 28

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2017: MongoDB goes public, trading as MDB.

Open Source 81

Open Source Programming Database Servers 81

SQL Performance

FEBRUARY 12, 2020

I'll continue using the sample database TSQLV5 like last month in some of my examples. You can find the script that creates and populates this database here , and its ER diagram here. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. DISTINCT predicate. 11063 2019-05-06 11067 2019-05-06 11069 2019-05-06.

C++ 120

C++ Code Servers Database 120

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. A Query Execution Plan is the way a database chooses to run a specific query. Before looking at the problematic query, I will walk you through a little detail about the optimizer.

Efficiency 100

Efficiency Database Open Source Performance 100

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 83

Availability Open Source Architecture Database 83

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. TPC-H Benchmark Results with SQL Server 2017. HPE has already submitted a new official TPC-H result on SQL Server 2017 for a single-socket, HPE Proliant DL325 Gen10 1U server that was 743,750 QphH@1000GB. TPC-E Benchmark Results with SQL Server 2017. Conclusion.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. It also enables geographically distributed databases for disaster recovery.

Servers 52

Servers Database Availability Traffic 52

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. These benefits collectively contribute to a more efficient database environment.

Strategy 40

Strategy Storage Database Best Practices 40

O'Reilly Software

APRIL 4, 2018

Google was among the pioneers that created “web scale” architectures to analyze the massive data sets that resulted from “crawling” the web that gave birth to Apache Hadoop, MapReduce, and NoSQL databases. The data shape will dictate capacity planning, tuning of the backbone, and scalability analysis for individual components.

Architecture 80

Architecture Scalability Google Operating System 80

ScaleOut Software

MAY 4, 2018

The following diagram depicts a typical stream processing pipeline processing events from many data sources: More recent stream-processing platforms, such as Apache Flink , have incorporated stateful stream processing into their architectures in the form of key-value stores or databases that the application can make use of to enhance its analysis.

Processing 40

Processing IoT Programming Software Engineering 40

ScaleOut Software

MAY 4, 2018

The following diagram depicts a typical stream processing pipeline processing events from many data sources: More recent stream-processing platforms, such as Apache Flink , have incorporated stateful stream processing into their architectures in the form of key-value stores or databases that the application can make use of to enhance its analysis.

Processing 40

Processing IoT Programming Software Engineering 40

Enprowess

JANUARY 12, 2022

Twitter Lite PWA : It was integrated as the standard User Interface in 2017. The main advantages are as follows: Benefits of Serverless Architecture: Enhanced scalability and app flexibility. Blockchain technology is an encrypted database storage system. Pinterest PWA: Pins increased by 401%. AI-powered Chatbots.

Blockchain 59

Blockchain IoT Development Serverless 59

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 128

Internet Internet AWS Performance 128

Smashing Magazine

JANUARY 7, 2019

Representational State Transfer ( REST ) is a well-established, logical choice: it defines a set of constraints that developers follow to make content accessible in a performant, reliable and scalable fashion. An interesting way of avoiding parsing costs is to use binary templates that Ember has introduced in 2017. Bundle Buddy.

Performance 104

Performance Cache Metrics Network 104