(Fernando Ipar and Martin Arrieta) While built-in replication has been a major cause for MySQL’s wide adoption, official tools to help DBAs manage replication topologies have typically been missing from the picture. The community has produced many good products to fill in this gap, but recently, Ora

(Leo Hsu and Regina Obe) I’m not a big proponent of schemaless designs, but they have their place. One particular place where I think they are useful is for archiving of data where even though the underlying table structure of the data you need to archive is changing, you want the archived record to

(Shlomi Noach) I’m experimenting with upgrading to MySQL 5.6 and am experiencing an unexplained increase in disk I/O utilization. After discussing this with several people I’m publishing in the hope that someone has an enlightenment on this.

(Tony Darnell) I have already written several posts on using mysqldump. This post will be a quick guide to using mysqldump to backup and restore your databases. And we will look at using the MySQL binary log (binlog) along with mysqldump for point-in-time recovery.

(Shlomi Noach) pt-query-digest, Anemometer or "Anemomaster" do a great job of analysing your queries and giving you visibility into what’s going on with your MySQL servers. However, the place where the query digests are written is just some MySQL tables on some server. Do you have monitoring/alerts

(Michael Paquier) Among the many things to say about logical replication features added in PostgreSQL 9.4, REPLICA IDENTITY is a new table-level parameter that can be used to control the information written to WAL to identify tuple data that is being deleted or updated (an update being a succession

(Tony Darnell) In MySQL, partitioning is a way to separate the data in one table into smaller “sub-tables” for better query performance and data management.

(Rob Gravelle) In my Importing XML Data into MySQL Tables Using a Stored Procedure article, I outlined some ways to work around MySQL’s restrictions on stored procedures to import XML data into your MySQL database tables.

(Jørgen Løland) This is “A new dimension to MySQL query optimizations – part 2″. If you didn’t read part 1 already I suggest you skim through it before reading on.

(Raghavendra Rao) Yes, truly possible and handled smartly by PostgreSQL. To demo this, first I need to take after the standard technique of Point in Time Recovery in PostgreSQL. Various Books/Articles/Blogs demoed extremely well by extraordinary authors, hence am not going into details of how to do