I did announce how my public HAF/HafSQL node was down in the last post 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.

DowntimeThe public HAF/HafSQL node that I'm operating, , will be down for 2 days. More info on the node is here.This morning the HAF node on the main server died. This wouldn't be a big deal as I do also have a backup server. But unfortunately I took down the backup server couple of days ago to deploy a new code with updated HAF. So now both servers are down.

I have been providing public access to a HAF + HafSQL database for the past 3 months. Alongside with a backup server to keep the downtimes minimal.I do provide a few free services including public API nodes which require some beefy machines. I do that because of my witness rewards and it is all voluntary.

source: pixabay It's been a while since my last witness update. I'll go through what I have been doing and what I'll be doing in the future.Here is what I'm maintaining right now:Internal market interface and API hivedex.ioAnonymous account creatorAutomated voting and more hive.votePublic RPC node EU Public RPC node NA Public seed node `node.mahdiyari.info:2001`Public seed node [Public HafSQL node](/hive-139531/@mahdiyari/public-hafsql-database-on-haf) `hafsql.mahdiyari.info`Public HafSQL nodeHAF application HafSQLJS library hive-txPHP library hive-php

What is HafSQLIt is built to run on HAF and provide gateway to certain data. For example with hafsql, you can query all the operations and virtual operations by their parameters. This includes getting operations based on their with incredible speed. Or searching transfers based on their . Or having list of incoming delegations.

Proposals that I don't support:$52,925/year Hivewatchers $255,500/year Peakd open projects $49,275/year Hivesql $83,950/year Actifit $144,936/6 months DBuzz $219,000/year Keychain $127,750/year Honeycomb $204,400/2 years Hivebuzz $241,065/1.5 years Leofinance $121,110/year dev proposal by howo