(Johan Andersson) Considering that you have the following hosts and MySQL Cluster deployed in the following ways: A: ndb_mgmd, ndbd , mysqld B: ndb_mgmd, ndbd , mysqld

(Arun Gupta) This Tip Of The Day (TOTD) shows how to create a simple Java EE 6 application that reads data from a MySQL database using JPA 2.0 and Servlet 3.0 and display the results. A more formal support of Java EE 6/Servlet 3.0 is coming but in the meanwhile the approach mentioned below will work

(Leo Hsu and Regina Obe) One of the most common questions people ask is Which tools work with PostgreSQL. In a sense the measure of a database’s maturity/popularity are the number of vendors willing to produce management and development tools for it. Luckily there are a lot of vendors producing tool

(Ronald Bradford) Long before there was the official Query Analyzer (QUAN), a component of MySQL Enterprise, SQL analysis was possible using MySQL Proxy.

(peter_laursen) This is the second and last article of a small series on reasons for the error message: “MySQL server has gone away”. The first appeared here describing that “if a client sends a SQL-statement longer than the server max_allowed_packet setting, the server will simply disconnect the cl

(Shlomi Noach) In some of my previous posts I’ve used a numbers table, like one holding values 1, 2, 3, …, 255. Such table can be used for string walking, joining with other tables, performing iterations.

(Octavia Andreea Anghel) A data access object (DAO) provides an abstract interface to a database—giving developers access to common database operations without them having to know the database schema details—essentially, data access object separate the business logic and data tiers of an application

(toby) Do you know if your production MySQL servers will come back up when restarted? A recent support episode illustrates a number of best practices. The task looked trivial: Update a production MySQL server (replication master) with a configuration tuned and tested on a development server. Clean s

(Peter Zaitsev) Couple of days ago I was looking for a way to improve update performance for the application and I was replacing single value UPDATE with multiple value REPLACE (though I also saw the same problem with INSERT ON DUPLICATE KEY UPDATE)

(Rob Gravelle) Normalization is almost universally applied to relational databases such as MySQL in order to optimize tables for general-purpose querying and to rid them of certain undesirable characteristics that could lead to a loss of data integrity. Doing so tends to promote better accuracy of q