Re: I want cluster, can I use MySQL?
Hello. From http://www.mysql.com/products/cluster/faq.html: Near-linear scalability shown on system where each storage node executed on the following hardware: CPU:2x Intel Xeon Processors at 2.8 GHz Memory: 16GB RAM HDD:4 x 73GB SCSI RAID 1 Controller Gigabit Ethernet I think, the best counsultation you can take from MySQL commercial support, see https://order.mysql.com/?ref=ensita one more thing, about MySQL cluster with a 6-8GB database. Which processor do I need in each storage node for a decent performance? I am thinking Xeon 2.8 or 3.0 GB, do P4 good enought to power such cluster? Assume I have enough main memory Thanks Koon Yue Lam [EMAIL PROTECTED] wrote: Hi list ! I want a high availability DB whcih means I need failover andload balancing. Can I use MySQL cluster to achieve this? becasue MySQL cluster is only in gramma, I wonder if I can use it in a commerical environment. Also if my website is commerical, do I need to have commerical license of MySQL? How about MaxDB? Regards -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I want cluster, can I use MySQL?
Koon Yue Lam [EMAIL PROTECTED] wrote: Hello. You should have more than 4GB RAM total on your nodes. There is a very interesting thread, which will give you answers on many of your questions. http://lists.mysql.com/mysql/166116 Thanks, and I know if I use MySQL cluster, I need to have the entire table in main memory. so if I have 4GB size's database but only 2G main memoey, what would happen? would it didn't work or just work but low performance? Regards -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I want cluster, can I use MySQL?
Hello. MySQL cluster can be configured with a range of fail-over and load-balancing options. And it is really ready enough for commercial usage. Complete information about licensing you can request at [EMAIL PROTECTED] Koon Yue Lam [EMAIL PROTECTED] wrote: Hi list ! I want a high availability DB whcih means I need failover andload balancing. Can I use MySQL cluster to achieve this? becasue MySQL cluster is only in gramma, I wonder if I can use it in a commerical environment. Also if my website is commerical, do I need to have commerical license of MySQL? How about MaxDB? Regards -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I want cluster, can I use MySQL?
Hi list ! I want a high availability DB whcih means I need failover andload balancing. Can I use MySQL cluster to achieve this? becasue MySQL cluster is only in gramma, I wonder if I can use it in a commerical environment. Also if my website is commerical, do I need to have commerical license of MySQL? How about MaxDB? Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]