Tagged | DBMS

Abstracting Sharding with Vitess and Distributed Deadlocks
(medium.com)
#DBMS #scaling #distributed-systems #MySql
Splitting Stateful Services across Continents at Instagram
(www.infoq.com)
#DBMS #scaling #distributed-systems #big-data
MySQL High Availability On-Premises: A Geographically Distributed Scenario
(www.percona.com)
#DBMS #scaling #distributed-systems #MySql
How We Built a Cost-Based SQL Optimizer
(www.cockroachlabs.com)
#software-architecture #DBMS #SQL
Netflix MediaDatabase — Media Timeline Data Model
(medium.com)
#software-architecture #DBMS #scaling #big-data #media
Sharding Cash
(medium.com)
#software-architecture #DBMS #scaling #backend
Scaling Time Series Data Storage — Part II
(medium.com)
#DBMS #noSQL #scaling #time-series
Presentation: Reactive Relational Database Connectivity
(www.infoq.com)
#DBMS #API #reactive
More Efficient Range Scan Paging with Scylla 3.0
(www.scylladb.com)
#DBMS #noSQL #performance #internals #systems
Why you should avoid ORMs (with examples in Node.js)
(blog.logrocket.com)
#software-design #DBMS #backend #opinion
An Introduction to Join Ordering
(www.cockroachlabs.com)
#DBMS #SQL #cockroachDB #internals
SQL at Scale with Apache Spark SQL and DataFrames — Concepts, Architecture and Examples
(towardsdatascience.com)
#DBMS #scaling #apache-spark #SQL
Causal guarantees are anything but casual
(engineering.mongodb.com)
#DBMS #noSQL #distributed-systems #mongoDB
Benchmarking Google BigQuery at Scale
(techblog.king.com)
#DBMS #performance #cloud #GCE
The Netflix Media Database (NMDB)
(medium.com)
#DBMS #scaling #distributed-systems
Managing data store locality at scale with Akkio
(code.fb.com)
#DBMS #distributed-systems #big-data #systems
Scaling PostgreSQL using Connection Poolers and Load Balancers for an Enterprise Grade environment
(www.percona.com)
#DBMS #performance #scaling #PostgreSQL
How We Store Data in the Cloud at Auth0
(auth0.com)
#software-architecture #infra #DBMS
turtleDB: A JavaScript Framework for building offline-first, collaborative web apps
(hackernoon.com)
#javascript #DBMS #browsers
Introducing HaloDB, a fast, embedded key-value storage engine written in Java
(yahooeng.tumblr.com)
#DBMS #noSQL #java #kv-store
Goku: Building a scalable and high performant time series database system
(medium.com)
#software-architecture #DBMS #noSQL #scaling #time-series
The Anna Key-Value Store Now Has 355x the Performance of DynamoDB for the Dollar
(highscalability.com)
#DBMS #noSQL #performance #kv-store
Iterating Towards a More Scalable Ingress
(shopifyengineering.myshopify.com)
#software-architecture #DBMS #scaling #backend
Improving Point-Lookup Using Data Block Hash Index
(rocksdb.org)
#software-architecture #DBMS #algorithms #performance #data-structures
Explain Like I'm Five: Poison Records (Honeypots for Database Tables)
(hackernoon.com)
#DBMS #security
TimescaleDB vs. InfluxDB: purpose built differently for time-series data
(blog.timescale.com)
#software-architecture #DBMS #noSQL #time-series
Zero Downtime Table Migrations using a Double Write Methodology
(engineering.gusto.com)
#DBMS #migration #backend #availability
Tuning Autovacuum in PostgreSQL and Autovacuum Internals
(www.percona.com)
#DBMS #PostgreSQL #internals
Developing a Bioinformatics Database for Disulfide Bonds Research
(www.toptal.com)
#DBMS #big-data #biotech
SQL vs. Flux: Choosing the right query language for time-series data
(blog.timescale.com)
#DBMS #programming-languages #SQL
Exploring How the Scylla Data Cache Works
(www.scylladb.com)
#DBMS #internals #caching #scyllaDB
Herb: Multi-DC Replication Engine for Uber’s Schemaless Datastore
(eng.uber.com)
#software-architecture #DBMS #noSQL #distributed-systems
More Efficient Query Paging with Scylla 2.2
(www.scylladb.com)
#DBMS #performance #internals #scyllaDB
Have Your Postgres Cake with Amazon Redshift and eat it, too.
(hackernoon.com)
#DBMS #AWS #PostgreSQL #cloud
Optimizing queries on TimescaleDB hypertables with thousands of partitions
(blog.timescale.com)
#DBMS #performance #optimisation #time-series
Presentation: The Future of Distributed Databases Is Relational
(www.infoq.com)
#DBMS #distributed-systems #big-data
The Impact of Virtualization on Your Database
(www.scylladb.com)
#DBMS #performance #virtualisation
To Shard, or Not To Shard: That Was The Holiday 2017 Question
(tech.wayfair.com)
#software-engineering #DBMS #SQL
Article: Picking an Active-Active Geo Distribution Strategy: Comparing Merge Replication and CRDT
(www.infoq.com)
#software-architecture #DBMS #distributed-systems
What Write Skew Looks Like
(www.cockroachlabs.com)
#DBMS #systems #filesystem
How to store time-series data in MongoDB, and why that's a bad idea
(blog.timescale.com)
#DBMS #mongoDB #time-series
Implementing and Testing the Bulk Insert/Save Pattern in MongoDB
(engineering.vena.io)
#DBMS #java #mongoDB
MongoDB Indexes and Performance
(hackernoon.com)
#DBMS #noSQL #mongoDB #internals
A Look at MyRocks Performance
(www.percona.com)
#monitoring #DBMS #performance #SQL
A Massively Multi-user Datastore, Synced with Mobile Clients
(medium.com)
#software-architecture #DBMS #synchronisation
An Introduction to PostgreSQL Materialized Views
(spin.atomicobject.com)
#DBMS #PostgreSQL
KSQL in Action: Enriching CSV Events with Data from RDBMS into AWS
(www.confluent.io)
#DBMS #data-stream #apache-kafka
Searching for Solr
(tech.findmypast.com)
#DBMS #search #apache-solr
Geo-Partitioning: What Global Data Actually Looks Like
(www.cockroachlabs.com)
#DBMS #distributed-systems #partitioning
Distributed transactions and why you should care
(towardsdatascience.com)
#DBMS #distributed-systems
Learn How to Build a Time Series Database
(www.scylladb.com)
#DBMS #noSQL #time-series
MarketStore, the financial time series database, is now open source
(hackernoon.com)
#DBMS #time-series #GoLang #fintech
Database Migrations: Turning Caterpillars into Butterflies
(www.toptal.com)
#DBMS #migration
Code Migration in Production: Rewriting the Sharding Layer of Uber’s Schemaless Datastore
(eng.uber.com)
#software-architecture #DBMS #migration
Adventures with Memory Barriers and Seastar on Linux
(www.scylladb.com)
#DBMS #distributed-systems #Linux #systems
How we built rearranging Pins
(medium.com)
#infra #DBMS #scaling
Making 30x performance improvements on Yelp’s MySQLStreamer
(engineeringblog.yelp.com)
#data-pipeline #DBMS #optimisation #MySql
Fun with Views and CTEs
(hashrocket.com)
#dev-tools #DBMS #SQL
Scaling Time Series Data Storage — Part I
(medium.com)
#DBMS #scaling #time-series #big-data
Partitioning in PostgreSQL
(engineering.semantics3.com)
#DBMS #PostgreSQL #partitioning
Faster E-commerce Search
(www.ebayinc.com)
#DBMS #search #performance #big-data
Postgres Internals: Building a Description Tool
(www.dataquest.io)
#DBMS #PostgreSQL #internals
Generated Columns and ProxySQL Instead of Referenced Tables
(www.percona.com)
#DBMS #performance #optimisation #MySql
App Directory: MongoDB to SQL
(code.hootsuite.com)
#DBMS #MySql #mongoDB
What if I told you database indexes could be learned?
(towardsdatascience.com)
#machine-learning #DBMS #research
Large-Scale Health Data Analytics with OHDSI
(blog.cloudera.com)
#DBMS #data-analytics #big-data
How machine learning will accelerate data management systems
(www.oreilly.com)
#machine-learning #DBMS #big-data #podcast
Our Top 4 Tips for Massive Data Migrations
(engineering.salesforce.com)
#DBMS #migration #backend
Hands-On Look at ZFS with MySQL
(www.percona.com)
#DBMS #MySql #systems #filesystem #ZFS
An Introduction to MySQL Indexes
(www.vertabelo.com)
#DBMS #performance #MySql
Analyzing the Performance of Millions of SQL Queries When Each One is a Special Snowflake
(heap.engineering)
#DBMS #performance #SQL #analytics
Snapfish’s Journey Towards Scylla
(www.scylladb.com)
#DBMS #scaling #backend #scyllaDB
How Hinted Handoff Works in Scylla
(www.scylladb.com)
#DBMS #noSQL #distributed-systems #scyllaDB
Fundamentals of System Design — Part 3
(hackernoon.com)
#DBMS #systems
Partition and conquer
(evilmartians.com)
#DBMS #RoR #scaling #PostgreSQL #partitioning
Scalable, Distributed Secondary Indexing in Scylla
(www.scylladb.com)
#DBMS #noSQL #distributed-systems #internals #scyllaDB
MySQL vs. MariaDB: Reality Check
(www.percona.com)
#DBMS #MySql #MariaDB
Row Stores vs. Column Stores: Why not use both?
(code.hootsuite.com)
#software-architecture #DBMS #noSQL #opinion
Executing Parallel Statements to Improve Performance
(www.cockroachlabs.com)
#DBMS #performance #cockroachDB #systems #parallel-computing
Time-series data: PostgreSQL 10 vs. TimescaleDB
(blog.timescale.com)
#DBMS #performance #time-series #PostgreSQL
Bad Practices in Database Design: Are You Making These Mistakes?
(www.toptal.com)
#DBMS #SQL #practices
Building Computed Fields in a Biological Database
(benchling.engineering)
#software-architecture #DBMS #biotech
To SQL or not to SQL
(capgemini.github.io)
#DBMS #noSQL #SQL
Why SQL is beating NoSQL, and what this means for the future of data
(blog.timescale.com)
#DBMS #noSQL #scaling #SQL #history
Migrating a database from InnoDB to MyRocks
(code.facebook.com)
#DBMS #MySql #migration #availability
Evolution of data structures in Yandex.Metrica
(highscalability.com)
#DBMS #algorithms #search #data-structures
Looking at Disk Utilization and Saturation
(www.percona.com)
#monitoring #DBMS #performance #MySql
Leveraging the Power of a Database ‘Unbundled’
(www.confluent.io)
#DBMS #noSQL #distributed-systems #microservices
MySQL Has Transactions, Sorta
(hashrocket.com)
#DBMS #SQL #MySql #PostgreSQL
Migrating From Oracle to Espresso
(engineering.linkedin.com)
#DBMS #noSQL #distributed-systems #migration
Choose PostgreSQL for IoT
(blog.timescale.com)
#DBMS #IoT #PostgreSQL
BigDB - an ad data pipeline for LINE
(engineering.linecorp.com)
#data-pipeline #infra #DBMS #big-data
MongoDB Indexing Types: How, When and Where Should They Be Used?
(www.percona.com)
#DBMS #noSQL #mongoDB
Implementing Unicode Collation in CockroachDB
(www.cockroachlabs.com)
#DBMS #unicode #cockroachDB
MySQL infrastructure testing automation at GitHub
(githubengineering.com)
#monitoring #infra #DBMS #MySql
Image Recognition at the Speed of Memory Bandwidth
(blog.memsql.com)
#image-processing #DBMS
Presto - a small step for DevOps engineer but a big step for BigData analyst
(allegro.tech)
#data-pipeline #infra #DBMS #distributed-systems
Level-based Compaction Changes
(rocksdb.org)
#DBMS #algorithms #noSQL
The Limits of the CAP Theorem
(www.cockroachlabs.com)
#DBMS #noSQL