Tag: Database
-
Look at how Twitter handles its time series data ingestion challenges
Posted on June 11, 2019, Level intermediate Resource Length short
Ram Dagar is author of this overview on the time series topic. The components of time-series are as complex and sophisticated as the data itself. With increasing time, the data obtained increases and it doesn't always mean that more data means more information but, larger sample avoids the error that due to random sampling.
Tags devops database machine-learning data-science software
-
Indexes bad practices
Posted on June 1, 2019, Level beginner Resource Length medium
In this article author will discuss secondary indexes common mistakes and bad practices. While the article is focused on MySQL and the InnoDB storage engine, most of this information applies to any DBMS. Published by Federico Razzoli.
Tags database mysql miscellaneous linux
-
Exposing MyRocks internals via system variables: data writing
Posted on May 31, 2019, Level intermediate Resource Length medium
Peter Sylvester wrote this blog post about new storage engine for MySQL that's rising in popularity. MyRocks, the log-structured merge-driven RocksDB engine in MySQL.
Tags database mysql miscellaneous
-
Building stateful apps with serverless functions and Postgres
Posted on April 2, 2019, Level intermediate Resource Length medium
Tirumarai Selvan, Product Lead at Hasura, published this guide which explores the different ways to deal with application state when writing business logic in serverless functions. Author uses Postgres as the database when talking about these different approaches, and often use Hasura as one of the glue solutions between your serverless functions and your Postgres database.
Tags database microservices nosql servers distributed apis
-
Code Migration in Production: Rewriting the Sharding Layer of Uber's Schemaless Datastore
Posted on March 20, 2019, Level intermediate Resource Length medium
An older article by Jesper Lindstrøm Nielsen and Anders Johnsen about how Uber Engineering built Schemaless, their fault-tolerant and scalable datastore, to facilitate the rapid growth of our company.
Tags database data-science nosql
-
MySQL high availability framework explained – part one
Posted on February 24, 2019, Level intermediate Resource Length medium
This is three-part blog series, in which author explains the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semisynchronous replication and the Corosync plus Pacemaker stack. Published by Prasad Nagaraj VP Engineering at ScaleGrid.
Tags mysql database software devops
-
High availability and scalable reads in PostgreSQL
Posted on January 1, 2019, Level intermediate Resource Length long
A detailed primer on scaling PostgreSQL via streaming replication (with performance measurements) by Lee Hampton -- R&D Engineer at TimescaleDB. Despite popularity of PostgreSQL developers often still choose a non-relational (or "NoSQL") system over PostgreSQL, typically because of one reason: scale. Most developers still underestimate PostgreSQL native scalability.
Tags programming database servers distributed cio
-
10 MySQL database tuning tips for peak workloads
Posted on November 17, 2018, Level intermediate Resource Length long
Folks from MariaDB wrote this article in which they collated 10 MySQL tuning tips for peak workloads. As we head into the holiday season and the start of a new year, now is a great time to ensure your database is ready for whatever comes its way.
Tags mysql database performance
-
Trying out Containerized Applications on Apache Hadoop YARN 3.1
Posted on May 20, 2018, Level intermediate Resource Length medium
Shane Kumpf & Vinod Kumar Vavilapalli & Saumitra Buragohain from Hortonworks wrote series of articles about Hadoop. This is the 5th blog of this seres and in this blog, they will explore running Docker containers on YARN for faster time to market and faster time to insights for data intensive workloads at scale.
Tags big-data data-science database
-
Storing data in DNA
Posted on January 27, 2018, Level beginner Resource Length medium
MIT technology review article about storing data in DNA and how this can be a lot easier than getting it back out. Humanity is creating information at an unprecedented rate—some 16 zettabytes every year (a zettabyte is one billion terabytes). Last year, the research group IDC calculated that we'll be producing over 160 zettabytes every year by 2025.
Tags database programming
-
Why AWS DynamoDB is not for everyone
Posted on January 10, 2018, Level beginner Resource Length long
Cloud architect Forrest Brazeal wrote intriguing article in which he considers shortcomings and advantages of DynamoDB. He interviewed a number of engineers and developers about their experiences with the database service. As great as DynamoDB is -- and as rousing as its success stories are -- it has also left plenty of failed implementations in its wake.
Tags nosql aws database
-
MySQL vs. MariaDB: Reality check
Posted on January 4, 2018, Level beginner Resource Length long
Colin Charles published extensive comparison between MySQL vs. MariaDB (including Percona Server for MySQL). His goal was to evaluate, at a higher level, MySQL, MariaDB and Percona Server for MySQL side-by-side to better inform the decision making process. It is largely an unofficial response to published comments from the MariaDB Corporation.
Tags mysql database software