MariaDB Traffic Simulator Tool

mariadbMySQL

I made a MariaDB Tuning course, and it's very important to test the system with real traffic and real data, simulate a Production server basically.

The data is easy to replicate, just a dump, or even replication for have the database updated. But how do you test your traffic for make statistics? You can't replicate your users and their consumption of the server's resources, can you?

Do you know any tool that I could use for simulating this traffic?

Best Answer

There are no 100% real workload replication tools for MySQL (at least 100% free)

All you could do is only simulate:

using HammerDB
a very interesting tool from Percona, Percona playback and related article
you can also look for Apache JMeter
you can sometimes enable the general log on MySQL server, and use it to prepare tests with JMeter (after manual preparation)

With Playback - You can not replay collisions as it was on real server With JMeter (and similar). You would need to define queries by yourself.

Depending from what you want to demonstrate it could be easy or hard to prepare a proper simulation.

Sometimes for proper problem simulation all you need is mysqlslap. Run 3-4 instances with different queries and you can simulate locks, deadlocks etc.

Related Solutions

Mysql – strategy for enabling a general query log on MySQL 5.0.95 with no restart

I do not think for v5.0.95 is it possible to enable general log without server restart, but as of MySQL 5.1.12, you can by executing this query, You can try this on v5.0.95 as well and see whether it works or not,

SET GLOBAL general_log = 'ON';

This method works on any platform and does not require a server restart.

Baron has written a script to enable and disable log without restart of server for v5.0 as mentioned below:

http://www.mysqlperformanceblog.com/2007/09/13/enablingdisabling-query-log-without-server-restart-in-mysql-50/

MySQL replication – ibdata1 huge

If you want to shrink ibdata1, so that it should only contain the metadata, You may try these steps

To shrink ibdata1 once and for all you must do the following:

MySQLDump all databases into a SQL text file (as bkp_all_db.sql)
Drop all databases (except mysql schema)
Stop MySQL /etc/init.d/mysql stop

Add the following lines to /etc/my.cnf

[mysqld]
innodb_file_per_table
innodb_flush_method=O_DIRECT
innodb_log_file_size=1G
innodb_buffer_pool_size=4G

Now remove ibdata1, so that there should only be the mysql schema in /var/lib/mysql

rm -f /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile

Start MySQL instance, This will recreate ibdata1, ib_logfile0 and ib_logfile1 at 1G each

service mysqld start
Reload bkp_all_db.sql into mysql (import). ibdata1 will grow but only contain table metadata

http://mysqlrockstar.blogspot.in/2014/07/mysql-ibdata1-file-shrink.html

Best Answer

Related Solutions

Mysql – strategy for enabling a general query log on MySQL 5.0.95 with no restart

MySQL replication – ibdata1 huge

Related Question