Initially, DBAppender for Log4j was introduced in version 1.3 of Log4j, but this version was ABANDONED by Apache team. DBAppender is very useful when we want to send our log on a JNDI resource and not on standard JDBC or file. If you need just logging in a database for your application, then you should use JDBCAppender. If you want to log on a JNDI or Database Connection Pool the DBAppender is for you. In this post I will show you how to get, compile and quick test the DBAppender.

Share …

We are living interesting times … MySQL was first purchased by SUN and now SUN was purchased by ORACLE. I don’t know what future will reserve for MySQL, but in this moment it seems MySQL is coming very very close to PostgreSQL. We are NOT talking about MySQL with MyISAM, we are talking about MySQL with InnoDB, because I’m directly interested in a set of properties what PostgreSQL already have them built-in and MySQL achieve them through InnoDB (and the new Maria Data plugin). This properties are Atomicity, Consistency, Isolation, Durability = ACID, in other words, very stable, good integrity and crash proof database. Why an ACID database? Sometimes we are more interested in ACID for our data than raw speed. For example do you keep your savings to a bank who is running a NON ACID database? I think you understand my concern.

We will not discuss who is better or who is not, we just try to provide you a simple how-to to migrate from MySQL to Postgres or from Postgres to Mysql. On internet are several documents about that, but I will try to add new fresh informations from my experience with that. The differences between this Postgres and MySQL are starting from the concept of this two platforms. For example Postgres follow more closer the ANSI SQL standard than MySQL, the method of administration is totally different between them, Mysql …

It happens from time to time to forget some passwords if I’m not using them very very often. Recently I forgot the root password on a MySQL database from an external client. Recovering the password was not such a big deal, but I will explain how I do that for the newbies or anybody who need to know that. To do that you will need to stop your MySQL Database so if you are in a production environment then it will be better to schedule a downtime window. The process …

Always when we talk about MySQL replication we talk about high-availability (HA). Why we choose Mysql Replication and not Mysql Clustering in a high-availability environment? Because Mysql Cluster have some limitations on his NDB storage system and probably we want to use INNODB (ACID compliant storage system) and foreign keys.
What is Replication ? Is a Database syncronization between two (or more) MySQLnodes.
I will start explain you in this step by step tutorial how to do a master slave configuration between 2 nodes.

Share this post

…