Skip navigation links

MySQL Enterprise

Get Your "Virtual DBA Assistant" Today!



Learn about new MySQL releases, technical articles, events and more.

Subscribe Now »

MySQL 5.1 Cluster DBA Certification Study Guide – Errata

MySQL 5.1 Cluster DBA Certification Study Guide – Errata

This page lists errors in the text and contains better versions of pictures that are hard to read in the printed version.

Errors in the Text

  • Page xx, section 10: "To make it easier...the accompanying CD-ROM..." should not be there. The MySQL 5.1 Cluster Certification Study Guide does not include a CD-ROM. Instead, the world database should be downloaded from the MySQL documentation site, and modified as described in Appendix A of the study guide.
  • Page 16, first paragraph: "...it very important to provide..." should read "...it is very important to provide..."
  • Page 19, second bullet point: --ndb-cluster should be --ndbcluster.
  • Page 23, first bullet in the list: "Partition P1: ... (The primary replicas are labeled in black and the secondary replicas in red)" should read: "Partition P1: ... (The primary replicas F1, F3, F2, F4 appear in the upper part of de data nodes and are indicated in a black font, the secondary replicas F3, F1, F4, F2 appear in the bottom part of the data nodes and are printed in a lighter, gray font)"
  • Page 26, answer 4: "Answer a (Authentication)" should be "Answer a (It is also known as an executive node)"
  • Page 31, last full sentence on page: "...data to disks" should read "data to disk"
  • Page 32, first paragraph: The last sentence should read, "The SQL node then contacts a data node, which becomes its transaction coordinator, with the request."
  • Page 35, second paragraph: "For example, in a two-node, two-replica cluster..." should read, "For example, in a four-node, two-replica cluster..."
  • Page 36, fourth paragraph: "...from the nod group's current primary node." should read, "...from the node group's current primary node."
  • Page 37, first bullet: "This copy stored on disk..." should read, "This copy is stored on disk...".
  • Page 40, Answer 9: "Answers a (Double words) and c (Exact fractional portions)..." should read, "Answers a (Double words) and d (Exact fractional portions)...".
  • Page 45, second bullet: "--connect-string" should read, "--connectstring".
  • Page 47, row of table starting with "--initial": "...files, logs, and backups to be deleted (and recreated)." should read, "...files, logs, and backups to be deleted."
  • Page 47, first bullet: "ndb-connectstring (or connectstring)" should read, "ndb-connectstring (or connect-string)".
  • Page 48, last bullet: "engine_condition_pushdown" should read, "engine-condition-pushdown".
  • Page 51, last paragraph in section: "..for mroe information" should read, "..for more information".
  • Page 52, third bullet on page: "Hash indexes are always used for primary key indexes, unique indexes, and unique constraints." should read, "Hash indexes are always used for primary keys and unique indexes."
  • Page 53, Important item: "...via a rolling node restart." should read, "...via a rolling node initial restart."
  • Page 54, second paragraph: "This parameter can be changed during an online software upgrade..." should read, "This parameter can be changed during a rolling node restart...".
  • Page 54, fourth bullet on page: "...this parameter should be set to a much smaller value." should read, "...this parameter should be set to a relatively small value."
  • Page 57, sixth bullet: "--ndb-connectstring=connectstring, -c connectstring" should read, "--ndb-connectstring=connectstring, -c connectstring".

Better Versions of Pictures

  • Page 22, Cluster Partitioning:
  • Page 23, Nodes and Node Groups:
  • Page 24, Nodes and Node Groups:
  • Page 24, Nodes and Node Groups:
  • Page 60, Using ndb_size.pl to Estimate Memory Requirements:
  • Page 102, Rolling restarts:
  • Page 130, 4-Byte Alignment:
  • Page 136, Extents:
  • Page 176, Using Condition Pushdown Effectively: