Harri, Many thanks for your answer! On Fri, 2008-04-25 at 07:38 +0300, Harri.Paivaniemi@xxxxxxxxxxxxxxx wrote: > If you need high select- performance but only moderate update/insert/delete, > then it's easy and robust way to: Yes, I need one solution LAMP-HA for Wordpress, Joomla, Moodle, ForumPHPBB and others "default" applications... > - cluster master-db as active-hot standby (with RHCS) Standby... like heartbeat? > - use mysql proxy to split selects and run many slaves for selects in loadbalance pool behind > one VIP Dude... this solution sound like very good/crazy/wonderful! :) I've spend a lot of days reading/testing the "mysql-proxy" http://forge.mysql.com/wiki/MySQL_Proxy "...load balancing; failover; query analysis; query filtering and modification..." And this feature, give me totally crazy: http://jan.kneschke.de/2007/8/26/mysql-proxy-more-r-w-splitting This should solve my problem, but it's not working very well :-( http://bugs.mysql.com/bug.php?id=30304 Do you have been used this proxy before? Can you give-me some trick/tip around? :-p > - use bin- replication master --> slaves Yes... I think on this, but I can't separe R from W from all applications from my self :-( Thanks! -- Tiago Cruz http://everlinux.com Linux User #282636 -- Linux-cluster mailing list Linux-cluster@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/linux-cluster
