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.
In this post I’ll explain how encrypt mysql connections using SSL certificates between mysql client and server (not applications). By default mysql are not used encryption, to activate it you only need to compile with SSL option.
A few days ago, I installed Ubuntu 12.04, but when I launch VMware Workstation 8.0.2 an error appear:
Occasionally we need to kill a long running Oracle import jobs ,we do it using kill -9 the job finish but this kill doesn’t completely kill the job and locks up the underlying db objects, increasing the tablespace for the user that ran the job. To resolve this, you need to run the impdp utility and kill the […]
Ok, after explain how install and configurate drbd and vmware stonith, it’s the moment to start a new project mount a MySQL cluster. The Concept The concept of an active/passive fail-over Cluster is the following: Two servers (nodes). They communicate over a cluster software (Heartbeat, Corosync, OpenAIS) They are running on DRBD failover storage system. MySQL is only running in MASTER […]
In this post I’ll explain how control a Weblogic Server and Application from command line with simple task examples: