How to save Steem blockchain to MySQL?

Ever wanted to access Steem data easily. Steem developers got you covered, there are already services to make your life easy and get you started with developing applications on top of Steem.

<p dir="auto"><a href="https://steemdata.com" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">SteemData, <a href="https://steemsql.com" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">SteemSQL, <a href="https://steemtools.com" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">many more services that offer you tools and services to get started. <h3>Get your own <p dir="auto">If you want to build and host your own database for your application you can do that as well. <a href="https://github.com/steemit/sbds" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">SBDS (Steem Blockchain Data Service) which is being developed by Steemit and it is already fully functional. <p dir="auto">Instruction on github straight-forward and uses SQLite by default because sbds has api routes built-in to query data. And you want more custom queries and have data in mysql database, you can try below steps. I have couple instances running for eSteem users and upcoming features. <p dir="auto"><center><span><img src="https://images.hive.blog/768x0/https://img.esteem.ws//pxsd445aaw.png" srcset="https://images.hive.blog/768x0/https://img.esteem.ws//pxsd445aaw.png 1x, https://images.hive.blog/1536x0/https://img.esteem.ws//pxsd445aaw.png 2x" /> <p dir="auto">All you need is virtual machine or local one with docker installed. <h2>Steps <p dir="auto">Here are the steps I did on my sbds setups: <p dir="auto">a) <code>docker run -d --name steem_mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=steem mysql <p dir="auto">This will run mysql docker instance which we can use to hook up our sbds docker. <p dir="auto"><center>--:-- <p dir="auto">b) <code>docker inspect --format '{{ .NetworkSettings.IPAddress }}' steem_mysql <p dir="auto">This will show you ip address of mysql docker instance which you can use below<br /> <center>--:-- <p dir="auto">c) <code>git clone https://github.com/steemit/sbds <p dir="auto">Clone SBDS source code from github<br /> <center>--:-- <p dir="auto">d) <code>cd sbds && nano Dockerfile <p dir="auto">Edit docker file by adding mysql connection url<br /> <center>--:-- <p dir="auto">e) <code>ENV DATABASE_URL mysql://root:password@ip_of_mysql_docker:3306/steem <p dir="auto">Change line 3 in Dockerfile to above, you can add/setup your custom user credentials instead of root for your mysql instance if you prefer safer storage.<br /> <center>--:-- <p dir="auto">f) <code>docker build -t sbds . <p dir="auto">This will build sbds<br /> <center>--:-- <p dir="auto">g) <code>docker run -p 8080:8080 -p 9191:9191 --name sbds-instance --link steem_mysql:mysql sbds <p dir="auto">This will run sbds and link to mysql docker instance.<br /> <center>--:-- <p dir="auto">That's it! <hr /> <p dir="auto">Now you can wait sbds to sync up and save all blockchain data to mysql for you. <p dir="auto">You can connect to mysql instance via your virtual/local machine IP, mysql credentials because instance exposed 3306 port. SBDS ports are also exposed so you can use SBDS json-rpc requests as well to query the data you need. <p dir="auto">If you are developing website, web application, business or any application, I am sure local copy of blockchain helps you build all sort of stuff and get stats easily. Read previous post to learn <a href="https://steemit.com/steem/@good-karma/why-you-should-build-on-top-of-steem-82b38e835f81a" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">why you should build on top of Steem. <p dir="auto">Steem On! <hr /> <p dir="auto"><center><h5>vote, reblog, follow, <a href="https://ttps://steemit.com/~witnesses" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">vote witness <code>good-karma