Home / user-36226

Eddy's questions

Martin Hope
Eddy
Asked: 2012-05-20 00:27:35 +0800 CST
  • 1

little theoretical question. I'm done setting up a bunch of 2-node MySQL 5.1 clusters user the control of several MMM instances.

We started some testing, joyously kill -9 the writer nodes and all went fine with the app chugging along, oblivious of the DBMS turmoils.

Then I thought, what if in production first server A goes down, server B takes over and more work is done, and finally B goes down as well.

If the sysadmin restarts the cluster first from A and later joins B while in the meantime work is done on the outdated data of A?

Does MySQL have a quorum mechanism that keeps A (or even B) in Recovery mode until it has decided what is the most recent transaction to continue from?

Thanks and apologies if it's an FAQ...

mysql cluster
Martin Hope
Eddy
Asked: 2011-05-21 04:42:37 +0800 CST
  • 0

I'm upgrading a V9.1 to a v9.7

The scripts for compatibility checks pass but

/opt/ibm/db2/V9.7/instance/db2iupgrade -d -u db2fenc1 db2inst1

fails with the following error message:

db2: symbol lookup error: db2: undefined symbol: sqltGetCompTraceFlag
Update DBM cfg SYSADM_GROUP errcode = 127
DBI1281E  The database manager configuration file could not be
      initialized.
...

According to the script log it chokes on get_db2dir_ver() from db2iutil. If I run the command manually as:

/opt/ibm/db2/V9.7/bin/db2fupdt -f /home/db2inst1/sqllib/ctrl/.instuse -p DB2DIR

I get: 

/opt/ibm/db2/V9.1

I have lost hope...

db2