When you have started to work heavily with MySQL servers, and you need to create, install, configure and destroy MySQL instances, MySQL Sandbox is a great tool to automate those tasks. MySQL Sandbox allows us to deploy a MySQL test environment within seconds with simple commands.
So following is what I would do to install […]
Once Percona Xtrabackup is installed, you can create a full backup with parallel compression as below:
$ innobackupex –stream=xbstream –parallel=4 –compress –compress-threads=2 /var/lib/mysql > /root/backup/backup.xbstream
Once completed, you should see a backup file has been created with .xbstream extension:
$ du -sh /root/backup/backup.xbstream 106M backup.xbstream
1. Extract the file using xbstream -x command […]
I have been assigned a task to assist a client to get some idea on his database usage in MySQL Cluster before migrating them to Galera cluster. Galera scales well for reads but not for writes. So the first thing you need to do is to calculate the reads/writes ratio:
SELECT @total_com := SUM(IF(variable_name IN […]
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-22.214.171.124-1.el6.x86_64 –> Processing Dependency: libcrypto.so.10(libcrypto.so.10)(64bit) for package: socat-126.96.36.199-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 […]
- Facebook outage 'was self-inflicted' - Irish Examiner 28 January 2015
- Apple reports biggest quarterly profit in history - Deutsche Welle 28 January 2015
- Honeymoon Is Ending for Microsoft's Nadella - Wall Street Journal 28 January 2015
- Yahoo's Mayer saves her job with Alibaba spin - CNBC 28 January 2015
- Apple Watch Will Ship in April - Bloomberg 28 January 2015