Starting with MySQL 5.5 it is possible to configure semi-synchronous replication. As you probably know, MySQL replication is asynchronous by default. Asynchronous replication means that events/transactions applied on one server are not immediately applied on the other one.

Ayant rencontré récemment des problèmes de blocs corrompus sur des bases Oracle en version Oracle 10g et Oracle 11g, des différences notables sont apparues notamment au niveau de la vue v$database_block_corruption. Je vous livre dans ce post le résultat de mes tests.

Last week, I attended the Microsoft TechDays for the first time. The Swiss 2011 "edition" took place in Bern. For me this is really a new challenge because I have never worked deeply with the Microsoft database platform "SQL Server".

During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the databases restore on the secondary cluster node.

In this article, we will explain how to avoid it before encountering the problem.

Last week, I was not able to complete a backup because of the ORA-19566 error: "exceeded limit of 0 corrupt blocks". Here is what you can do to fix it.

Nowadays, MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is not available anymore. In order to increase the service availability, it is mandatory to have a monitoring solution. Regardless of if you are using MySQL Server, MySQL replication or cluster, the Oracle/MySQL monitoring solution is called MySQL Enterprise Monitor.

I was upgrading Netbackup yesterday to version 7.0.1 and faced a quite "funny" issue with the OpsCenter. The installation failed on pre-requirements checks saying that no space was available. Nothing strange at this point...except that we still had about 79GB free space!

Perhaps you know this situation: A developper or application owner quickly needs a test database to test new code or to validate changed code before implementing it. Sounds like a lot of work, but if you have Data Guard 11g, you can simply use the command "CONVERT TO SNAPSHOT STANDBY".

NetBackup provides a pretty nice Web Interface, OpsCenter, to monitor and check the basic configuration. However after working a while with it, you may find that some information can be quit boring to find out.

Good news! Symantec didn't forget that in Unix World some peoples still like working in command lines...