create account

HiveSQL Infrastructure Upgrade by arcange

View this thread on: hive.blogpeakd.comecency.com
· @arcange ·
$60.19
HiveSQL Infrastructure Upgrade
![](https://i.imgur.com/ZTURdWq.png)

### 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](/@arcange/22020302-hivesql-maintenance).

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](https://discord.gg/kyEFDfT)

---
<center>
### Check out my apps and services
<a href="/hive/@hive.engage/stay-connected-with-your-hive-audience-and-catch-attention"><img src="https://i.imgur.com/GiNJqlm.png"></a><a href="https://hiveauth.com"><img src="https://i.imgur.com/rPlzjwP.png"></a><a href="/@hivebuzz"><img src="https://i.imgur.com/B4UTun2.png"></a><a href="/@hivesql"><img src="https://i.imgur.com/EPN8RW6.png"></a><a href="/hive/@arcange/introducing-hive-account-recovery"><img src="https://i.imgur.com/6TWeW7V.png"></a><a href="/@hive.autoclaim"><img src="https://i.imgur.com/ih2pEOw.png"></a>
### [Vote for me as a witness ![](https://i.imgur.com/2bi4SnT.png)](https://vote.hive.uno/@arcange)
</center>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 273 others
👎  
properties (23)
authorarcange
permlinkhivesql-maintenance-202204
categoryhive-139531
json_metadata"{"app":"peakd/2022.04.5","format":"markdown","description":"HiveSQL will be under maintenance and unavailable as of 2022-04-27 22:00 UTC. The maintenance should last 1 day.","tags":["hive-139531","hivesql","hive","sql","database","maintenance","pob","leofinance"],"users":["arcange","hive.engage","hivebuzz","hivesql","hive.autoclaim"],"image":["https://i.imgur.com/ZTURdWq.png","https://i.imgur.com/GiNJqlm.png","https://i.imgur.com/rPlzjwP.png","https://i.imgur.com/B4UTun2.png","https://i.imgur.com/EPN8RW6.png","https://i.imgur.com/6TWeW7V.png","https://i.imgur.com/ih2pEOw.png","https://i.imgur.com/2bi4SnT.png"]}"
created2022-04-27 08:23:12
last_update2022-04-27 08:23:12
depth0
children14
last_payout2022-05-04 08:23:12
cashout_time1969-12-31 23:59:59
total_payout_value30.155 HBD
curator_payout_value30.031 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,118
author_reputation1,065,060,448,013,282
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,684,151
net_rshares60,873,835,341,705
author_curate_reward""
vote details (338)
@diyhub ·
<div class="pull-right"><a href="https://steempeak.com/trending/hive-189641"><img src="https://cdn.steemitimages.com/DQmV9e1dikviiK47vokoSCH3WjuGWrd6PScpsgEL8JBEZp5/icon_comments.png"></a></div>

###### 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](https://peakd.com/trending/hive-189641) 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!
properties (22)
authordiyhub
permlinkre-hivesql-maintenance-202204-20220427t125701z
categoryhive-139531
json_metadata"{"app": "beem/0.24.26"}"
created2022-04-27 12:57:00
last_update2022-04-27 12:57:00
depth1
children0
last_payout2022-05-04 12:57:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,046
author_reputation360,979,172,643,043
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,689,479
net_rshares0
@drniche ·
This is exciting!! Thank you for the updates and all the hard work, arcange!
properties (22)
authordrniche
permlinkrb2a4g
categoryhive-139531
json_metadata{"app":"hiveblog/0.1"}
created2022-04-28 18:02:42
last_update2022-04-28 18:02:42
depth1
children0
last_payout2022-05-05 18:02:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length76
author_reputation172,973,143,590
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,727,609
net_rshares0
@joanstewart ·
$0.14
Hope it is a smooth run and all goes well, thanks for update and work carrying on!

@tipu curate

👍  
properties (23)
authorjoanstewart
permlinkre-arcange-2022427t103012221z
categoryhive-139531
json_metadata{"tags":["hive-139531","hivesql","hive","sql","database","maintenance","pob","leofinance"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-27 08:30:12
last_update2022-04-27 08:30:12
depth1
children3
last_payout2022-05-04 08:30:12
cashout_time1969-12-31 23:59:59
total_payout_value0.069 HBD
curator_payout_value0.070 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length98
author_reputation320,070,290,805,809
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,684,269
net_rshares141,903,681,006
author_curate_reward""
vote details (1)
@arcange ·
Thank you @joanstewart
This should go well. I make sure.<div class="pull-right"><a href="/@hive.engage">![](https://i.imgur.com/XsrNmcl.png)</a></div>
properties (22)
authorarcange
permlinkre-1651060632831
categoryhive-139531
json_metadata{"app":"engage"}
created2022-04-27 11:57:12
last_update2022-04-27 11:57:12
depth2
children1
last_payout2022-05-04 11:57:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length150
author_reputation1,065,060,448,013,282
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,687,932
net_rshares0
@joanstewart ·
Know it will! Appreciate the work you accomplish here in Hive.
properties (22)
authorjoanstewart
permlinkre-arcange-2022427t14451966z
categoryhive-139531
json_metadata{"tags":["ecency"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-27 12:45:12
last_update2022-04-27 12:45:12
depth3
children0
last_payout2022-05-04 12:45:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length62
author_reputation320,070,290,805,809
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,689,184
net_rshares0
@tipu ·
<a href="https://tipu.online/hive_curator?joanstewart" target="_blank">Upvoted  &#128076;</a> (Mana: 45/55) <a href="https://peakd.com/hive/@reward.app/reward-app-quick-guide-updated" target="_blank">Liquid rewards</a>.
properties (22)
authortipu
permlinkre-re-arcange-2022427t103012221z-20220427t083017z
categoryhive-139531
json_metadata"{"app": "beem/0.24.26"}"
created2022-04-27 08:30:15
last_update2022-04-27 08:30:15
depth2
children0
last_payout2022-05-04 08:30:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length219
author_reputation55,204,880,790,343
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,684,270
net_rshares0
@pixresteemer ·
<center>![pixresteemer_incognito_angel_mini.png](https://files.peakd.com/file/peakd-hive/pixresteemer/8h7BBw1w-pixresteemer_incognito_angel_mini.png)</center><center>Bang, I did it again... I just rehived your post!</center><center>Week 103 of my [contest](/hive-179017/@pixresteemer/the-re-hive-contest-results-week-102-and-start-week-103) just started...you can now check the winners of the previous week!</center><center>!BEER</center><center><sub>3</sub></center>
properties (22)
authorpixresteemer
permlink20220427t083548865z
categoryhive-139531
json_metadata{"tags":["archon","pixresteemer"],"app":"pixresteemer"}
created2022-04-27 08:35:48
last_update2022-04-27 08:35:48
depth1
children1
last_payout2022-05-04 08:35:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length467
author_reputation121,069,894,721,298
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,684,396
net_rshares0
@beerlover ·
Sorry, out of BEER, please retry later...
properties (22)
authorbeerlover
permlinkre-pixresteemer-20220427t083548865z-20220427t083705031z
categoryhive-139531
json_metadata{"app":"beerlover/2.0"}
created2022-04-27 08:37:03
last_update2022-04-27 08:37:03
depth2
children0
last_payout2022-05-04 08:37:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length41
author_reputation24,770,396,872,031
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,684,426
net_rshares0
@poshtoken ·
https://twitter.com/joanstewart1/status/1519237875459670017
<sub> 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.</sub>
properties (22)
authorposhtoken
permlinkre-arcange-hivesql-maintenance-202204-1385
categoryhive-139531
json_metadata"{"app":"Poshtoken 0.0.1"}"
created2022-04-27 08:56:06
last_update2022-04-27 08:56:06
depth1
children0
last_payout2022-05-04 08:56:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length247
author_reputation3,941,430,326,756,108
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries
0.
accountreward.app
weight10,000
max_accepted_payout1,000,000.000 HBD
percent_hbd0
post_id112,684,706
net_rshares0
@sodom-lv ·
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?
properties (22)
authorsodom-lv
permlinkre-arcange-2022427t222610591z
categoryhive-139531
json_metadata{"tags":["hive-139531","hivesql","hive","sql","database","maintenance","pob","leofinance"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-27 15:26:12
last_update2022-04-27 15:26:12
depth1
children2
last_payout2022-05-04 15:26:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length140
author_reputation69,334,696,227,045
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,693,444
net_rshares0
@arcange ·
I don't think Leofinance relies on HiveSQL for their wallet, but better ask them to be sure.<div class="pull-right"><a href="/@hive.engage">![](https://i.imgur.com/XsrNmcl.png)</a></div>
👍  
properties (23)
authorarcange
permlinkre-1651074212009
categoryhive-139531
json_metadata{"app":"engage"}
created2022-04-27 15:43:33
last_update2022-04-27 15:43:33
depth2
children1
last_payout2022-05-04 15:43:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length186
author_reputation1,065,060,448,013,282
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,693,837
net_rshares4,135,444,590
author_curate_reward""
vote details (1)
@sodom-lv ·
Thank you!
It seems the issue is on Leofinance frontend.
I check the Leo wallet on peakd.com and it works well
properties (22)
authorsodom-lv
permlinkre-arcange-2022428t212544328z
categoryhive-139531
json_metadata{"tags":["ecency"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-28 14:25:42
last_update2022-04-28 14:25:42
depth3
children0
last_payout2022-05-05 14:25:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length110
author_reputation69,334,696,227,045
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,721,814
net_rshares0
@xplosive ·
$0.71
> 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.
👍  
properties (23)
authorxplosive
permlinkre-arcange-2022427t115013554z
categoryhive-139531
json_metadata{"tags":["hive-139531","hivesql","hive","sql","database","maintenance","pob","leofinance"],"app":"ecency/3.0.27-mobile","format":"markdown+html"}
created2022-04-27 09:50:15
last_update2022-04-27 09:50:15
depth1
children1
last_payout2022-05-04 09:50:15
cashout_time1969-12-31 23:59:59
total_payout_value0.352 HBD
curator_payout_value0.353 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length748
author_reputation171,920,509,819,933
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,685,632
net_rshares710,283,198,594
author_curate_reward""
vote details (1)
@arcange ·
$0.02
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.<div class="pull-right"><a href="/@hive.engage">![](https://i.imgur.com/XsrNmcl.png)</a></div>
👍  
properties (23)
authorarcange
permlinkre-1651060545709
categoryhive-139531
json_metadata{"app":"engage"}
created2022-04-27 11:55:45
last_update2022-04-27 11:55:45
depth2
children0
last_payout2022-05-04 11:55:45
cashout_time1969-12-31 23:59:59
total_payout_value0.012 HBD
curator_payout_value0.012 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length424
author_reputation1,065,060,448,013,282
root_title"HiveSQL Infrastructure Upgrade"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,687,899
net_rshares25,776,372,830
author_curate_reward""
vote details (1)