RE: ~Mysql cluster info~
Hello, MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database (tables, indexes, etc.) must fit in RAM along with your other OS and application processes. In 5.1, we have introduced disk-based data support. Note, that although data can now be stored on disk, indexes must still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ~Mysql cluster info~
Hello Jimmy, Do we have a production release of MYSQL cluster 5.1 ? If yes please let me know the path from where i can download the same. Thanks in advance, Abdul. On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote: Hello, MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database (tables, indexes, etc.) must fit in RAM along with your other OS and application processes. In 5.1, we have introduced disk-based data support. Note, that although data can now be stored on disk, indexes must still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ~Mysql cluster info~
Hello, Not at this time, currently 5.1 is in Beta. We should see a release candidate soon, but I can't commit to a specific date at this time. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 9:30 PM To: Jimmy Guerrero Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: ~Mysql cluster info~ Hello Jimmy, Do we have a production release of MYSQL cluster 5.1 ? If yes please let me know the path from where i can download the same. Thanks in advance, Abdul. On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote: Hello, MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database (tables, indexes, etc.) must fit in RAM along with your other OS and application processes. In 5.1, we have introduced disk-based data support. Note, that although data can now be stored on disk, indexes must still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~Mysql cluster info~
Good evening - I'd like to chime in saying that I've been using 5.1.7 with a lot of success. I'm sure there's a bit to go with it's development, but half the stuff that the MySQL dev team is working on, we will never use. Your case may vary. I can't speak for the MySQL guys, but as far as my testing is concerned, I've seen 5.1.7 to be very nice so far - specifically in regards to cluster. Thanks -dant Jimmy Guerrero wrote: Hello, Not at this time, currently 5.1 is in Beta. We should see a release candidate soon, but I can't commit to a specific date at this time. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 9:30 PM To: Jimmy Guerrero Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: ~Mysql cluster info~ Hello Jimmy, Do we have a production release of MYSQL cluster 5.1 ? If yes please let me know the path from where i can download the same. Thanks in advance, Abdul. On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote: Hello, MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database (tables, indexes, etc.) must fit in RAM along with your other OS and application processes. In 5.1, we have introduced disk-based data support. Note, that although data can now be stored on disk, indexes must still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This email has been Scanned for Viruses! www.newbreak.com -- - Dan Trainor - id-Confirm, Inc. - Direct: 720.241.5580 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]