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 [...]
MySQL Cluster is different compare to normal MySQL server. It has 3 roles:
management data SQL or API
Data node will required a lot of memory utilization. It is recommended for these nodes to not share any workload with SQL or management nodes as it would end up with resources exhaustion. So we will setup [...]
Nagios is the most popular open-source infrastructure monitoring tools. Nagios offers monitoring and alerting for servers, switches, applications, and services. It alerts users when things go wrong and alerts them again when the problem has been resolved.
I have created a script to install Nagios and Nagious plugin in RHEL/CentOS:
#!/bin/bash # Install nagios and [...]
In this post I am going to deploy a MongoDB sharded cluster. MongoDB is an open-source NoSQL, document-oriented database designed for ease of development and scaling. I am going to use 3 servers, and all the /etc/hosts definition would be as below:
192.168.0.41 mongo1 mongo1.cluster.local 192.168.0.42 mongo2 mongo2.cluster.local 192.168.0.43 [...]
- Xbox One makes hot debut as console war revs up - New Straits Times 8 December 2013
- Scientists discover undersea freshwater - The Nation 8 December 2013
- The iWallet Is Coming - Forbes 8 December 2013
- In a Scoreboard of Words, a Cultural Guide - New York Times 7 December 2013
- Lamborghini Gallardo successor previewed by rendering - INAUTONEWS 7 December 2013