'Open Source' Tag

  • Introducing Orchestrator: manage and visualize your MySQL replication topologies and get home for dinner

    June 9, 2014

    I'm happy to announce the availability of Outbrain's Orchestrator: MySQL replication management & visualization tool. Orchestrator reads your replication topologies (give it one server - be it master or slave - in each topology, and it will reveal the rest). It keeps a state of this topology. It can continuously poll your servers to get […]

  • "Anemomaster": DML visibility. Your must-do for tomorrow

    April 18, 2014

    Here's our take of master DML query monitoring at Outbrain (presented April 2014). It took a half-day to code, implement, automate and deploy, and within the first hour of work we managed to catch multiple ill-doing services and scripts. You might want to try this out for yourself. What's this about? What queries do you […]

  • Speaking at Percona Live: common_schema, MySQL DevOps

    March 10, 2014

    In less than a month I'll be giving these two talks at Percona Live: common_schema: DBA's framework for MySQL If you are still unfamiliar with common_schema, this will make for a good introduction. I'll give you multiple reasons why you would want to use it, and how it would come to immediate use at your […]

  • 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 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 […]

  • common_schema 2.2: better QueryScript isolation & cleanup; TokuDB; table_rotate, split params

    August 13, 2013

    common_schema 2.2 is released. This is shortly after the 2.1 release; it was only meant as bug fixes release but some interesting things came up, leading to new functionality. Highlights of the 2.2 release: Better QueryScript isolation & cleanup: isolation improved across replication topology, cleanup done even on error Added TokuDB related views split with […]

  • Tool of the day: q

    August 8, 2013

    If you work with command line and know your SQL, q is a great tool to use: q allows you to query your text files or standard input with SQL. You can: SELECT c1, COUNT(*) FROM /home/shlomi/tmp/my_file.csv GROUP BY c1 And you can: SELECT all.c2 FROM /tmp/all_engines.txt AS all LEFT JOIN /tmp/innodb_engines.txt AS inno USING […]

  • common_schema roadmap thoughts

    July 22, 2013

    I'm happy with common_schema; it is in fact a tool I use myself on an almost daily basis. I'm also happy to see that it gains traction; which is why I'm exposing a little bit of my thoughts on general future development. I'd love to get feedback. Supported versions At this moment, common_schema supports MySQL […]

  • common_schema 2.1 released: advanced & improved split(), persistent script tables, more schema analysis, and (ahem) charts!

    July 17, 2013

    common_schema 2.1 is released! common_schema is your free & open source companion schema within your MySQL server, providing with a function library, scripting capabilities, powerful routines and ready-to-apply information and recommendations. New and noteworthy in version 2.1: Better QueryScript's split() functionality Persistent tables for QueryScript: no long held temporary tables Index creation analysis, further range […]

  • mycheckpoint revision 231 released

    May 23, 2013

    A new release for mycheckpoint: lightweight, SQL oriented MySQL monitoring solution. If you're unfamiliar with mycheckpoint, well, the one minute sales pitch is: it's a free and open source monitoring tool for MySQL, which is extremely easy to install and execute, and which includes custom queries, alerts (via emails), and out of the box HTTP […]

 
Powered by Wordpress and MySQL. Theme by openark.org