From: Luke H. Crouch
Date: August 25 2004 4:49am
Subject: RE: Help me...!
List-Archive: http://lists.mysql.com/cluster/460
Message-Id: <075C170BC7219F439DD3FE8C880648C1AB0ABD@red-ivy.red-man.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

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:gurgen@stripped]
Sent:	Wed 8/25/2004 8:02 AM
To:	Crouch, Luke H.
Cc:	cluster@stripped
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=20
reference it is not present. If is MySQL Cluster Manual in Russian or=20
other documentation in Russian about MySQL Cluster please prompt where=20

2. For an example: at me is 1 MGM node and 2 DB nodes=20
MGM node configuration=20
CPU 3.00Ghz=20
HDD 40Gb=20
RAM 1Gb 2=20

DB nodes Configuration=20
CPU 2x3.00Ghz=20
HDD 40Gb=20
RAM 1Gb=20

what maximal size I can store the table and=20
base in MySQL Cluster. =20

3. At me is DB node which will consist of 2 processors! Whether I on it=20
can start 2 processes DB mysql separately everyone on one processor?=20


thank you again :)

On Tue, 24 Aug 2004, Crouch, Luke H. wrote:

> privet!
>=20
> http://dev.mysql.com/doc/mysql/ru/index.html
>=20
> 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.
>=20
> -L
>=20
> > -----Original Message-----
> > From: Gurgen Petrosyan [mailto:gurgen@stripped]
> > Sent: Tuesday, August 24, 2004 8:33 AM
> > To: cluster@stripped
> > Subject: Help me...!
> >=20
> >=20
> > Hello
> >=20
> > 1. Where I can found MySQL Cluster Manual in russian language?
> > plaesa help me...
> >=20
> >=20
> > 2. What maximal sizes of the table and database in MySQL Cluster?=20
> > And how this restriction operates? On everyone node?=20
> >=20
> > thanks
> >=20
> >=20
> >=20
> > --=20
> > MySQL Cluster Mailing List
> > For list archives: http://lists.mysql.com/cluster
> > To unsubscribe:   =20
> > http://lists.mysql.com/cluster?unsub=3Dluke.crouch@stripped
> >=20
> >=20
>=20