Thanks for the detailed report! Sorry things did not work out.
As for the 502 errors, it sounds like the server was under-powered for the database size? How many posts, topics and users were there, and what were the cpu, ram, and disk stats of your server? You’d also want to use a CDN for a large site to reduce load.