I have been working with Amazon Redshift lately and I need to export some huge tables (hundred millions of rows) to load them into Redshift cluster. Since Redshift supports parallel bulk loading of data files (CSV, TSV, Json), I took advantage of this feature by splitting the MySQL CSV data files before upload them to [...]
Lately, I have been spending my time doing research on developing a Puppet module. As you might know, Puppet is an orchestration tool used by many sysadmins to deploy and configure servers without hassle on repeating the same installation commands over and over again.
With Puppet you just simply:
Install Puppet master Define node configuration [...]
Galera Cluster (MySQL from Codership, Percona XtraDB Cluster, MariaDB Galera Cluster) generates a GRA log files if it fails to apply the writeset on the target node. This files exists in the MySQL data directory. You can get an overview of the file (if exist) by listing your MySQL data directory (in my case, the data [...]
I stumbled upon one error when installing Percona Server and socat via yum repository with following error:
–> Processing Dependency: libssl.so.10(libssl.so.10)(64bit) for package: socat-220.127.116.11-1.el6.x86_64 –> Processing Dependency: libcrypto.so.10(libcrypto.so.10)(64bit) for package: socat-18.104.22.168-1.el6.x86_64
It turns out that:
“Red Hat upgraded the version of OpenSSL in EL6 from 1.0.0 to 1.0.1 during the 6.4-6.5 cycle, in order to [...]
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 [...]
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 [...]
- MySQL: Export Table to Splitted CSV using Stored Procedure
- Install Puppet on CentOS, Redhat, Ubuntu, Debian
- Galera Cluster – Simpler way to view GRA file content
- Percona Server Installation Error – libssl.so.10 and libcrypto.so.10
- Sysbench 0.5 + Ubuntu 14.04 (Trusty) + Percona Server or XtraDB Cluster
- Toyota Confirms Sale Of Tesla Shares: Media Reports - RTT News 25 October 2014
- HP seeks to sell part of H3C Technologies networking subsidiary - The Malay Mail Online 25 October 2014
- Microsoft drops Nokia name from Lumia smartphones, new devices will be ... - IBNLive 25 October 2014
- Porsche Macan – the real sports utility vehicle - The Malay Mail Online 25 October 2014
- 1000hp-plus LaFerrari XX to debut in December? - The Malay Mail Online 25 October 2014