SteemSQL - Planned maintenance

in #steemsql6 years ago

SteemSQL has been massively adopted by a lot of users for analytical processing and even for running bots, apps or dapps.

For some time now, SteemSQL struggle with available disk space in order to keep running. Indeed, it has to manage with an everyday growing amount of data.

The result is that the the database size is now really really close to the storage capacity (RAID with 2 enterprise class 1.2 TB NVMe disks )

Fortunately, I already ordered new 2TB NVMe disks to double the actual storage capacity.
But, in addition to being extremely expensive, these disks are also difficult to obtain. Meantime, I had to remove some indexes and even some non-transactional tables from the database.

The good news is that the drives have finally arrived and I’m now able to upgrade the infrastructure.

SteemSQL will be under maintenance

from 2019-01-26 08:00 UTC until 2019-01-27 22:00 UTC.



Yes, it's almost two full days, but there is a lot to do and the amount of data to handle is quite substantial.

This maintenance will have the following impact:

  • SteemSQL server will stay available but might not be as responsive as usual.
  • Loss of connection may occur.
  • SteemSQL might be out of sync with the blockchain from time to time. You can check SteemSQL status on this page

If ever the maintenance would require less time, I will let you know.
Any communication and support related to this maintenance will be done on SteemSQL’s channel on steem.chat

With this major upgrade, SteemSQL should be ready to face the grow of the Steem blockchain for a long time. Except if the blockchain activity goes to the moon, and it's the least we can hope for.

Thank you.


footer created with steemitboard - click any award to see my board of honor

Support my work for the community. Vote for me as a witness

Sort:  

"SteemSQL server will stay available" this is good!

Doing my best to avoid any downtime 😅

Yay... excellent. Great that it continues to be up.

Thanks for the update and the service 😁

Posted using Partiko Android

Hi @arcange!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 7.841 which ranks you at #38 across all Steem accounts.
Your rank has not changed in the last three days.

In our last Algorithmic Curation Round, consisting of 224 contributions, your post is ranked at #1. Congratulations!

Evaluation of your UA score:
  • Your follower network is great!
  • The readers appreciate your great work!
  • Great user engagement! You rock!

Feel free to join our @steem-ua Discord server

This post has been included in the latest edition of SoS Daily News - a digest of all you need to know about the State of Steem.