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 [...]
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 [...]
- The Miracle Machine: Gadget takes leaf out of Jesus's book to turn water into wine - Express.co.uk 8 March 2014
- Xbox One makes hot debut as console war revs up - New Straits Times 8 March 2014
- Students find new spider species - The Star Online 7 March 2014
- 20000km undersea cable to link Singapore to Europe - CNET 7 March 2014
- T. gurneyi dinosaur was largest predator in Europe 150M years ago - iTWire 7 March 2014