Category: Databases

Configure ODBC for MySQL on CentOS

Migrate Users from MySQL to MySQL

We have already installed ODBC drivers for Oracle and PostgreSQL in prior articles.  In this article, we will install ODBC drivers on CentOS to connect us to an MySQL database.  The general idea is similar to the steps we followed…

Using the MySQL Binary Log

MySQL Point in Time Recovery

Enabling and managing binary logging will make it more likely that you can recover your database to a specific point in time.  These point in time recoveries require proper backups as well as having your MySQL server instance configure for…

PostgreSQL Replication

Postgresql

PostgreSQL Replication Options So, with all of the other articles that I have written about Postgresql, I figured that it was inevitable that we finally get one written about replication.  What makes an article about Postgresql replication difficult is that…

Upgrade Postgresql 9.2 to 9.3

Postgresql

If you installed Postgres using the methodology demonstrated in our earlier article:  CentOS Install Postgres 9.3, then at some point you may need to upgrade your Postgresql instance.  For this article on upgrading postgresql, I used a 9.2 instance that…

Monitor Postgresql with Nagios

Monitor Postgresql Connections with Nagios

The other day, we had an issue with one of our PostgreSQL databases where one of our applications wasn’t closing its unused connections. We tripled the max_connections and it used all of those up too. While I was monitoring the…

10 Helpful Postgresql Commands

Postgresql

Here are some more helpful postgresql commands that can help your out in your first few weeks of using Postgresql.  Finding the current, time, which database you are in, the size of a database or a table, the database ipaddress…

CentOS Install Postgres 9.3

Postgresql

Postgresql is a great SQL database with lots of great features that you can install for free with just a few quick tasks.  First, we need to get the yum repo from postgresql website, use yum to install it and…

Linux Snapshot Backups

Creating Linux Snapshot Backups

Uptime vs Database Backups Backups of your database can be an enemy to your system uptime.  Doing a filesystem dump of your database tablespace files will require that it occur while your database is down so that you don’t have…

MySQL Master / Slave Replication

MySQL_Replication

Master Slave MySQL Replication Summary Master / Slave replication in MySQL is a great way to store an exact replica of your database on another machine in another location as part of a disaster recovery plan.  Before setting up Master…