create account

[Update] hafsql.mahdiyari.info is back online - sort of by mahdiyari

View this thread on: hive.blog |  peakd.com |  ecency.com
hive-139531 · @mahdiyari ·
$94.48
[Update] hafsql.mahdiyari.info is back online - sort of
<center>![developer-8829735_640.jpg](https://files.peakd.com/file/peakd-hive/mahdiyari/EoGvWRRokkXUsKyDovwmQdqgumiQjEinc6KAFAVR2zcp5px5rBNBv8yFxnJeyXyxsyc.jpg)</center>

I did announce how my public HAF/HafSQL node was down in the [last post](https://peakd.com/hive-139531/@mahdiyari/update-and-downtime-hafsqlmahdiyariinfo-will-be-down-for-2-days) and how it is going to be back up in 2 days.

Well, I was wrong. As it turns out the main server is broken somehow. I don't know what is wrong but it is way under performing. HafSQL should have taken 24 hours to finish syncing but after 4 days it is still around 20% done on this server.

I did switch to the backup server which was way faster to bring back online. It is running the newer code on newer HAF version. Although it is missing the communities data which I have not done that yet on the new code.

The backup server should work just fine until I replace the main server.

I'll be using ZFS snapshots going forward for faster recovery. With ZFS snapshots it should take minutes to bring back a server online.

It turns out there is a useful tool that can help with automatic snapshot taking and pruning. It is called [Sanoid](https://github.com/jimsalterjrs/sanoid) (thanks to @themarkymark)

I'll setup Sanoid and hopefully that should prevent disasters like this happening again.
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 438 others
properties (23)
authormahdiyari
permlinkupdate-hafsqlmahdiyariinfo-is-back-online-sort-of
categoryhive-139531
json_metadata{"app":"peakd/2024.7.3","format":"markdown","tags":["hivedev","hive","dev","haf","hafsql"],"users":["mahdiyari","themarkymark"],"image":["https://files.peakd.com/file/peakd-hive/mahdiyari/EoGvWRRokkXUsKyDovwmQdqgumiQjEinc6KAFAVR2zcp5px5rBNBv8yFxnJeyXyxsyc.jpg"]}
created2024-07-26 11:15:33
last_update2024-07-26 11:15:33
depth0
children3
last_payout2024-08-02 11:15:33
cashout_time1969-12-31 23:59:59
total_payout_value47.268 HBD
curator_payout_value47.212 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,341
author_reputation199,858,009,060,549
root_title"[Update] hafsql.mahdiyari.info is back online - sort of"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id135,607,271
net_rshares299,496,981,884,739
author_curate_reward""
vote details (502)
@happyphoenix · 
Nice, Appreciated. 
!hiqvote
👍  ,
properties (23)
authorhappyphoenix
permlinkre-mahdiyari-2024726t183922987z
categoryhive-139531
json_metadata{"type":"comment","content_type":"general","tags":["hive-139531","hivedev","hive","dev","haf","hafsql"],"app":"ecency/3.1.4-mobile","format":"markdown+html"}
created2024-07-26 11:39:21
last_update2024-07-26 11:39:21
depth1
children0
last_payout2024-08-02 11:39:21
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_length28
author_reputation69,242,724,346,992
root_title"[Update] hafsql.mahdiyari.info is back online - sort of"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id135,607,820
net_rshares36,199,215,263
author_curate_reward""
vote details (2)
@hiq.smartbot ·
HiQ Smart Bot says
<div class="pull-left">

<img src="https://i.imgur.com/VDg3S7W.gif"></a>

</div>

<div class="pull-right">

@happyphoenix, the HiQ Smart Bot has recognized your request (1/2) and will start the voting trail.

In addition, @mahdiyari gets !LOOL from @hiq.redaktion.

![](https://i.imgur.com/plMUJVK.png)

<sub>For further questions, check out https://hiq-hive.com or join our [Discord](https://discord.gg/25Fp5wBvQa). And don't forget to vote [HiQs fucking Witness!](https://vote.hive.uno/@hiq.witness) 😻</sub>

</div>
properties (22)
authorhiq.smartbot
permlinkre-update-hafsqlmahdiyariinfo-is-back-online-sort-of-20240726t115559z
categoryhive-139531
json_metadata"{"app": "beem/0.24.26"}"
created2024-07-26 11:56:00
last_update2024-07-26 11:56:00
depth1
children1
last_payout2024-08-02 11:56: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_length517
author_reputation3,284,924,454,526
root_title"[Update] hafsql.mahdiyari.info is back online - sort of"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id135,608,166
net_rshares0
@lolzbot · 
<div class='pull-right'><center><img src="https://lolztoken.com/lolz.png"><br><a href="https://lolztoken.com">lolztoken.com</a></p><br><br><br><br></center></div><p><center><strong>Die Deutschlehrerin zur Schülerin: Wenn ich sage Ich bin schön!<br>welche Zeit ist das dann?, Die Schülerin meldet sich und sagt gelangweilt: Vergangenheit Frau Lehrerin, wenn ich sie so ansehe mit Sicherheit Vergangenheit!</strong><br><sub>Credit: <a href="https://peakd.com/@las3rbone">las3rbone</a></sub><br>@mahdiyari, ich habe dir im Namen von  @hiq.smartbot einen <a href="https://hive-engine.com/?p=market&t=LOLZ">$LOLZ</a> Token gesendet<br>Verwende den Befehl <strong>!WITZ</strong> oder <strong>!LOOL</strong>, um einen Witz und ein <a href="https://hive-engine.com/?p=market&t=LOLZ">$LOLZ</a> zu teilen.<br><br>NEW:  <a href='https://peakd.com/@lolz.burner/posts'>Join LOLZ's Daily Earn and Burn Contest and win $LOLZ</a><br>.(5/8)</center></p>
properties (22)
authorlolzbot
permlinkre-re-update-hafsqlmahdiyariinfo-is-back-online-sort-of-20240726t115559z-20240726t115620z
categoryhive-139531
json_metadata"{"app": "beem/0.24.19"}"
created2024-07-26 11:56:36
last_update2024-07-26 11:56:36
depth2
children0
last_payout2024-08-02 11:56:36
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_length936
author_reputation196,688,023,250,894
root_title"[Update] hafsql.mahdiyari.info is back online - sort of"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id135,608,178
net_rshares0
Help/Feedback