Well, it took longer than I anticipated, but SteemDB.com is slowly coming back to life.
The data migration I started a couple days ago completed earlier today and I'm bringing the services back online. If you still see the "DB Migration" message still (on every page), your DNS has not updated to the new server. The DNS should update in the coming hours and the site will then become available once more.
If you're very impatient, you can always access the site via it's IP address: http://144.76.176.150
New Server
The new server SteemDB is hosted on is now provided by @privex, and I've had great support from @someguy123 getting this all setup.
SteemDB went from a 96gb RAM server with 8 cores to a 256gb RAM server with 12 cores. I've optimized and upgraded all of the software to the latest versions, configured the filesystem for high IO throughput, and should have plenty of room to grow over the next year or so.
Current Issues and Status
A few notes about this new deployment and issues surrounding the migration:
- The database sync is currently catching up, as I write this it was processing block 18636474 (2018-01-02). So currently the 9 most recent days of data are missing from some sections. This new server is processing these blocks at a rate of about 3-6 blocks/second. We are currently at a height of 18892572, which means there's about 250k blocks that need to be processed. At a rate of 3 blocks per second (to be conservative), it will catch up to the current block height and finish processing in about 24 hours.
- The witness pages and other sources that pull data live are unaffected by the sync process, but pages like an accounts transfers/votes will be impacted by the sync.
- The account history module is disabled for the next 24 hours, so no new snapshots of accounts will be created until the sync is completed.
- The apps page is missing data and somewhat broken, and I will investigate what's happening here. It's most likely due to the inactive history module, which also creates snapshots of app usage.
- The homepage is no longer cached, so it's somewhat slow. I'll work on caching this again in the future.
- Any missed blocks by witnesses during this migration were not recorded unfortunately.
Where SteemDB goes from here
Over the past month I've been doing a lot of thinking about the various projects I maintain in regards to the Steem ecosystem, and one reoccurring thought I have is that I have too many active projects. I am still in the planning phases, but one of my goals in 2018 is to shed or offload some of this workload so I can focus on the projects that actually matter to me, as well as the ecosystem as a whole.
With that being said, SteemDB isn't one of the projects that I want to personally stop maintaining. For months now in casual conversations I've mentioned that I really want to rebuild SteemDB and create a v2 of my block explorer code, and I am hoping to find the time to do so this year. SteemDB was my 2nd Steem related project (created Aug 2016) and I've learned so much since it's creation.
In 2018, I would very much like to take the time to sit down and rebuild SteemDB into something better. Improve the technology, the scalability, it's responsiveness, and usefulness. These foundational tools (wallets, blockexplorers, etc) are crucial to on-boarding new users and developers alike, while providing external transparency into the operations happening on the blockchain.
Luckily, this new server has room to grow, and I can fit a v2 right alongside v1 until it's ready to replace it :)
Awesome, now lets get some content to the top thats has some artistic nature to it! Right now its all dominated by memes and blockchain news. Please check out my new grand canyon time lapse films if you have a moment. https://steemit.com/video/@cinemaninja/bmvu7-grand-canyon-a-4k-time-lapse-film-ninja-cut Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I couldn't agree more. Once we start having less of a crypto focus and more of a general focus... that's when Steemit will really start to take off.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good luck taking this app to the next level.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hi @Jesta,
I heard you during the meeting on Discord in December. I use this comment section as an opportunity to thank you for the work you are carrying out for the community. I discovered Steemit about 3 months ago, am now completely immersed into it and am pretty amazed about what is going on here!
And a lot of this originates from people like you.
So, warm thanks :-)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
It's a pretty deep rabbit hole :)
Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@jesta my Dear friend Your Such Great posts Check My Blogs Did You like Support Me Thank you bro
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
yes its great.
thanks for nice words.
@qami
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
we're pioneers ;)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Best of luck for your data migration work, I hope you did it very well and in the future you will do better work.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That's a monster server!
Out of curiosity is the data stored on SSD drives?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yup, all stored on SSDs, and the entire DB is kept loaded in RAM for even faster access.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Explains why you need that monstrous amount of ram lol kudos!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sweeeeet!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
hy
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Checking it now, very cool!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
so interesting!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Never knew this wesite and I know almost all the tools. Thanks man, I'll check it out!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey all!
I have put together some picks. They are low market cap coins that I believe have great potential for profit. Obviously there is risk and do your own diligence before buying. I am not a financial planner or advisor.
In no particular order:
(Follow me on my new Steemit for daily picks, and have an excellent day!)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Okay I will check
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
your information is good
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I bought AirSwap in Binance some weeks ago.Good call
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
good . thanks for sharing nice information.
@qami
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Absolutely. All the analytics sites that are being built are a huge help to managing accounts.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You are right bro, the system needs more tools to gain control of our accounts.
@racoo
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm learning about new tools as I don't know about more #steemit tools.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes, I've the same minings as you, shohana1
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow we both are learning, nice to meet you new friend
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I also will check this out! Thank you 👍🏽
Upvoted 👍🏽👍🏽👍🏽
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
upvote
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
https://steemit.com/jiocoin/@santoshkrlko/who-is-waiting-for-jiocoin-like-me-hurry-up-reliance-jio-coin-is-comming-soon
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
How did I not know about this, the website looks amazing man! Glad someone tipped me off to follow you, please keep improving the site, I think it's looking clean and professional already, and so much info, this is an awesome find for me.
Voted for you as witness, really appreciate the work!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
true, totally agree with you! there needs to be more awareness of the site!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
WHATAVAR YA DU PPL : HODL !
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
it's good!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Finally I can see how much my reputation SUCKS :P
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
better than mine. I'm not even worth 3 bucks. Way to depreciate one's organs, steemit.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Glad to know @jesta. Thank you for your contribution! SteemDB is a very helpful service!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sounds like things are progressing well. You always do the best work and i can tell you work hard. Thanks for everything you do here for all of us
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow, thats some upgrade ,from 8g to 25g, its nice to have steemdb.com back online, missed using it,a very resourceful steemit/steem data collection site
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I love jesta creations. Thanks for the hard work you do. We need it. :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I agree with you, we need it.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for the update, @jesta. Which projects are you thinking about offloading? I agree that a richly featured block explorer is vital for people to understand what's going on under the hood. I'm glad that's not the one you are considering dropping.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for the updated information and looking forward to SteemDB.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Glad to see it coming back as I know so many of us rely on it!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great though on future.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Are there plans for dealing with the copy/paste reply bots that people are using to game this system? How about for disincentivizing people to post crap comments that contribute nothing? These kinds of things are going to be very bad for this platform in the long run if a stop isn't put to it early on.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
While I agree with your sentiment, the question then becomes (as in the real world) who is to judge what is a bad comment or in searching for the users gaming the system? How do we find the middle ground where that type of system doesn't censor opinions that are unpopular or that deal with sensitive topics? The second this turns into a Twitter or Facebook with censoring users I believe this platform is heading in the wrong direction.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I agree, they are problems. There's a lot of talk happening on this subject at this point between the witnesses but no concrete answers as of yet.
SteemDB won't solve those problems though :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks @jesta for bringing back SteemDB.com online again...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great, it would be super cool to have a chart area also!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The only place for steem to go from here is up!!!!!!!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Say no more.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I will check this. Thanks for sharing
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I have no idea about the #steem ecosystem. If it's growing up, that's good sign.
@alexKARKI
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@jesta did you do all this? Wow, you must be so smart!..
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
you guys are doing a great job
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@jesta Goodluck hopefully it is going to be fully functional soon!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
sounds good, I remain hopeful of the future
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
100% UpGoat.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Amazing and very interessing post thank you for sharing
resteemed and shared in the steemit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm glad to hear that you will continue to support SteemDB. Thank you!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great job man, big BRAVO!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is great news! I regularly use steem.supply and steemd, but less familiar with SteemDB. Would love to hear from others what the most useful data on SteemDB is so that I can better take advantage of it!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Que buen recuento, tratare de volverlo a ver, para aprender mas .
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is the best post on Steemit. I gave you a vote now, ya heard?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I keep seeing this comment copied and pasted all over from different individuals. The exact same words are even on my last reply I recieved on a post. Is this a group ?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
happy to join in steemit, successful greetings for steemit lovers,
continue to work
hopefully hope and dream of steemit users in this year can be achieved all..!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Dont buy ripple its the banks...buy bitcoin
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I've missed SteemDB, welcome back!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@jesta thank you for the SteemDB!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This are very good informations. thanks
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
A few days were in great trouble.I'm glad that the problem is partly healed. Thank you for the information.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
i am happy to see this post. since i joined i started using SteemDB.com and depended on the site. but i had some problems and as a new user thought i did some mistake and it didn't work for me. late i came to know there are some issues and finally they are getting rectified. good to know this. when we are used to one site conginuing on it is very conveninet for me.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
finally it is back, everytime I went to visit this site, always got the error|
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Cracking work you have done.. witness vote your way!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Is this what you mentioned?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
this is great and useful . thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Glad to know @jesta. Thank you for your contribution! SteemDB is a very helpful service!<3 Resteem
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I really have alot to research about this, because i honestly didn't understand more than half of this
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow! so youre the one who is running this thing. Man you rock!! this thing helps, the realtime data and stats. thanks for this.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I just started last week and I only had it for a day or two before it went down and I was wondering what was up with that. Thanks for the hard work.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow..!!!! that's great
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
good
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm not familiar with this site but I had a good omen when I checked it out
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey that was really amazing man .. we need something like that to learn from ❤
Thanks buddy ❤
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks @jesta, this article is very useful for me, thanks many of my brother
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
How did I not know about this, the website looks amazing man! Glad someone tipped me off to follow you, please keep improving the site, I think it's looking clean and professional already, and so much info, this is an awesome find for me.
Voted for you as witness, really appreciate the work!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
How did I not know about this, the website looks amazing man! Glad someone tipped me off to follow you, please keep improving the site, I think it's looking clean and professional already, and so much info, this is an awesome find for me.
Voted for you as witness, really appreciate the work!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Didn't knew this part of the steem ecosystem. Nicely done, keep on doing the good work!!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wish you best of Luck
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice 👍👍
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
hi to work well with your willingness to pay for your work
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for this endeavor, I appreciate it.
The system needs more tools to gain control of our accounts.
@racoo
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow the website looks amazing, i will check it out soon!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
All I can say is that the future looks bright and secure. I just hope the programmer breaks the code before they steal it. Hahaha!!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
amazing! now I don't have to click on page by page to check the value of steem vs btc.. thanks for this @jesta. helps alot!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Really thannk you for this service!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great feat! You inspire me greatly with this project! Keep up the good work!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This post has single-handedly dealt with issues of immense importance. It was so helpful especially to new people here'. Thanks @jesta
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Do you have a discord group??
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@jesta thanks
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
https://steemit.com/@yaldrimbalfas follow me #indonesia #steemit #steem #blog #introduceyourself . u very good
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you, will check it out. I'm already using your steemstats monitor and find it very useful. Just voted you for a witness, thanks for all your work to make stemmians lives easier
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow, I'm quite excited that I belong to this great family of diverse opportunities
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hello! I'm new to steemit, go through my profile and give me a vote
https://steemit.com/introduceyourself/@misc.jocs/i-m-andres-hernandez-a-soda-student-i-m-a-student-i-like-to-do-exercises-in-the-street-i-m-starting-in-steemit-to-create-part-of
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
We cannot create an account unless we have steempower already? Thanks :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
great information sir. Hope you could follow me someday
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
It requires a lot of effort, thanks for the had work :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
all the tools is old add something new in the site.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
nice..i am hopefull you will upvote my posts also
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
So thankful for the awesome information, waoooh this is rich. Thank you.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great info and I will check it out. Voted you as witness.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@jesta what is happening with
https://golosdb.com ?
seems it is falling weeks behind
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Probably the same issues that SteemDB has been suffering from over the past couple months.
Over the past few weeks I've made tweaks to golosdb, but the RPC nodes available to retrieve data from are also very slow on the golos end of things. It's still running... just slowly.
Yet another reason why I really want to start working on a new version of the explorer (so it better supports multiple chains).
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks a lot for such information as I look for some answers which I get from here!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
very good
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for your contribution! SteemDB is a very helpful service! ;)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
you have to be patient
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
follow me and I follow you @sahari
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Excelente iniciativa @jesta
Como verás hace poco me inicié en Steemit y realmente estoy fascinada con todo lo positivo que se maneja en éste mundo de aportes.
Considero que vienes trabajando de una manera genial y te deseo muchos éxitos y más crecimiento...!!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for that information sir. Hope you could follow me someday
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I hear that we can earn steempower when comment? really?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for the update
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Excellent! I was going to test with connecting apps I was developing only recently and appreciate your efforts, and monster server :D Are there any public projects that I may help out with? Cheers!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
i ever seen this site...after all reading your blog i saw that and i kindly requesting to improve your site, i'll check out of there
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good post! .. I will follow you follow me too and we help each other ... I would appreciate a vote in my last post thanks
https://steemit.com/openmic/@misc.jocs/my-most-appreciated-possession
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you so much for all the hard work you have put into the site. It clearly shows. Right now I've been trying to tell my friends to migrate over here and leave the exploitive nature of so many other places. I feel really cherished on here.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey all, I'm sorry to be commenting on an unrelated article, but I am new to STEEMIT, and I would like to do livestreams a few times a week. How does one start this process ?? Any help is greatly appreciated. Thank you all.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm not sure I have a great answer for ya on how to accomplish that. I've seen people that write posts when they start live streaming, to direct them to other platforms where the live stream is happening, but I'm not sure how that'd work here. Sorry I'm not of much help in this regard!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit