Tag: Database
-
Geospatial queries, reinvented
Posted on December 12, 2019, Level interemediate Resource Length long
In this article author goes through the details of how Beat managed to achieve lightning fast queries during the driver dispatching process; getting the nearest driver to a passenger. by Fotis Papadopoulos.
Tags software-architecture google data-science database
-
Building a distributed time-series database on PostgreSQL
Posted on October 18, 2019, Level intermediate Resource Length long
TimescaleDB, a time-series database on PostgreSQL, has been production-ready for over two years, with millions of downloads and production deployments worldwide. Authors publicly shared their design, plans, and benchmarks for the distributed version of TimescaleDB. By Mike Freedman and Erik Nordström.
Tags database software-architecture distributed performance
-
Managing hundreds of millions of orders with Table Store
Posted on September 16, 2019, Level intermediate Resource Length medium
This article discusses how Table Store can help you store and manage massive amounts of data by using a fictional e-commerce platform as an example.
Tags mysql database performance how-to cloud
-
To run or not to run a database on Kubernetes: What to consider
Posted on July 21, 2019, Level beginner Resource Length short
Benjamin Good, Solutions Architect, Google Cloud, wrote this piece in which he considers if you should run a database on Kubernetes. Today, more and more applications are being deployed in containers on Kubernetes—so much so that we've heard Kubernetes called the Linux of the cloud.
Tags database devops kubernetes google
-
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