I have a Mysql DB with a Hight traffic. Uptime: 5171611 Threads: 8 Questions: 1524716322 Slow queries: 68295 Opens: 207930 Flush tables: 1 Open tables: 63
is posible install a Master Mysql and many slave data bases?, like a piramid structure in order to balance the data and distribute the traffic??.
Thank you
Yes. Read this article: http://www.phpbuilder.com/columns/tanoviceanu20000912.php3
But note: a slave server cannot be used to insert data into, due to primary key constraints.
PS: 294 Q's/sec. Don't you think it's about time to check just what kind of queries you are doing? if you need 294 queries per second on average, you must have either a huge website, or every page you show runs 40 queries.
Yes, I have a very Big Website. I use to offer stock in REAL TIME (more or less). :-D, So I can confirm that MySQL its very, very fast. Its great!!!!.
Thank you very much for your reply and Im sorry for my bad english
Still, I guess you run quite a few queries per page? Why don't you see if you can cut down on the number of queries first, before you start messing about with load-balancing.
