Blog

Having just come back from PuppetConf 2014 in the San Francisco last week, there have been a lot of new developments. Some of the most significant changes since Puppet was started all the way 10 years back have been announced.

pt-query-digest is a tool available from Percona for analysis of MySQL queries from slow log, general log and binary log files. It can also analyze queries from mysql processlist and tcpdump mysql data. It is one of the best tools for slow query analysis on mysql server and can help you to improve mysql performance and efficiency.

pt-stalk tool collects MySQL diagnostic data for further analysis to resolve intermittent issues.

Disclaimer: Obviously I'm not entirely unbiased as we're one of 4 worldwide linux foundation training partners, and if you want to get trained up for this certification we're one of the places you can go.

If we look in the news since last 8 months or so, we can see that the technology scene is moving towards the cloud. The terms public cloud, private cloud, and hybrid cloud usually crops up and vendors comes up with all sorts of solutions/products for us to use/dissect/troll/shoot.

Anemometer is a MySQL slow query monitoring tool. It's used to analyze/visualize slow query log, collected from MySQL instance to identify the problematic queries. Also, makes it easier to figure out what to optimize and how to track performance over time.

Required:

Percona XtraDB Cluster (PXC) is a high availability and high scalability, solution for MySQL clustering. Percona Server, Percona Xtrabackup and Galera library for high availability integrated together as PXC. It provides synchronous, multi-master, and parallel replication. All the nodes of this cluster are ready to serve read/write request simultaneously.

 

Vagrant is an open source tool for building a complete virtual development environment. Very often, a test environment is required for testing the latest release and new tools. Also, it reduces the time spent in re-building your OS. By default, vagrant uses virtualbox for managing the Virtualization. Vagrant acts as the central configuration for managing/deploying multiple reproducible virtual environments with the same configuration.

Installing Virtualbox:

And I'm back!! It has been a long 3 months for me. For those who is not aware, I've been in the UAE working on-site for a client project. It is a very challenging project for a *nix Systems Administrator like me because the project was to automate a large number of Windows applications for a client. Windows! The first thing that came into my mind was the horror of using Windows but at the same time I'm rather excited because it is an uncharted domain for both me and OlinData as we've never work with Puppet on Windows before.

Pages

Subscribe to Blog