59 messages in com.mysql.lists.clusterRE: Help me...!
FromSent OnAttachments
Gurgen Petrosyan24 Aug 2004 06:32 
Crouch, Luke H.24 Aug 2004 06:56 
Crouch, Luke H.24 Aug 2004 21:49 
Magnus Svensson25 Aug 2004 01:58 
Lars Thalmann25 Aug 2004 04:21 
Gurgen Petrosyan25 Aug 2004 06:02 
Lars Thalmann25 Aug 2004 07:39 
Gurgen Petrosyan25 Aug 2004 13:29 
Tomas Ulin14 Sep 2004 02:37 
Tomas Ulin14 Sep 2004 05:20 
Gurgen Petrosyan14 Sep 2004 08:34 
Gurgen Petrosyan14 Sep 2004 10:32 
Gurgen Petrosyan14 Sep 2004 11:02 
Tomas Ulin16 Sep 2004 06:35 
Gurgen Petrosyan16 Sep 2004 12:38 
Gurgen Petrosyan16 Sep 2004 13:10 
Gurgen Petrosyan17 Sep 2004 12:56 
Gurgen Petrosyan17 Sep 2004 14:41 
Sharad Maloo20 Sep 2004 07:12 
Gurgen Petrosyan20 Sep 2004 13:39 
Magnus Svensson22 Sep 2004 05:28 
Bruce Robertson22 Sep 2004 10:00 
Gurgen Petrosyan22 Sep 2004 13:59 
Gurgen Petrosyan22 Sep 2004 14:21 
Gurgen Petrosyan22 Sep 2004 14:35 
Gurgen Petrosyan22 Sep 2004 14:39 
Gurgen Petrosyan22 Sep 2004 15:49 
Mikael Ronström23 Sep 2004 00:20 
Mikael Ronström23 Sep 2004 00:29 
Gurgen Petrosyan03 Oct 2004 11:32 
Crouch, Luke H.04 Oct 2004 06:12 
Gurgen Petrosyan04 Oct 2004 13:58 
pek...@mysql.com08 Nov 2004 05:16 
Gurgen Petrosyan08 Nov 2004 12:51 
Joseph E. Sacco, Ph.D.11 Nov 2004 05:18 
Gurgen Petrosyan11 Nov 2004 05:25 
Gurgen Petrosyan28 Nov 2004 08:47 
Jonas Oreland29 Nov 2004 00:15 
Klaus Byskov Pedersen18 Jan 2005 00:27 
Mikael Ronström18 Jan 2005 02:14 
Gurgen Petrosyan18 Jan 2005 07:21 
Gurgen Petrosyan18 Jan 2005 08:47 
Gurgen Petrosyan18 Jan 2005 09:00 
Gurgen Petrosyan18 Jan 2005 09:17 
Jon Stephens02 Feb 2005 09:03 
Mikael Ronström02 Feb 2005 11:21 
Gurgen Petrosyan02 Feb 2005 16:28 
Jon Stephens02 Feb 2005 18:16 
Jon Stephens07 Feb 2005 09:16 
Gurgen Petrosyan07 Feb 2005 10:18 
Gurgen Petrosyan09 Feb 2005 11:51 
Stefan Hinz23 Feb 2005 06:12 
Eric Bergen05 Mar 2005 11:36 
Gurgen Petrosyan05 Mar 2005 12:56 
Gurgen Petrosyan05 Mar 2005 14:00 
Gurgen Petrosyan05 Mar 2005 14:15 
Jon Stephens05 Mar 2005 18:20 
Jon Stephens07 Mar 2005 07:35 
Gurgen Petrosyan07 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