How to configure Multichain explorer to store data on mysql ?

+4 votes

Cloud you please help me to configure multichain explorer to store data on mysql.

Thank you
asked Oct 20, 2017 by kevin

1 Answer

+1 vote
I'm afraid it's not possible, and the MultiChain Explorer only supports the SQLite database engine.
answered Oct 20, 2017 by MultiChain
What we are doing is using the "getblock <blocknumber> 4" command via RPC to parse the data with a PHP script, and grabbing the data that is applicable for us..namely the tx_ids, transaction amounts, addresses, fees etc...and then using our own API to consume data from our mysql db to our wallet software to display. Users have to trust the data is correct, but they can always check on their own full node. We don't need to importaddresses on nodes, rescan etc...