monger/pricing repository overview

⁠Monger Market Price Comparison Application

This application is meant to be run independently on a separate server. This app makes a large number of API calls to a pricing service and subsequently a large number of database inserts for prices.

⁠Basic Requirements

You need PHP 5.4+ and MySQL 5.6+ to run this application.

⁠Installation

As with any Laravel 5 application, the first thing you should do is run composer install from the root of the application.

⁠Environments

You can create a copy of the .env.example file and rename it to .env. Fill in the appropriate values for your environment.

⁠Databases

Next you need to create two databases: one for pricing and one for storing the relevant catalog information. Make sure these database names are reflected in your .env file.

The pricing database can be entirely built using php artisan migrate --seed.

The demand database is a replica of the Products table from the live demand database. If you have a demand database locally and just want to test this application, you don't need to replicate the live database. The initial database dump can be found in database/dumps/demand_products.sql. Run this in your demand database and then set up slave replication using the live demand database as the master ([https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql](see⁠ here for a guide on how to set up replication)). All you need to replicate is the Products table.

The live replication server is 198.143.174.18. The bin file is mysql-bin.000001 and the starting position is 391.