This post just as a follow-up for thread HACMP 5.4 with AIX 5300-10 not working: there was a bug in the clcomdES that would cause the Two-Node-Cluster-Configuration-Assistant to fail even with a correct TCP/IP adapter setup. That affected HACMP 5.4.1 in combinatin with (at least) AIX 5.3 from TL6 to TL12 (did not try older oslevels but found a post that could imply the problem did not exist at and below TL5) and RSCT 2.4.13.0
Problem with HACMP 5.4.1 shows as
Using an empty or a manually edited cluster rhosts does not make any difference but leads to the same error.
Now, this is fixed with (at least) SP10 for HACMP 5.4.1 (did not try older HA Service Packs). I could not find an APAR with a suitable description. Maybe it was related to IZ70306: CLCOMD HACMPNETWORK MALLOC MEMORY LEAK CAUSES CLCOMDES FAILURES which dates to 2010-09-06. I am not sure about that as during my tests I never saw the 5901 ODM error mentioned in the description but it also says that the clcomdES dies after "few verification invocations" and there are verification checks during Assistant run and the bug caused an incomplete cluster rhosts setup which led me to identify clcomdES as the culprit.
Hi Guys,
I have two nodes clustered. Each node is AIX 5.2 & they are clustered with HACMP 5.2. The mode of the cluster is Active/Passive which mean one node is the Active node & have all resource groups on it & the 2nd node is standby.
Last Monday I noted that all resource groupes have been... (2 Replies)
Hi Guys,
I have to design a multinode hacmp cluster and am not sure if the design I am thinking of makes any sense.
I have to make an environment that currently resides on 5 nodes more resilient but I have the constrain of only having 4 frames. In addition the business doesnt want to pay for... (7 Replies)
Hi
Can ony one advise which files can be deleted in /usr in an aix hacmp node ? Im new to aix and Im not sure which files can be deleted ?
#df -g /usr
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd2 7.00 1.00 86% 67013 22% /usr
... (4 Replies)
Hi,
Is it possible to have a Solaris cluster of 2 nodes at SITE-A using SVM and creating metaset using say 2 LUNs (on SAN). Then replicating these 2 LUNs to remote site SITE-B via storage based replication and then using these LUNs by importing them as a metaset on a server at SITE-B which is... (0 Replies)
Hi,
I have a running HACMP Cluster with two nodes. Its working in active/passive mode. (i.e Out of the two nodes in the cluster one will be active and the other one will be on standby. If first node fails the other takes over)
1. There is a Service IP associated with the cluster. Now the... (2 Replies)
Hi,
I have a IBM Power series machine that has 2 VIOs and hosting 20 LPARS.
I have two LPARs on which GPFS is configured (4-5 disks)
Now these two LPARs need to be configured for HACMP (PowerHA) as well.
What is recommended? Is it possible that HACMP can be done on this config or do i... (1 Reply)
Setting up HACMP 6.1 on a two node cluster. The other node works fine and can start properly on STABLE state (VGs varied, FS mounted, Service IP aliased). However, the other node is always stuck on ST_JOINING state. Its taking forever and you can't stop the cluster as well or recover from script... (2 Replies)
Hi,
A customer I'm supporting once upon a time broke their 2 cluster node database servers so they could use the 2nd standby node for something else. Now sometime later they want to bring the 2nd node back into the cluster for resilance. Problem is there are now 3 VG's that have been set-up... (1 Reply)
HACMP two-node cluster with mirrored LVM.
HACMP two-node cluster with two SAN storages mirrored using LVM. Configured 2 disk heartbeat networks - 1 per each SAN storage. While performing redundancy tests. Once one of SAN storage is down - cluster is going to ERROR state. What are the guidelines... (2 Replies)
Hello AIX experts,
I have few queries and appreciate if you could help me with them.
1. How to check if HACMP (or any other AIX OS cluster) is installed
2. How to check if HACMP (or any other AIX OS cluster) is running
3. how to check which Oracle DB instance is running on it
4. how to... (1 Reply)
Discussion started by: prvnrk
1 Replies
LEARN ABOUT LINUX
ndbd_redo_log_reader
NDBD_REDO_LOG_REA(1) MySQL Database System NDBD_REDO_LOG_REA(1)NAME
ndbd_redo_log_reader - check and print content of cluster redo log
SYNOPSIS
ndbd_redo_log_reader file_name [options]
DESCRIPTION
Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or both. ndbd_redo_log_reader is intended
for use primarily by MySQL Cluster developers and Support personnel in debugging and diagnosing problems.
This utility remains under development, and its syntax and behavior are subject to change in future MySQL Cluster releases.
The C++ source files for ndbd_redo_log_reader can be found in the directory /storage/ndb/src/kernel/blocks/dblqh/redoLogReader.
The following table includes options that are specific to the MySQL Cluster program ndbd_redo_log_reader. Additional descriptions follow
the table. For options common to most MySQL Cluster programs (including ndbd_redo_log_reader), see Options Common to MySQL Cluster
Programs(1).
Table 17.22. ndbd_redo_log_reader Options and Variables: MySQL Cluster NDB 7.2
+----------------+---------------------------------+-------------------------------------+
|Format | Description | Added / Removed |
+----------------+---------------------------------+-------------------------------------+
| | Do not print records | |
| -noprint | | All MySQL 5.5 based releases |
+----------------+---------------------------------+-------------------------------------+
| | Do not check records for errors | |
| -nocheck | | All MySQL 5.5 based releases |
+----------------+---------------------------------+-------------------------------------+
| | Print usage information | |
| --help | | ADDED: NDB 7.2.15 |
+----------------+---------------------------------+-------------------------------------+
Usage
ndbd_redo_log_reader file_name [options]
file_name is the name of a cluster redo log file. redo log files are located in the numbered directories under the data node's data
directory (DataDir); the path under this directory to the redo log files matches the pattern ndb_#_fs/D#/LCP/#/T#F#.Data. In each case, the
# represents a number (not necessarily the same number). For more information, see MySQL Cluster Data Node FileSystemDir Files[1].
The name of the file to be read may be followed by one or more of the options listed here:
o
+--------------------+-------------------+
|Command-Line Format | -noprint |
+--------------------+-------------------+
| | Permitted Values |
| +---------+---------+
| | Type | boolean |
| +---------+---------+
| | Default | FALSE |
+--------------------+---------+---------+
-noprint: Do not print the contents of the log file.
o
+--------------------+-------------------+
|Command-Line Format | -nocheck |
+--------------------+-------------------+
| | Permitted Values |
| +---------+---------+
| | Type | boolean |
| +---------+---------+
| | Default | FALSE |
+--------------------+---------+---------+
-nocheck: Do not check the log file for errors.
o
+--------------------+-------------------+
|Introduced | 5.5.35-ndb-7.2.15 |
+--------------------+-------------------+
|Command-Line Format | --help |
+--------------------+-------------------+
--help: Print usage information.
Added in MySQL Cluster NDB 7.2.15. (Bug #11749591, Bug #36805)
Like ndb_print_backup_file and ndb_print_schema_file (and unlike most of the NDB utilities that are intended to be run on a management
server host or to connect to a management server) ndbd_redo_log_reader must be run on a cluster data node, since it accesses the data node
file system directly. Because it does not make use of the management server, this utility can be used when the management server is not
running, and even when the cluster has been completely shut down.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
NOTES
1. MySQL Cluster Data Node FileSystemDir Files
http://dev.mysql.com/doc/ndbapi/en/ndb-internals-ndbd-filesystemdir-files.html
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 NDBD_REDO_LOG_REA(1)