(Hans-Juergen Schoenig) In this posting I would like to describe some important aspects of PostgreSQL sequences. In our daily work we have noticed that some people are not fully aware of those implications described in this section.

(Miguel Angel Nieto) We receive this question about the ibdata1 file in MySQL very often in Percona Support.

(Shivji Kumar jha) In the previous post, we had a look at the Performance Schema tables to monitor MySQL replication. We discussed why these were needed, what advantages they have to offer and what each table stands for.

(Narayanan Venkateswaran) Enterprises often start with a single server setup.

(Mats Kindahl) As you saw on the keynote, we are introducing an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. It should be noted that this is a very early alpha and that it at this point is not ready for production use.

(Rohit Kalhans) MySQL 5.7.2 features enhanced Multi-threaded slave which can be used to apply transactions in parallel even within a single database. Internal details of its working can be found in an earlier post. In this post we will see how we can configure our replication slave to use this enha

(Shinguz) In MySQL we have the typical behaviour that we open and close connections very often and rapidly. So we have very short-living connections to the server. This can lead in extreme cases to the situation that the maximum number of TCP ports are exhausted.

(Rohit Kalhans) Re-applying binary logs generated from highly concurrent master on the slave has always been an area of focus. It is important for various reasons. First, in real-time systems, it becomes extremely important for the slave to keep up with the master.

(Morgan Tocker) As the result of a number of improvements to default values, MySQL 5.6 requires far less configuration than previous versions of MySQL. Having said that, I wanted to write about the settings that you may need to change.

(Shlomi Noach) audit_login is a simple MySQL login auditing plugin, logging any login or login attempt to log file in JSON format.