I encountered some issues with an application running on Java. I thought it would be fine if running on standard OpenJDK release available at CentOS repository since it is really easy to install with yum, but it wasn’t. The application does required JDK from Oracle release (which is lame).
So here what you should do when you [...]
The easiest way to perform benchmark on a MySQL server is by using sysbench. To install:
$ apt-get install sysbench
$ yum install sysbench Preparing Sysbench
If we have a MySQL server ready, let’s create a database for sysbench called sbtest.
mysql> CREATE SCHEMA sbtest;
It is better to [...]
I have been assigned a task to generate random data in JSON format. I do have a big data set ready in CSV (comma separated values) and would love to convert it to JSON just using BASH. You can copy following codes and save it as a executable script file.
#!/bin/bash # CSV to JSON [...]
I have been facing hard time to import a big dump file (25 GB in size to be exact). It could take hours to load data in so it could be worth to watch the progress of this import. Fortunately, Linux has always had a convenient way to do this. I just need to install [...]
I have a Magento data set which run on MySQL-wsrep with Galera. Galera has its known limitations, and one of it is:
DELETE operation is unsupported on tables without primary key. Also rows in tables without primary key may appear in different order on different nodes. Don’t use tables without primary key.
Basically, if you [...]
I have a server running on Debian 6 64bit installed with Apache and PHP5 using apt-get package manager. By default, it will configure DSO as the PHP handler (more details here). I need to convert it to serve PHP through FastCGI (mod_fcgid) to save memory usage. It turns to be that converting them [...]
Easiest way to install grsecurity. The good thing about it is only grsecurity provides protection against zero-day and other advanced threats that buys administrators valuable time while vulnerability fixes make their way out to distributions and production testing.
1. Go into repository directory:
$ cd /etc/yum.repos.d/ $ wget http://repos.coredumb.net/grsecurity/grsecurity.repo
2. Install grsecurity [...]
Here in this post, I am going to show you on how to import IMDb plain text data files available at this page into your MySQL database server. I was using this data set to perform various benchmark tests around a moderately-large database size. If you want to have a small MySQL database sample [...]
Your Linux box is incomplete if you do not have wget installed. It is a simple CLI based application used to download files from network. It support HTTP, HTTPS and FTP protocols as well as retrieval through HTTP proxies.
Download latest version of PHPmyAdmin from SourceForge.
You can just simply use the [...]
I encountered following error when trying to upgrade MySQL server in Ubuntu 12.04:
dpkg: error processing mysql-server-5.5 (–configure): subprocess installed post-installation script returned error exit status 1 No apport report written because MaxReports is reached already Setting up mysql-client (5.5.22-0ubuntu1) … dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 [...]
I am going to show you on how to install MariaDB Cluster (with Galera) in Ubuntu Precise (12.04) LTS 64bit. You need at least 3 hosts running together to form a reliable cluster.
maria1 – 192.168.10.101
maria2 – 192.168.10.102
maria3 – 192.168.10.103
In all hosts, this is my [...]
I have been facing following problem when executing Percona Xtrabackup in my CentOS 6.3 box:
xtrabackup_55 version 2.1.3 for Percona Server 5.5.16 Linux (x86_64) (revision id: 608) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: Target instance is assumed as followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group [...]
- SpaceX's Dragon successfully launched Friday, heads for the ISS on resupply ... - The Space Reporter 21 April 2014
- Ancient enigmatic carvings in danger of disappearing - Inquirer.net 20 April 2014
- Beijing 2014: China-only Kia K4 sedan breaks cover - ASEAN Automotive News 20 April 2014
- Honda unveils dancing humanoid Robot ASIMO - Delhi Daily News 20 April 2014
- New Volkswagen Coupe Concept Unveiled in Beijing - Indian Cars Bikes 20 April 2014