Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!
Gregory Steulet is Senior Consultant and Delivery Manager at dbi services. He is specialized in MySQL, Oracle technologies and security solutions (Oracle Database Vault). His expertise also includes open source solutions such as Data Replication Block Device (DRBD) Gregory Steulet is „Oracle Certified Professional“, „ MySQL Cluster 5.1 Certified Professional “, and „Avaloq Certified Professional“.
During one of my last MySQL mission, I encountered a "security error" with mysqldump. The mission was about migrating a MySQL database from one box to another MySQL version and from Windows to Linux with different users. In order to do that, I used mysqldump. During the import of the data, I got the following warning:
As you probably know, Face.com has been acquired by Facebook at the end of May 2012. face.com is operating the largest face recognition platform on the cloud. But what is the aim of this acquisition and which functionalities are provided by face.com ?
The Database Vault solution allows to create rules that manage access to database. Among these rules there is what is called in Database Vault “Rule Sets”. These logic components are written as PL/SQL functions to return Boolean results. If rule expressions do not match the user context, the access is refused and a specific message can be configured in order to warn the user that he is not authorized to access this specific object. These expressions can be for instance related to the client IP address, the session username, the time or date and many other things.
During one of my recent missions I had the opportunity to install Red Hat 6.1 on a ESX Virtual Machine. In the installation process, I got a strange message: "unable to read group information from repositories". If you have also encountered such a problem this posting may help you.
A few days ago, I was at a customer that encountered some problems trying to restore his MySQL database. Indeed he got the following error message trying to restore his xwiki database:
mysql@dba-ecm-srv11:/ [mysqld1] mq < /MyBackupFile.sql
ERROR 2006 (HY000) at line 283: MySQL server has gone away
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.
After my last post - Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons! - some of you asked me for firefox search add-ons for Oracle Fusion Middleware (http://download.oracle.com/docs/cd/E17904_01/index.htm). This add-on will provide you a fast a reliable way to find easily what you are looking for in the official Oracle Fusion and Grid Control documentation.
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.
Are you often trying to find functionalities or error codes in Oracle 9iR2, 10gR2, 11gR2, or MySQL documentation? Of course, each time you are looking for this documentation you are finding unofficial documentation which is never corresponding to the version you are looking for...