I need to perform benchmarks on Percona XtraDB Cluster and Percona Server directly from my Ubuntu 14.04 box. Sysbench 0.5 is the latest stable to date and it supports benchmarking Galera cluster. If you are running on Sysbench 0.4, you would most likely encounter one of following errors if you are running it against a Galera cluster with high value [...]
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 [...]
- Apple's new encryption to lock out government - Channel News Asia 18 September 2014
- Amazon is now a gadget company - Chicago Tribune 18 September 2014
- 2014 Honda Civic Review: Still A Head Turner - AutooMobile.com 18 September 2014
- ISN Not A 'Massage Centre' - Khairy - Bernama 18 September 2014
- As new iPhone arrives, buyers have more pricing options than ever [Star Tribune ... - Businessweek 18 September 2014