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
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:gurgen@stripped]
> > Sent: Tuesday, August 24, 2004 8:33 AM
> > To: cluster@stripped
> > 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=1
> >
> >
>
