sql node and storage node concept, state of cluster.
Posted by:
Qiang Li
Date: May 09, 2005 09:19AM
hello,
i am reading the 16.3.5. Loading Sample Data and Performing Queries, for the part of migrating the non-cluster mysq db to mysql cluster. I have couple questions.
First,
it was talking about loading the db.sql into sql nodes. my question is that, what will happen once the loading finished? everything i load to the sql node will store in storage node automatically?
Second:
the doc said "This means that, once the world database and its tables have been created on one storage node, you will need to issue the command CREATE DATABASE world; followed by FLUSH TABLES on each storage node in the cluster."
" It is important to note that NDB Cluster in MySQL 4.1 and MySQL 5.0 does not support autodiscovery of databases. once the world database and tables created on one storage node" when and how is this world database created ? don't you have to run create database on storage node manually ?
assuming i need to load the db into a new database world, i need to create the world database in sql node, then do the loading. what should i do after this ? go after EVERY storage node and create the new database world ?
Third question:
what is the state of MySQL cluster? is it readly for production ? should i wait till the MySQL 5.1 ? is it stable now ? How much more advantage does it have comparing with replication with InnoDB engine?
thanks for you help,
Qiang
Subject
Views
Written By
Posted
sql node and storage node concept, state of cluster.
2987
May 09, 2005 09:19AM
2604
May 09, 2005 11:46PM
2050
May 10, 2005 10:31AM
2219
May 10, 2005 10:54AM
1837
May 10, 2005 09:31PM
1871
May 11, 2005 08:38AM
2047
May 11, 2005 12:54PM
1957
May 12, 2005 07:02PM
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.