Ads displayed for guests and not donating members only. Get ad-free by donating. If you have already donated, please read here.
  • High priority uploading queue and more charts for donation?

    As the server is once more under heavy fire from many users I have to think to upgrade to a bigger server or to limit acceptance for new users.


    Currently the server is processing 61000 uploads a day, additionally handling visits of ~4500 users with ~35000 pageimpressions and a lot more served images.
    MySQL is processing ~320 queries per second in the evening hours. We are talking about a database with a size of 58 GB and 152 Mio rows.


    What do you think about a high priority uploading queue and even more charts for a small donation?
    So if you donate some bucks you will get that stuff for the next 30 days.


    Existing service will of course not be touched, but in high traffic times you will have to wait for your uploads and charts.


    Right now there are around 26000 registered users, most of them are uploading regulary. If only 1% of them would pay 50 Cent per month I could lend a second server dedicated to database operations.


    The collected money will be invested in a SSD (+34 EUR per month) to speed up the MySQL Database.


    Link to the poll:
    http://www.vbaddict.net/showthread.p...s-for-donation
    This article was originally published in forum thread: High priority uploading queue and more charts for donation? started by Phalynx View original post
    Comments 14 Comments
    1. Bastogne.eu's Avatar
      Bastogne.eu -
      I'd pay a small fee, as you know I donated already in the past, but before I do so I'd like to see my 84 files waiting for upload since 3 days, being uploaded. I understand your problems with the heavy load, but I do not understand why all of a sudden no uploads are possible since last Friday.

      Regards,
      Bastogne
    1. BugMan.eu's Avatar
      BugMan.eu -
      I would also be prepared to offer a small donation as i have 2 machines with about 80-100 uploads waiting.
      While not wanting any priority over other, my 2 machines have been queuing for 2 days now with about 60-100 battles per day in a weekend if i can sneak it past the wife.
      Is there any way of providing an idea of the wait time, or some form of queue number, just so we have an idea the wait.
      The project is the best i've seen, by far, keep up the good work.

      BugMan
    1. OldManBill.na's Avatar
      OldManBill.na -
      I would be willing to donate a monthly amount to get priority uploads. Have not been able to upload a single file for the past two days. I believe I made a substantial donation in the past.
    1. JAPPY.eu's Avatar
      JAPPY.eu -
      in the order below, I would...

      1- Estimate the total cost for the upgrade
      a- open a donation page related to this cost
      b- advertise of the project everywhere you have your data, including a new version of teh uploader with the information related to the upgrade project
      c- do the upgrade once the cost is covered by donations. Of course. let users know where we are in the "upgrade project" donation

      2- find a friend (who you know in real life) for mirroring, sharing or added server power (I don't know the tech...)

      3- limit the number of players

      But definitely, do not spend your own money. keep it for paying premium for your own account on WoT, or saving...
    1. Theurge.na's Avatar
      Theurge.na -
      I think this service is great. I don't have any problem with donating, but I don't like that you're getting out the message that you need donations by holding the userbase hostage with server busy messages. I don't think the upload problems the past few days are because of higher-than-usual volume. I think you've just severely limited the server or turned it off entirely. Saying it's a load issue makes you seem dishonest and doesn't make me want to open my wallet.

      Feel free to correct me. Graphs would be convincing.

      If you went to a premium model, how would the server distinguish between paying users and free users? Would the client have login credentials stored, or would the server make the determination based on data in the battleresults being uploaded?

      And why not put ads on? Removed for premium users, of course, if you go that route. Many people with adblockers can be guilted into disabling it for a specific site.
    1. DeusEstMortuus's Avatar
      DeusEstMortuus -
      Quote Originally Posted by Theurge View Post
      And why not put ads on? Removed for premium users, of course, if you go that route. Many people with adblockers can be guilted into disabling it for a specific site.
      I for one disable adblocker for all sites that I like so long as they don't have horribly obnoxious ones.

      Also only 50 cents a month / 6 bucks a year? I'd be willing to chip in that much for sure.
    1. pagandk.eu's Avatar
      pagandk.eu -
      Donations haven't worked, so do whatever you need to get the cash and make a profit off your awesome work here. Premium and ads! do them both and more if needed.
    1. bounceplink's Avatar
      bounceplink -
      I'm more than willing to support the site. I'd like to see the tank statistics updated more than once per week, though.
    1. Phalynx.eu's Avatar
      Phalynx.eu -
      Quote Originally Posted by JAPPY View Post
      in the order below, I would...

      1- Estimate the total cost for the upgrade
      a- open a donation page related to this cost
      b- advertise of the project everywhere you have your data, including a new version of teh uploader with the information related to the upgrade project
      c- do the upgrade once the cost is covered by donations. Of course. let users know where we are in the "upgrade project" donation

      2- find a friend (who you know in real life) for mirroring, sharing or added server power (I don't know the tech...)

      3- limit the number of players

      But definitely, do not spend your own money. keep it for paying premium for your own account on WoT, or saving...
      Thanks for the heads up. Finally the solution with the SSD is now in place. I will now open up a donation question every new month to keep my costs low.
    1. pagandk.eu's Avatar
      pagandk.eu -
      phalynx you shouldn't have costs associated with this.. and all the work you have put in. You should have a profit. Good luck with the project
    1. Phalynx.eu's Avatar
      Phalynx.eu -
      Quote Originally Posted by Theurge View Post
      I think this service is great. I don't have any problem with donating, but I don't like that you're getting out the message that you need donations by holding the userbase hostage with server busy messages. I don't think the upload problems the past few days are because of higher-than-usual volume. I think you've just severely limited the server or turned it off entirely. Saying it's a load issue makes you seem dishonest and doesn't make me want to open my wallet.


      Feel free to correct me. Graphs would be convincing.


      If you went to a premium model, how would the server distinguish between paying users and free users? Would the client have login credentials stored, or would the server make the determination based on data in the battleresults being uploaded?


      And why not put ads on? Removed for premium users, of course, if you go that route. Many people with adblockers can be guilted into disabling it for a specific site.
      Another rant against busy servers. Do you really think the server is just for you? You are the only one who should be able to use it? This is not the first time I'm facing real performance problems.


      Just a short reminder about my recent actions to lower the processing usage:


      http://www.vbaddict.net/content.php?...nup-on-Replays

      http://www.vbaddict.net/content.php?22-Cleanup!

      http://www.vbaddict.net/content.php?...was-successful

      And now we are again here where I have to find something I can disable or even delete to not disturb the normal processing / others users. But right now I've reached a point where optimizing does not help anymore. Processing of data increases with every day thousands users are uploading their data.


      This "server busy" is not a problem of today, it's a problem of yesterday which has just explode today.


      Just a few numbers from successful uploads:
      month year Successful_Uploads
      01.09.2012 868832
      01.10.2012 873663
      01.11.2012 968736
      01.12.2012 946764
      01.01.2013 1163454
      01.02.2013 2075239
      01.03.2013 1609244
      01.04.2013 1750134
      01.05.2013 1658199




      Right now I just asked if some users would accept to pay monthy a donation for faster uploads, and the users donated me some bucks. Even smaller sums with just 1 Euro, but every single Euro helps me to pay the bill. With that money I invested in the rent of an SSD of 240 GB, which is enough to serve as disk for the MySQL database.


      Technically there is currently no possibility to realize such a service, but I will work on this.
    1. Golem501.eu's Avatar
      Golem501.eu -
      I'll have a look to see if I can find the donate button...
    1. mintik.eu's Avatar
      mintik.eu -
      You can make a premium function to upload replays since you need most of the storage for replays. So that will take a load of the traffic.
    1. Phalynx.eu's Avatar
      Phalynx.eu -
      Replays will be not be stored on client side within the next patches, they will be stored in the cloud on WG's Server. So this is a dying feature.