59 messages in com.mysql.lists.clusterRE: Help me...!| From | Sent On | Attachments |
|---|---|---|
| Gurgen Petrosyan | 24 Aug 2004 06:32 | |
| Crouch, Luke H. | 24 Aug 2004 06:56 | |
| Crouch, Luke H. | 24 Aug 2004 21:49 | |
| Magnus Svensson | 25 Aug 2004 01:58 | |
| Lars Thalmann | 25 Aug 2004 04:21 | |
| Gurgen Petrosyan | 25 Aug 2004 06:02 | |
| Lars Thalmann | 25 Aug 2004 07:39 | |
| Gurgen Petrosyan | 25 Aug 2004 13:29 | |
| Tomas Ulin | 14 Sep 2004 02:37 | |
| Tomas Ulin | 14 Sep 2004 05:20 | |
| Gurgen Petrosyan | 14 Sep 2004 08:34 | |
| Gurgen Petrosyan | 14 Sep 2004 10:32 | |
| Gurgen Petrosyan | 14 Sep 2004 11:02 | |
| Tomas Ulin | 16 Sep 2004 06:35 | |
| Gurgen Petrosyan | 16 Sep 2004 12:38 | |
| Gurgen Petrosyan | 16 Sep 2004 13:10 | |
| Gurgen Petrosyan | 17 Sep 2004 12:56 | |
| Gurgen Petrosyan | 17 Sep 2004 14:41 | |
| Sharad Maloo | 20 Sep 2004 07:12 | |
| Gurgen Petrosyan | 20 Sep 2004 13:39 | |
| Magnus Svensson | 22 Sep 2004 05:28 | |
| Bruce Robertson | 22 Sep 2004 10:00 | |
| Gurgen Petrosyan | 22 Sep 2004 13:59 | |
| Gurgen Petrosyan | 22 Sep 2004 14:21 | |
| Gurgen Petrosyan | 22 Sep 2004 14:35 | |
| Gurgen Petrosyan | 22 Sep 2004 14:39 | |
| Gurgen Petrosyan | 22 Sep 2004 15:49 | |
| Mikael Ronström | 23 Sep 2004 00:20 | |
| Mikael Ronström | 23 Sep 2004 00:29 | |
| Gurgen Petrosyan | 03 Oct 2004 11:32 | |
| Crouch, Luke H. | 04 Oct 2004 06:12 | |
| Gurgen Petrosyan | 04 Oct 2004 13:58 | |
| pek...@mysql.com | 08 Nov 2004 05:16 | |
| Gurgen Petrosyan | 08 Nov 2004 12:51 | |
| Joseph E. Sacco, Ph.D. | 11 Nov 2004 05:18 | |
| Gurgen Petrosyan | 11 Nov 2004 05:25 | |
| Gurgen Petrosyan | 28 Nov 2004 08:47 | |
| Jonas Oreland | 29 Nov 2004 00:15 | |
| Klaus Byskov Pedersen | 18 Jan 2005 00:27 | |
| Mikael Ronström | 18 Jan 2005 02:14 | |
| Gurgen Petrosyan | 18 Jan 2005 07:21 | |
| Gurgen Petrosyan | 18 Jan 2005 08:47 | |
| Gurgen Petrosyan | 18 Jan 2005 09:00 | |
| Gurgen Petrosyan | 18 Jan 2005 09:17 | |
| Jon Stephens | 02 Feb 2005 09:03 | |
| Mikael Ronström | 02 Feb 2005 11:21 | |
| Gurgen Petrosyan | 02 Feb 2005 16:28 | |
| Jon Stephens | 02 Feb 2005 18:16 | |
| Jon Stephens | 07 Feb 2005 09:16 | |
| Gurgen Petrosyan | 07 Feb 2005 10:18 | |
| Gurgen Petrosyan | 09 Feb 2005 11:51 | |
| Stefan Hinz | 23 Feb 2005 06:12 | |
| Eric Bergen | 05 Mar 2005 11:36 | |
| Gurgen Petrosyan | 05 Mar 2005 12:56 | |
| Gurgen Petrosyan | 05 Mar 2005 14:00 | |
| Gurgen Petrosyan | 05 Mar 2005 14:15 | |
| Jon Stephens | 05 Mar 2005 18:20 | |
| Jon Stephens | 07 Mar 2005 07:35 | |
| Gurgen Petrosyan | 07 Mar 2005 11:39 |
| Subject: | RE: Help me...!![]() |
|---|---|
| From: | Crouch, Luke H. (Luke...@red-man.com) |
| Date: | 08/24/2004 09:49:03 PM |
| List: | com.mysql.lists.cluster |
I have no idea how to explain it in Russian...I only know some conversational
Russian. but here it is in English...
If you have 3 computers, each with 2 processors, I would suggest you run 4 DB
nodes on 2 computers (2 nodes on each computer) and the MGM (and possibly some
API nodes) on the 1st computer.
so your config.ini would look like this:
[COMPUTER] Id: 1 Hostname: computer1
[COMPUTER] Id: 2 Hostname: computer2
[COMPUTER] Id: 3 Hostname: computer3
[MGM] Id: 1 ExecuteOnComputer: 1
[DB DEFAULT] NoOfReplicas: 2 DataMemory: 600M IndexMemory: 200M
[DB] Id: 2 ExecuteOnComputer: 2 FileSystemPath: /var/node2/
[DB] Id: 3 ExecuteOnComputer: 2 FileSystemPath: /var/node3/
[DB] Id: 4 ExecuteOnComputer: 3 FileSystemPath: /var/node4/
[DB] Id: 5 ExecuteOnComputer: 3 FileSystemPath: /var/node5/
[API] Id: 6 ExecuteOnComputer: 1
[API] Id: 7 ExecuteOnComputer: 1
with these settings, your maximum database size is 800M - 600M for the data and
200M for indexes - limited by the comparatively small amount of RAM on those
machines (MySQL reccomends 16GB). you could set DataMemory and/or IndexMemory
higher, but Cluster behaves badly if it starts to use swap space, so you really
want to have enough RAM to cover your database size.
but, with this configuration, you will be maximizing the use of your
processors...each ndbd process will have its own processor, and each mysqld
process will have its own processor.
I hope that helps...I don't know of any Russian translation of the MySQL Cluster
manual...but I'd be willing to work on one with you and the MySQL guys maybe?
unless they already have someone who will be doing it?
-L
-----Original Message----- From: Gurgen Petrosyan [mailto:gur...@ipia.sci.am] Sent: Wed 8/25/2004 8:02 AM To: Crouch, Luke H. Cc: clus...@lists.mysql.com Subject: RE: Help me...!
Zdraste :) kstati kak mojno svami svyazatsya? ;) icq naprimer?
thank you but i have another question.
1. For me it is necessary MySQL Cluster (!) Manual, and in under your reference it is not present. If is MySQL Cluster Manual in Russian or other documentation in Russian about MySQL Cluster please prompt where
2. For an example: at me is 1 MGM node and 2 DB nodes MGM node configuration CPU 3.00Ghz HDD 40Gb RAM 1Gb 2
DB nodes Configuration CPU 2x3.00Ghz HDD 40Gb RAM 1Gb
what maximal size I can store the table and base in MySQL Cluster.
3. At me is DB node which will consist of 2 processors! Whether I on it can start 2 processes DB mysql separately everyone on one processor?
thank you again :)
On Tue, 24 Aug 2004, Crouch, Luke H. wrote:
privet!
http://dev.mysql.com/doc/mysql/ru/index.html
the maximum size of tables and databases in the cluster is controlled by a
setting in the config.ini called "DataMemory" and "IndexMemory". and remember
that the data is held in RAM, so you will need enough RAM to have your entire
database stored.
-L
-----Original Message----- From: Gurgen Petrosyan [mailto:gur...@ipia.sci.am] Sent: Tuesday, August 24, 2004 8:33 AM To: clus...@lists.mysql.com Subject: Help me...!
Hello
1. Where I can found MySQL Cluster Manual in russian language? plaesa help me...
2. What maximal sizes of the table and database in MySQL Cluster? And how this restriction operates? On everyone node?
thanks
-- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster?unsub=luke...@red-man.com




