Oct 302014
 

The LEMP stack is an increasingly popular web service stack, powering mission-critical web services in many production environments. As the name implies, the LEMP stack is composed of Linux, nginx, MariaDB/MySQL and PHP. nginx is a high performance and lightweight replacement of slow and hard-to-scale Apache HTTP server used in the traditional LAMP stack. MariaDB is a community-driven fork of MySQL, with more features and better performance. PHP, a server-side language for generating dynamic content, is processed by PHP-FPM, an enhanced implementation of PHP FastCGI.
In this tutorial, I demonstrate how to set up the LEMP stack on CentOS platforms. I target both CentOS 6 and CentOS 7 platforms, and point out differences where necessary.

Continuar… »

Oct 302014
 

One of the distinguishing features of Linux is that, under normal circumstances, you should be able to know what is happening and has happened on your system by analyzing one or more system logs. Indeed, system logs are the first resource a system administrator tends to look to while troubleshooting system or application issues. In this article, we will focus on the Apache access log files generated by Apache HTTP web server. We will explore an alternative way of analyzing Apache access logs using asql, an open-source tool that allows one to run SQL queries against the logs in order to view the same information in a more friendly format.

Continuar… »

Oct 222014
 

I see that some people wonder if Oracle SQL Developer can be used with PostgreSQL. I wrote a blog post to show how you can configure Oracle SQL Developer to connect Microsoft SQL Server and MySQL. You can use the same method to configure SQL Developer for PostgreSQL. First we need to download a compatible JDBC driver from PostgreSQL site. Latest version of SQL Developer uses JDK 1.7, so we can download the JDBC41 Postgresql Driver:

Continuar… »

Aug 112014
 

Introducción.
En la actualidad las empresas tienden a almacenar cada vez más información dentro de sus bases de datos.
Como administradores de bases de datos, siempre hemos tenido el reto de tratar de almacenar la mayor cantidad de información que las empresas necesitan y al mismo tiempo optimizar el espacio consumido, dentro de las bases de datos, para poder reducir costos de infraestructura.
Muchos de nosotros hemos tenido que lidiar con bases de datos de 1TB, 10TB, 70TB, etc.
Con bases de datos tan grandes se hace muy difícil la administración del espacio, por lo que es necesario recurrir a la estrategia ILM.

Continuar… »

Aug 052014
 

Simplificación de la instalación de Oracle Database 12c u 11g en Oracle Linux 6 mediante la instalación del paquete RPM oracle-rdbms-server-12cR1-preinstall o oracle-rdbms-server-11gR2-preinstall, que ejecuta de forma automática varias tareas como instalar paquetes de software requeridos, resolver dependencias de paquetes y modificar parámetros del kernel.

Continuar… »

Jul 292014
 

Talvez você já tenha percebido que a ferramenta padrão para acesso ao PostgreSQL é o psql, um utilitário de linha de comando, aparentemente simples, porém, cheio de recursos interessantes.
Vale a pena conhecê-la, pois você nunca sabe quando se encontrará numa situação em que não tem a possibilidade de usar ferramentas gráficas para acesso ao PostgreSQL.

Continuar… »