The last few nights I have been working on something very interesting: encrypted data types for PostgreSQL. The goal here is to introduce transparent data encryption for applications which need to protect “data at rest”, i.e. while the data is stored in the database within the file system. I didn’t find any such mechanism (pgcrypto only offers security primitives which can be used on the application side) so I wrote pgenctypes. Read more »

“… PostgresSQL nos ofrece la posibilidad de sincronizar dos servidores de base de datos mediante Replicación. Existen distintos tipos de replicación de servidores, en este caso, configuraremos un esquema Maestro-Esclavo, en el que mi servidor Maestro, recibe y ejecuta todas las transacciones y, además, actualiza a mi servidor Esclavo, que, únicamente, realiza consultas. Read more »

In last weeks OurSQL postcast (episode 65) Sheeri, Sarah and Jerry talked about making MySQL safe with SSL. Encryption always seems to be such a confusing subject. I think every database should be using SSL by default. So, I was wondering just how easily SSL could be setup.
Most existing examples I found setup SSL authentication and encryption. If you are handling PCI DSS or HIPAA data you must encrypt the data on the wire, but passwords are all you need to authenticate the application to the data source. Read more »

Unlike JBoss AS 6 there is no “$PROFILE/lib” present in JBoss AS 7 where we can place our JDBC Drivers in order to add/register the JDBC Driver. Also in JBoss AS 7 we don’t need to create a separate DataSource file as “*-ds.xml” file. Read more »

This guide is designed to help do the initial setup on a MySQL cluster in which multiple MySQL servers all serve the same content through the use of the replication function. We have successfully deployed this solution for multiple clients and it is a very good option for those needing a more powerful mysql solution. Carlos (theuruguayan) actually created this document so please direct any questions to carlos@totalserversolutions.com . Read more »

Oracle, ha publicado un documento en español, con los diferenciadores técnicos, de cada una de sus ediciones de base de datos, para la versión 11g. Read more »