MySQL Forums
Forum List  »  NDB clusters

Re: MySQL Cluster for RT3.x (Request Tracker)
Posted by: Jonathan Miller
Date: July 04, 2005 08:49AM

Torsten,

> 1. The RT3 needs InnoDB as Table Format, the Cluster needs NDBCluster Format, can i run also InnoDB within the Cluster?

Yes, you can have a mix of NDB and InnoDB. For performance it would proabably be best to have the InnoDB on a different server then one hosting a cluster data node.

For example:
................................................web server........................................
.......................................................↕..............................................
.........――――――――――――――――――――――――――――――――――――――
.........↕.............................↕...............................↕.................................↕
.....Mysqld.......................NDB............................ NDB........................ndb_mgmd
....(InnoDB)..................(data node)..................(data node)
(also attaches -)
(to cluster)


This is just an example. There are many different ways this could be setup.

>3. More for the MySQL Freak: Can i set up the Cluster in this way? Can i use the SQL Node on the same nodes (Storage Nodes) or do i have to move them to the Management Node?

You do not have to move them, but see above about performance.

Thanks,

Jonathan Miller
Austin, Texas USA
Senior QA Developer

MySQL AB www.mysql.com

Jumpstart your cluster!
http://www.mysql.com/consulting/packaged/cluster.html

Get training on clusters
http://www.mysql.com/training/courses/mysql_cluster.html

All-in-one Enterprise-grade Database, Support and Services
http://www.mysql.com/network/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Cluster for RT3.x (Request Tracker)
2127
July 04, 2005 08:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.