HiveSQL Infrastructure Upgrade

arcange in #hive-139531 • 3 years ago

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

Vote for me as a witness

#hivesql #hive #sql #database #maintenance #pob #leofinance

3 years ago in #hive-139531 by arcange

6.47 VYB

Sort:

Trending

[-]

diyhub 3 years ago

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!

0.00 VYB

[-]

joanstewart 3 years ago

Hope it is a smooth run and all goes well, thanks for update and work carrying on!

@tipu curate

0.00 VYB

1 vote

[-]

arcange 3 years ago

Thank you @joanstewart
This should go well. I make sure.

0.00 VYB

[-]

joanstewart 3 years ago

Know it will! Appreciate the work you accomplish here in Hive.

0.00 VYB

[-]

tipu 3 years ago

Upvoted 👌 (Mana: 45/55) Liquid rewards.

0.00 VYB

[-]

poshtoken 3 years ago

_{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.}

0.00 VYB

[-]

sodom-lv 3 years ago

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?

0.00 VYB

[-]

arcange 3 years ago

I don't think Leofinance relies on HiveSQL for their wallet, but better ask them to be sure.

0.00 VYB

1 vote

[-]

sodom-lv 3 years ago

Thank you!
It seems the issue is on Leofinance frontend.
I check the Leo wallet on peakd.com and it works well

0.00 VYB

[-]

drniche 3 years ago

This is exciting!! Thank you for the updates and all the hard work, arcange!

0.00 VYB

[-]

pixresteemer 3 years ago

Bang, I did it again... I just rehived your post!Week 103 of my contest just started...you can now check the winners of the previous week!!BEER₃

0.00 VYB

[-]

beerlover 3 years ago

Sorry, out of BEER, please retry later...

0.00 VYB

[-]

xplosive 3 years ago

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)!

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.

0.01 VYB

1 vote

[-]

arcange 3 years ago

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.

0.01 VYB

1 vote