Home » Database

Database

MySQL Backup and Restore

MySQL

Tutorial for MySQL backup and restore using command line for those of you who are doing it for the first time or have forgotten some parameter. First of all don’t forget that you need to have permissions to connect with the user you are going to use from the host you are executing this command. If it is from the ...

Read More »

MySQL Tuning Scripts

MySQL

MySQL tuning is essential if you are running high volume websites that run on MySQL. You will need this two scripts to help your MySQL tuning. I’m running a lot of high volume WordPress websites and apart from getting the advantages from caching with APC or memcached I’m tuning my MySQL server from time to time. For that purpose I’m ...

Read More »

OpenERP Backup and Point-in-time Recovery

openerp7 barman

OpenERP backup is one of the main things to do when installing OpenERP on a production server. But for many of us, simple daily backup won’t do the job. We need to utilize PostgreSQL Point-in-time Recovery to reduce the downtime when disasterĀ happens. PostgreSQL server records all transaction like insert, update or delete and write it into a file called write-ahead ...

Read More »

Oracle Instant Client and PHP OCI8 on Debian Squeeze

PHP OCI8

Because there is no deb package for PHP OCI8 for Debian, here is a simple tutorial how to install Oracle Instant Client and use PHP OCI8 on Debian Squeeze. Install dependencies and required packages This will install Apache with PHP5 support and all required packages to configure OCI8. aptitude install php-pear php5-dev build-essential unzip libaio1 Download the software from Oracle ...

Read More »

skip-name-resolve to speed up MySQL and avoid problems

MySQL

MySQL Reverse DNS took us all day to debug and before reinstalling MySQL on another server guy who had this problem told us the solution: skip-name-resolve skip-name-resolve Problem After searching the net I’ve found that by default MySQL grants authentication on users based on IP address or hostnames. When there is a connection from a particular host, MySQL does a ...

Read More »

MySQL Full-Text Search with Multiple words

MySQL

Few weeks ago i had a project where i needed to search a large database and provide results based on their relevance. The answer was MySQL Full-Text Search. Normaly i have started coding and used the LIKE finction in MySQL to get the results and started testing on a small temporary database that i’ve created. After some part of the ...

Read More »