• Introducing audit_login: simple MySQL login logfile based auditing

    September 17, 2013

    audit_login is a simple MySQL login auditing plugin, logging any login or login attempt to log file in JSON format. It seems that audit plugins are all the rage lately... We've developed out simple plugin a month ago as part of our database securing efforts; by auditing any login or login attempt we could either […]

  • Converting an OLAP database to TokuDB, part 2: the process of migration

    September 9, 2013

    This is a second in a series of posts describing our experience in migrating a large DWH server to TokuDB. This post discusses the process of migration itself. As a quick recap (read part 1 here), we have a 2TB compressed InnoDB (4TB uncompressed) based DWH server. Space is running low, and we're looking at […]

  • Three wishes for a new year

    September 4, 2013

    Another new year by Jewish calendar. What do I wish for the following year? World peace Good health to all Get auto-vacuuming, disk space reclaiming InnoDB tablespaces No one likes rebuilding huge InnoDB tables. Rebuilds take time, effort, system resources and loss of sleep. I recently rebuilt a 300GB table to realize it reduced to […]

  • Converting an OLAP database to TokuDB, part 1

    September 3, 2013

    This is the first in a series of posts describing my impressions of converting a large OLAP server to TokuDB. There's a lot to tell, and the experiment is not yet complete, so this is an ongoing blogging. In this post I will describe the case at hand and out initial reasons for looking at […]

Powered by Wordpress and MySQL. Theme by openark.org