YGOPRODeck icon indicating copy to clipboard operation
YGOPRODeck copied to clipboard
verified publisher icon AlanOC91

Remote MySQL Server

Open AlanOC91 opened this issue 3 years ago • 3 comments

A remote MySQL server is needed to reduce overall load on YGOPRODeck.

A remote server has been purchased on DigitalOcean and the following will be migrated to reduce load:

  • Yu-Gi-Oh! API
  • Yu-Gi-Oh! Pack Opening

Further migrations will take place once we get an idea of how monthly pricing will be based on the usage of the above on our DigitalOcean instance.

AlanOC91 avatar Jan 20 '22 20:01 AlanOC91

Remote Server live on DigitalOcean.

Currently Running:

  • External Yu-Gi-Oh! API
  • Pack Opening Simulator
  • Custom Packs

Data is replicated immediately for Custom Packs, nightly for everything else using mysqldump.

AlanOC91 avatar Jan 21 '22 10:01 AlanOC91

Additionally Running:

  • Some internal API requests
  • Card Counters (Card Info)
  • Ritual Check (Card Info)
  • Detect Cards (Deck Page)

AlanOC91 avatar Jan 24 '22 12:01 AlanOC91

Hey mate I was wondering if you'd ever release database dumps of the API of some sort, I guess that'd really help with the load since people would be able to self host basically

WildEgo avatar Apr 15 '22 21:04 WildEgo