Anyblock is now proudly part of Blockdaemon - read the announcement in our blog
Dec 11, 2020

We are moving to a new SQL server 🚚

by

Icon article header

Dear Anyblock Analysts,

all good things must come to an end and the same is true for disk space…

If you’re only using our API (RPC and Data), Alerting or Dashboards and do not use the SQL Server, there is nothing to do and things will keep working as expected!

In the last months we indexed and enriched a vast amount of blockchain data and enabled you to discoversearch and analyze every bit of information using either our comprehensive API, our PostgreSQL Database, our Dashboards or oftentimes all of these.

But with the Ethereum Mainnet slowly reaching 6 Terabytes of raw data and the enriched data being way over 10 Terabytes already, we’re slowly running out of disk space on our PostgreSQL server.

Therefore we decided to move to a Citus based Database Cluster.

This has some obvious benefits, like more processing power and faster indices because the data is now sharded over multiple servers which leads to overall faster queries and indexing performance.

On the other hand, the data is now sharded over multiple servers, which means some more advanced queries that require data from different sources may require different approaches.

To make the transition as smooth as possible, we will keep the old server running for some time, until we have worked out the quirks of the new system with all of you.

Sadly we can no longer store all data on the old server, so we’ll remove everything except Ethereum Mainnet. All existing data will of course still be on the new server.

 

The next steps will therefore be:

Monday, 2020-12-14

  • Make the old server available at sql.anyblock.net:45432

Wednesday, 2020-12-16

  • Switch sql.anyblock.tools to the new Cluster. This will also change the database port from 45432 to the default 5432.

Friday, 2020-12-18

  • Remove all databases except Ethereum Mainnet from the old server

Early 2021

  • Shut down the old database server

 

The data will still be updated on both servers and your existing credentials will be migrated, so except from changing the host and port, there is no immediate action required for your Mainnet SQL production use cases.
Everyone else should start migrating their scripts as soon as possible.

If you have any further questions or suggestions, feel free to ping us at contact@anyblockanalytics.com.

On behalf of the whole Anyblock team, I’m wishing you happy holidays, stay safe and hack the planet!

All the best from cold Germany ❄️,

Sascha (Co-Founder and CTO)

Interested or questions?

 

Sascha Göbel
(Co-Founder & Chief Technology Officer)
sascha@anyblockanalytics.com
+49 6131 3272372

    

Looking to create an Anyblock account?

Takes seconds and it's free!

Recent Posts

Anyblock Multi-Chain REST API for RPC & Data

Anyblock Multi-Chain REST API for RPC & Data

Anyblock REST API endpoints for RPC & data are a fast and reliable solution, which is available for more than 20 blockchains and does not require running your own node. You can view the list and description of all our endpoints in the Anyblock REST API docs.

In this article, you will find general information on Anyblock API and examples showing how to interact with it.

November Twitter Summary

November Twitter Summary

Hey there, developers! Anyblock Twitter Summary for the month of November is here.  Read it here or check out our Twitter account.Enjoy it!  Or just follow us directly if it's easier for you. Happy tweet-reading! :)🤔 Most people believe they need to operate a...

This is the beginning of a new chapter…

This is the beginning of a new chapter…

We are super excited to announce that Anyblock Analytics GmbH will be spearheading the expansion of Blockdaemon Inc. in Germany! The corresponding contracts have been signed last week and closing is expected shortly as well.

Pin It on Pinterest