6 messages in com.mysql.lists.clusterRe: Distribute the data base on two s...| From | Sent On | Attachments |
|---|---|---|
| Anurag | 16 Nov 2004 10:52 | |
| Sharad Maloo | 16 Nov 2004 11:22 | |
| Olivier Kaloudoff | 16 Nov 2004 13:23 | |
| Olivier Kaloudoff | 17 Nov 2004 01:22 | |
| Mikael Ronström | 17 Nov 2004 06:02 | |
| Mikael Ronström | 17 Nov 2004 06:08 |
| Subject: | Re: Distribute the data base on two servers |
|---|---|
| From: | Mikael Ronström (mik...@mysql.com) |
| Date: | 11/17/2004 06:08:40 AM |
| List: | com.mysql.lists.cluster |
2004-11-16 kl. 20.22 skrev Sharad Maloo:
On Tue, 16 Nov 2004, Anurag wrote:
I have three questions 1) Hi can you help me to understand how cluster will perform operation when it has database distributed on two different servers. and can some one help me with a sample config.ini
Even though this question has been raised quite a few times, never heard reply to such question from MySQL staff. My observations were : horizontal stipping of data, query decomposition and localization (based on partitioning) and then transporting intermediate results from one node to other.
There are a set of slides presenting many details about this from the MySQL Users Conference 2004. You can find them on the MySQL website. There are three different presentations on various parts of the MySQL Cluster architecture.
2) My cluster losses all the data when I restart my machine .What is the eror all about ??
It can recover if only a part of your system goes down. Its not very conclusive if it always recovers completely when you entire cluster goes down.
It should recover completely after the cluster goes down, if it doesn't it is either a bug or a mistake in using the --initial flag when it should not be used. Ensure that you only use the --initial at initial start and a few other rare cases defined in the MySQL manual.
Rgrds Mikael
3) sometimes after restart It doesnt allow me us the NDB engine and says cannot create because of error 4009 and error number 1005 Please help me as soon as possible ,(Please let me know if you want to see my config.ini ) .I have downloaded 4.1-8 Any sugesstion is invited
--
--- Sharad Maloo http://www.cse.iitb.ac.in/maloo
--- Human mind is like a parachute. It only works when it is open.
-- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster?unsub=mik...@mysql.com
Mikael Ronström, Senior Software Architect MySQL AB, www.mysql.com
Clustering: http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html
http://www.eweek.com/article2/0,1759,1567546,00.asp