MySQL Forums
Forum List  »  NDB clusters

Different row counts on replicas on mysql cluster
Posted by: Kenan Ozturk
Date: April 28, 2005 02:33AM

hi all,

we have a cluster system that consists of one management server and two data nodes.

when we run "select coun(*) from table_name" on both replicas, we get different row counts!

so what causes this problem? how can we solve it?

I will be grateful if someone helps us!

Regards,

Kenan

Here is our config.ini file
#####################
[NDBD DEFAULT] # Options affecting ndbd processes on all storage nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=52M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.

[TCP DEFAULT] # TCP/IP options:
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead

[NDB_MGMD]
# Management process options:
hostname=10.34.35.21 # Hostname or IP address of MGM node
datadir=/space/mysql/mysql-cluster # Directory for MGM node logfiles

[NDBD]
# Options for storage node "A":
# (one [NDBD] section per storage node)
hostname=10.34.35.22 # Hostname or IP address
datadir=/space/mysql/mysql/data # Directory for this storage node's datafiles

[NDBD]
# Options for storage node "B":
hostname=10.34.35.23 # Hostname or IP address
datadir=/space/mysql/mysql/data # Directory for this storage node's datafiles

[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]

Options: ReplyQuote


Subject
Views
Written By
Posted
Different row counts on replicas on mysql cluster
2819
April 28, 2005 02:33AM


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.