The MySQL Cluster API Developer Guide

This guide provides information for developers wishing to develop applications against MySQL Cluster. Application interfaces covered include the low-level C++-language NDB API for the MySQL NDBCLUSTER storage engine, the C-language MGM API for communicating with and controlling MySQL Cluster management servers, and the MySQL Cluster Connector for Java, which is a a collection of Java APIs introduced in MySQL Cluster NDB 7.1 for writing applications against MySQL Cluster, including JDBC, JPA, and ClusterJ.

via MySQL :: The MySQL Cluster API Developer Guide.

A step-by-step plan to starting a consulting business

During my career, I have also worked as a recruiter and a managing director at a consulting company. My varied experiences have given me the opportunity to talk with hundreds of consultants over the years. From both my own experiences and the experiences of others, I’ve developed a start-up plan for those seeking to head into consulting.

Via A step-by-step plan to starting a consulting business | TechRepublic.

ERROR 1130 (HY000): Host ‘hostname’ is not allowed to connect to this MySQL server

After a bit of research, the fix in my case was to “GRANT” user root to connect to MySQL on any hosts. By default, user “root” was only allowed to connect to localhost and 127.0.0.1 hosts of MySQL.

#GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘<roots-password>’ WITH GRANT OPTION;

via ERROR 1130 (HY000): Host ‘hostname’ is not allowed to connect to this MySQL server – kuber’s posterous.

Create Your Own Web Server With BIND And Apache On CentOS 5 (Simplified)

Installing necessary packages

yum install bind bind-chroot bind-libs bind-utils caching-nameserver -y

After installing the necessary packages you are ready to start configuring named.conf. You may check and see that there is no named.conf in your /etc/ directory in Centos 5. No worries here you can see a sample named.conf file. Now create the file /etc/named.conf and copy/paste the content of the sample config file – just make sure you replace website.com with your own domain name.

via Create Your Own Web Server With BIND And Apache On CentOS 5 (Simplified) | HowtoForge – Linux Howtos and Tutorials.

Centos making things difficult again.

Referential integrity

Referential integrity is a property of data which, when satisfied, requires every value of one attribute (column) of a relation (table) to exist as a value of another attribute in a different (or the same) relation (table).[1]

For referential integrity to hold in a relational database, any field in a table that is declared a foreign key can contain only values from a parent table’s primary key or a candidate key. For instance, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity. Some relational database management systems (RDBMS) can enforce referential integrity, normally either by deleting the foreign key rows as well to maintain integrity, or by returning an error and not performing the delete. Which method is used may be determined by a referential integrity constraint defined in a data dictionary.

Via Referential integrity – Wikipedia, the free encyclopedia.

Foreign key

A Foreign Key is a field in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables.

For example, say we have two tables, a CUSTOMER table that includes all customer data, and an ORDER table that includes all customer orders. The intention here is that all orders must be associated with a customer that is already in the CUSTOMER table. To do this, we will place a foreign key in the ORDER table and have it relate to the primary key of the CUSTOMER table.

Foreign key – Wikipedia, the free encyclopedia.

Adding MySQL Cluster Data Nodes Online

The redistribution for NDBCLUSTER tables already existing before the new data nodes were added is not automatic, but can be accomplished using simple SQL statements in mysql or another MySQL client application. However, all data and indexes added to tables created after a new node group has been added are distributed automatically among all cluster data nodes, including those added as part of the new node group.

via MySQL :: MySQL Cluster :: 5.12.1 Adding MySQL Cluster Data Nodes Online: General Issues.