4 ms·

From the article : After spending multiple hours on the phone with our cloud service provider, it appears we hit a system limit for our hosted database that’s

by msh 10y ago

From the article : After spending multiple hours on the phone with our cloud service provider, it appears we hit a system limit for our hosted database that’s preventing new articles from being saved. At this time, our only option is to export all data from our old database and import it into a new one. Seems pretty bad that it takes hours to discover that. Anyone knows what cloud it is?

nanaujal 10y ago
instapaper.com seems to be hosted @ AWS
- bhouston 10y ago
  Which DB at AWS: https://aws.amazon.com/products/databases/ https://aws.amazon.com/products/databases/ Also shouldn't AWS warn them that this was about to happen? Edit 1: DynamoDB says: "There is no practical limit on a table's size. Tables are unconstrained in terms of the number of items or the number of bytes." The SQL databases say this: "The Amazon Aurora engine will automatically grow the size of your database volume as your database storage needs grow, up to a maximum of 64 TB or a maximum you define. The MySQL, MariaDB, Oracle, and PostgreSQL engines allow you to provision up to 6 TB of storage on-the-fly with zero downtime." So they either hit 64TB or 6TB of data I assume? EDIT 2: According to this they are MySQL based: https://medium.com/making-instapaper/rebuilding-instapaper-search-7fae1340699e#.svigv748s https://medium.com/making-instapaper/rebuilding-instapaper-s...
  - gagabity 10y ago
    Think you need to set up CloudWatch to get alerts.
    - dhd415 10y ago
      And CloudWatch is free for RDS at 5-minute collection intervals which is more than adequate for alerting on things such as "Am I about to hit the space limit on my database?"
  - dexterdog 10y ago
    They could be on aurora though since many people just consider it to be mysql. It's a pretty painless migration from mysql as long as you are 5.6 or below. You can just replicate over to it live.
- deleted 10y ago
  [deleted]

by msh 10y ago

nanaujal 10y ago

instapaper.com seems to be hosted @ AWS

bhouston 10y ago
Which DB at AWS: https://aws.amazon.com/products/databases/ https://aws.amazon.com/products/databases/ Also shouldn't AWS warn them that this was about to happen? Edit 1: DynamoDB says: "There is no practical limit on a table's size. Tables are unconstrained in terms of the number of items or the number of bytes." The SQL databases say this: "The Amazon Aurora engine will automatically grow the size of your database volume as your database storage needs grow, up to a maximum of 64 TB or a maximum you define. The MySQL, MariaDB, Oracle, and PostgreSQL engines allow you to provision up to 6 TB of storage on-the-fly with zero downtime." So they either hit 64TB or 6TB of data I assume? EDIT 2: According to this they are MySQL based: https://medium.com/making-instapaper/rebuilding-instapaper-search-7fae1340699e#.svigv748s https://medium.com/making-instapaper/rebuilding-instapaper-s...
- gagabity 10y ago
  Think you need to set up CloudWatch to get alerts.
  - dhd415 10y ago
    And CloudWatch is free for RDS at 5-minute collection intervals which is more than adequate for alerting on things such as "Am I about to hit the space limit on my database?"
- dexterdog 10y ago
  They could be on aurora though since many people just consider it to be mysql. It's a pretty painless migration from mysql as long as you are 5.6 or below. You can just replicate over to it live.
deleted 10y ago
[deleted]