How does MPOS communicate with stratum server?

Question

I'm setting up MPOS. There are 3 stratum server options: stratum-mining, NOMP, and CoiniumServ. How does MPOS talk with stratum server? AFAIK, MPOS does not speak stratum protocol. Is it through the shared mysql database, where stratum server writes to it (e.g., submitted shared) and MPOS retrieves from.

I'm trying to use a stratum server other than the 3 options above, thus trying to see how to make it compatible with MPOS.

Answer 1

NOMP actually implements MPOS compatibility mode, so you can reference the data format it writes to MySQL: mposCompatibility.js. For example:

Storing shares:

INSERT INTO `shares` SET time = NOW(), rem_host = ?, username = ?, our_result = ?, upstream_result = ?, difficulty = ?, reason = ?, solution = ?

Updating Miner Difficulty:

UPDATE `pool_worker` SET `difficulty` = ' + diff + ' WHERE `username` = ' + connection.escape(workerName)

New Pool Worker:

INSERT INTO `pool_worker` (`account_id`, `username`, `password`) VALUES (?, ?, ?)