HiveSQL Infrastructure Upgrade
TLDR;
HiveSQL will be under maintenance and unavailable as of 2022-04-27 22:00 UTC. The maintenance is expected to last 1 day (or less).
A bit of history
Last month, I had to put HiveSQL in maintenance mode to make a major change to the database structure.
That unexpected maintenance lasted almost 3 days, mostly because I struggled with storage space as HiveSQL database size is growing every day and now exceeds 3.3TB (terabytes)!
To prevent such long unexpected maintenance from happening again, I ordered a new server with better performances and larger disks to double the actual available storage size, but given the current supply problems, it took forever to be available.
The good news is that this new hardware arrived and the upgrade can finally begin.
HiveSQL in maintenance mode
As of 2022-04-27 22:00 UTC, HiveSQL will be put under maintenance.
The maintenance is planned to last one day. Although I think it should go faster, it's always better to take some safety margin.
To speed up the transition process and minimize downtime, access to HiveSQL unavailable for the whole maintenance duration.
I will notify you as soon as this maintenance is over. Any communication and support related to this maintenance will be done in the HiveSQL Discord Channel
Check out my apps and services
Hope it is a smooth run and all goes well, thanks for update and work carrying on!
@tipu curate
Upvoted 👌 (Mana: 45/55) Liquid rewards.
Thank you @joanstewart
This should go well. I make sure.
Know it will! Appreciate the work you accomplish here in Hive.
Sorry, out of BEER, please retry later...
https://twitter.com/joanstewart1/status/1519237875459670017
The rewards earned on this comment will go directly to the person sharing the post on Twitter as long as they are registered with @poshtoken. Sign up at https://hiveposh.com.
3.30 TB is a lot of data, and it will be much bigger in the upcoming years and decades. Hopefully the new server will be good for at least the upcoming few years. Probably this single comment is also increasing the database by a few kilobytes. And a lot of things are being registered on the Hive blockchain. I would not be surprised, if the database size would be doubled in the near future.
I wish good luck and all the best with (and thank you for) the maintenance and with/for the development.
Have a nice day. All the best. Greetings and much love from Hungary.
Thank you @xplosive.
Yes, it's a lot of data, mainly because of the way usernames and permlinks are stored and indexed in the various tables.
The database stores 6 years of data. I hope this storage upgrade will last another 6 years. But I should wish for less if I also wish for the growth of the platform.
Hava a nice day too.
Thank you for sharing this amazing post on HIVE!
Your content got selected by our fellow curator @priyanarc & you just received a little thank you via an upvote from our non-profit curation initiative!
You will be featured in one of our recurring curation compilations and on our pinterest boards! Both are aiming to offer you a stage to widen your audience within and outside of the DIY scene of hive.
Join the official DIYHub community on HIVE and show us more of your amazing work and feel free to connect with us and other DIYers via our discord server: https://discord.gg/mY5uCfQ !
If you want to support our goal to motivate other DIY/art/music/homesteading/... creators just delegate to us and earn 100% of your curation rewards!
Stay creative & hive on!
Thanks for your work and hope everything will go smoothly!
This may be the reason why I face the issue with leofinance wallet, am I correct?
I don't think Leofinance relies on HiveSQL for their wallet, but better ask them to be sure.
Thank you!
It seems the issue is on Leofinance frontend.
I check the Leo wallet on peakd.com and it works well
This is exciting!! Thank you for the updates and all the hard work, arcange!