Long time no write a new post, I’ve been busy with new projects. In one of them a new callenge appeared…. The infraestructure consisted in two VPS hosted in different datacenters without private comunication, and with the necesity to configure a secure replication for Mysql and MongoDB. The best solution that came to my head […]
Welcome to another Sysadmin & DBA Tips, in this post I’ll explain how change the hostname of your cloned Oracle 11.2 VMs thats running on ASM with Oracle Restart.
Greeting to all readers, the first thing is to apologize for not write time ago but I have been studying the LPIC-2 Certification ;-). In this article I’ll explain how mount a Mysql Multi-Master replication, this system consist in two databases running in separate servers, the production machine, with read/write access, and the read-only CDR […]
In this post I’ll explain how install IBM System Director with Oracle remote database. For everybody that don’t know what is IBM System Director, here the official IBM description: What’s this? IBM Systems Director® is the platform management backbone to achieve Smarter Computing. An integral component of the IBM Smarter Systems portfolio, IBM Systems Director […]
In this post I’ll explain how managed the Transportable Tablespace Oracle utility, basically the method consist in copy one or more tablespace from a source database and plug it in to another Oracle database.
In this post I’ll explain how using the LogMiner tool to Analyze Redo LogFiles, this tool extract the information from Redo Log’s and we can see the sql sentence that have changed data in the DataBase. It is convenient when we need to know more information about sentences in a specific point in time, like who […]
Hi, after install and & Configure Mysql Cluster is the moment to run a benchmark and see how respond Mysql Server. To implement this task I’ll use the dbt2 tool, in the 0.40 version and the dbttools to generate the reports. I use the dbt2 and not the dbt5 because it doesn’t support mysql testing.
After install the Mysql Cluster we only have one pending thing, mount a CDR server in read-only mode that will replicate the information from the primary database. And This is one possible application:
If we need to recover a scheme which default LANG is WE8ISO8859P1 and our database is AL32UTF8, the import process crash because the special characters during the conversion pass from one byte to two:
In previous posts I explained how enable Mysql Server for support SSL connections, now I’ll explain how configure a Tomcat application for using Mysql encrypt connections.