News for today: Weve turned off the ad view page for the moment, as we have too many users for our current server configuration. And if youre all viewing ads, its killing the website... Were working on the necessary to scale our servers & coding to cope with our huge growth of late, and as soon as thats ready, well put the ad view process back online. * We have extended all active ads by 48hours (and we can extend further if necessary) , so you wont lose any ads as a result of this maintenance. The ads will be waiting for you when we get everything fully functional (and speedy!) again. ---- Ill copy a few programmer messages to show you where were at: Daniel K. a day ago - reff daily stats to redis - frequent lock on stats table - partitioning issues table - investigated some other things which should be moved to redis, to be continued tomorrow Daniel K. about 14 hours ago - preparation for DB repliacation - audit results analisys - moving ad interaction to Redis Alex (last night) Ok quick update before I head out to bed. I have successfully set up 2 Mysql 5.6 databases replicating. Simple replication works fine. The next test is to create a quick CodeIgniter testbench that will allow writes on DB1 and reads on DB2. Then stress test it all to see if it can cope with load. Good night all Alex... This morning: Good morning, The replication has been successful and I am now in a position where I write on DB1 (master) which then replicates on DB2 (slave), then I can read back from DB2. That way we can theorically offload the big page generation like portfolio onto a different server, keeping the main one free. Backups will also be able to move onto a slave. Now there are several other things I need to try, including a replication failure - how can we recover from it... Ill keep you updated, but I think we should order 1 new DB server to be slave. What do you guys think? Daniel Thats a very good news In the worst case, we can use this old server which is still connected. But, I also prefer to have a faster one. With more cores for operations and a bigger disk of course. So, maybe we should simply order a new DB server, with configuration copied from the current one ? Alex That was my thinking yes. We keep using the main server as we are, change it to be a master server and add a new server which will be the slave. Ideally we need the same server in terms of hardware and software. In the long term, it may be possible to have more than 1 slave and use some kind of sharding in order to query the right database. For example, lets consider we have 1 Master and 3 Slaves. Everything gets written on the Master which is as we are now, but we want to perform the hardest reads on the slaves by sharding the connections. We could use the user ID modulo number of slave servers... Meaning that User ID 1 will get its data from Slave 1, User ID 2 from Slave 2, User ID 3 from Slave 3, User ID 4 from Slave 1, User ID 5 from Slave 2, etc... And if we need to add more servers, then we change the modulo divider - simplez ... To which I have just replied requesting the programmers place the order with iweb for the new equipment. And ive insisted that they buy not one, but 2 additional dedicated servers, so that we have some spare capacity to tap into as of when. * As im certain that if for nothing else, we can make use of the 3rd database server as we build multiplayer poker... Thats definitely going to require extra capacity in one form or another; so I dont mind spending a few hundred bucks a month to have a spare server lying around, connected & ready for instant utilization as the programmers require it. .... Ive also told the programmers to turn the ad view process back on as soon as they think the site can handle it... But its still offline for the moment, so I suppose there is more work to be done. But Alex seems to be actively helping us right now; so thats great news. And I would imagine well get a very speedy solution to our problems - provided iweb doesnt create a delay installing new equipment. ------ And just to reassure people... Our problems are good problems, we simply have too many users viewing ads for our current server architecture and coding. But thats a straight forward fix, just takes a few days to deploy. The system is completely liquid. There are $464k in user account balances (that can potentially be withdrawn)... but last time I checked we were sitting on almost $900k in cash assets. Theres $440k in PayPal alone. So this is no ponzi thats lost its momentum, and is going to bankrupt as a few people panic & cashout... Weve simply incurred a small problem, like hundreds before, these last 3 years... For which well get it sorted, and be back to business as usual before you know it. We just require a bit of patience... the website is still online, you can cashout your balance at any point. Were good... theres just some work to be done, like always! Jo Sorce: https://mytrafficvalue/forum/news/dec_1st_daily_news/1.html
Posted on: Mon, 01 Dec 2014 13:24:28 +0000
Trending Topics
Recently Viewed Topics
© 2015