New ask Hacker News story: Ask HN: Best stack for local data with remote long term storage
Ask HN: Best stack for local data with remote long term storage
3 by aetherspawn | 1 comments on Hacker News.
Hi, I have a small database box sitting in company A with a small amount of storage (i.e. 10GB). In my company B, which has only about 99.00% uptime with company A (which has a slow internet connection), I have virtually unlimited storage and computing power. I was wondering if anyone has ever heard of a database architecture that allows company A to host their local data until their database becomes too large, and then offloads rarely used rows to company B. Preferably, at that point, most common queries for recent data wouldn't need to hit company B. It would also be nice if company B retained a non-ACID backup of company A, so that if company A has a hard drive failure, at most no more than a few hours of data might be lost. What is this architecture called? Are there any open source solutions that support it?
3 by aetherspawn | 1 comments on Hacker News.
Hi, I have a small database box sitting in company A with a small amount of storage (i.e. 10GB). In my company B, which has only about 99.00% uptime with company A (which has a slow internet connection), I have virtually unlimited storage and computing power. I was wondering if anyone has ever heard of a database architecture that allows company A to host their local data until their database becomes too large, and then offloads rarely used rows to company B. Preferably, at that point, most common queries for recent data wouldn't need to hit company B. It would also be nice if company B retained a non-ACID backup of company A, so that if company A has a hard drive failure, at most no more than a few hours of data might be lost. What is this architecture called? Are there any open source solutions that support it?
Comments
Post a Comment