Backups – one of the most important things to take care of while managing databases. It is said there are two types of people – those who backup their data and those who will backup their data. In this blog post, we will discuss good practices around backups and show you how you can build a reliable

(Jean-François Gagné) In a previous post, I presented an Unexpected Memory Consumption for Bulk Index Creation in InnoDB. This was triggered by an increased innodb_sort_buffer_size and as stated in another post: “the sorting algorithm does not scale well with large sort buffers”. In this post, I w

(Francisco Tirado) In a previous post we explained how to connect to a MySQL server configured as a document store using the new MySQL Connector/Node.js. In this post we are going to explain how to create a schema, create a collection and add documents to the collection.

(shahriyar) This topic is about general usage for MySQL Shell and X-Plugin.

(Giuseppe Maxia) MySQL-Sandbox 3.1.11 introduces a new utility, different from anything I have put before in the MySQL Sandbox toolkit.

(Robert Eisele) There was a time when tag-clouds were the thing for website owners to fancy oneself. These clouds are mostly gone, but seen from the perspective of how to implement such a thing, one can learn quite a lot, especially with large amounts of links.

(Rob Gravelle) It’s been said that one of the drawbacks to normalization to the third form (3NF) is more cumbersome data extraction due to the greater number of tables. These require careful linking via JOIN clauses.

(Shinguz) When analysing MySQL configuration and status information at customers it is always interesting to see how the applications behave. This can partially be seen by the output of the SHOW GLOBAL STATUS command.

(Alex Slotnick) Adaptive Fault Detection is a patented, algorithm-based technology and one of the important central components of the VividCortex app . Unlike other monitoring methodologies — such as anomaly detection or threshold alerting — adaptive fault detection is designed to detect events that

(Francisco Tirado) In this post we are going to explain how to connect a Node.js application to a MySQL server using the new MySQL Connector/Node.js; needless to say that we will be using the MySQL server as a document store.