0
votes
0answers
43 views

best logic to Load balancing YiiFramework web app

I'm going to launch a Yii framework app next days, and i'm currently searching the best way to deploy it in order to scale and support high traffic. I use Amazon RDS to host the DB, and 2 Memcached ...
1
vote
1answer
106 views

Migrate to mysql replication server without interuption

I have a 3 apache2 / tomcat servers in a load balanced setup. Each tomcat server is connecting to a MySQL v5.0 database (all 3 share it). I created on the same network a MySQL v5.5 semisynchronus ...
0
votes
1answer
282 views

Would Sphinx be a good solution to solve server getting bogged with heavy MySQL reads?

I'm working on a site that I believe gets about 70k visits a day and it makes use of a lot of queries which uses UNION's over about 45 different tables, these tables generally range from about 15k ...
5
votes
3answers
752 views

MySQL load balancing

I'm looking into ways to balance the load on our MySQL infrastructure, and can't seem to find an answer that works for me... :) So, I have one big and fat server, that handles everything. Many DBs, ...
1
vote
2answers
2k views

Scaling a LAMP website hosted on EC2

I'm very new to all this - I've recently managed to launch my website on EC2. As next step, I want to learn how to scale the website. I have a general idea but wanted some input from the experts about ...
2
votes
5answers
147 views

Will having 3 servers + load balancer help in my situation?

I want to upgrade my server because of the high mysql loads causing slowness + whenever there were backup processes running on the DB, the DB would be inaccessible, so wanted some solution. My current ...