Gábriel Ákos wrote:
LiRul wrote:
Csak egyet emlitek: egy tablan 15 mezon volt index, nana hogy elszallt
vissza-dump-olas index limit miatt. (Ez csak egy, volt szivas mas miatt
is.) Nehez oket rabeszelni a valtoztatasra, ha egyszer single mysql
alatt ezek nem problemak. :-/
Ez valoban egy xar. Erre tervezni kell(ett volna ugye), bar ez eleg
karcsu akarhogy is nezzuk...
Konfiguralhato, csak nagyobbra kell(ett volna) allitani az indexmemory-t
a konfigban.
De amugy eleg
komoly hianyossagai vannak az ndbclusternek.
Mire gondolsz?
Csak amit hirtelen talaltam:
The main disadvantages of MySQL Cluster are (as of MySQL 5.0):
The database is in memory only, thus requiring more resources than a
broaf
Azert ez a Jerevani radio hireire emlekeztet.
MySQL Cluster is a technology that enables clustering of in-memory
databases in a shared-nothing system. The shared-nothing architecture
allows the system to work with very inexpensive hardware, and without
any specific requirements on hardware or software. It also does not have
any single point of failure because each component has its own memory
and disk.
normal MySQL database. (MySQL 5.1 introduces table spaces, with the
capability of storing nonindexed data on disk.)
Some normal features are not available, such as full-text searches,
referential integrity, and transaction isolation levels higher than READ
COMMITTED.
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
gratulalok. Ez nem cluster, ez gany. :)
Inkabb innen tajekozodjal:
http://www.mysql.org/doc/refman/5.0/en/mysql-cluster-limitations.html
--
Gabor HALASZ <[EMAIL PROTECTED]>
_________________________________________________
linux lista - [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux
