Recent content by zomkornephoros5859

  1. Z

    Scaling Super-Thread

    You use memory cache as a backup solution? xD Copying the mysql folder will never provide a reliable and consistent backup. To do it you must shut down or lock the database otherwise you'll have a database in an inconsistant state. Mysqldump will always be consistent and easy to restore If you...
  2. Z

    Scaling Super-Thread

    It could add 200-300ms to your load time depending on locations and providers/peering. US/Canada and Europe are fine I've found especially if you're on the same server provider in these two locations as internal peering is normally used giving you better connectivity. I'd also recommend...
  3. Z

    Scaling Super-Thread

    I wouldn't say its overkill at all. Its designed for high uptime and redundancy in mind. I'd love to see you try and dump a yetishare mysql database including the 100+million rows in the stats table twice a day for backups without causing any performance issues on non SSD disks. For us it was...
  4. Z

    Scaling Super-Thread

    I migrated from the other Perl based script referenced earlier in the thread to yetishare and have seen that yetishare is much more reliable when it comes to high traffic. I get 40 million page views a month according to google analytics and the total number of raw requests i get to the...