DBJ – Mult-master MySQL Improves Manageability

Multi-master MySQL, with the MMM management software brings a whole host of new features, and manageability to your MySQL deployments.   Run backups, alter tables, perform upgrades all without slowing down your production users.

Read more at Database Journal – Using Multi-master MySQL To Get A Leg Up On Database Performance

Tags: , , , , , ,

DBJ: Introduction to Multi-Master MySQL

This month on Database Journal we talk about multi-master MySQL using circular replication to achieve high availability.

Read more at DatabaseJournal – Intro to Multi-Master MySQL

Tags: , ,

iHeavy Insights 69 – Fewer Moving Parts

In this month’s newsletter we talk about the advantages that come from simplicity in design.  This holds true for extreme sports like sky diving or rock climbing, as much as it holds for user interface designs on smartphones like the iphone, or internet infrastructure and operations.

Read More – Newsletter 69 – Fewer Moving Parts

Tags: , , , ,

DBJ: More Maatkit

In this month’s article we discuss Maatkit again, following up on our previous article last month.  There are a whole host of backup and administrative tools including some to dump in parallel, search for tables, search for queries based on criteria and more.

Even More Maatkit at Database Journal

DBJ – Wonders of Maatkit for MySQL

If you’re new to the MySQL DBA role, you’ll be excited to learn about the Maatkit toolset.  It provides a whole host of valuable functionality and fills many of the DBAs day-to-day needs.

DatabaseJournal – Wonders of Maatkit

Tags: , , , ,

iHeavy Insights 67 – Golden Rule In Business

If you’ve ever worked with someone who is more on the abrasive side, you probably know how unpleasant it can make business.  The truth is when it comes to the people you work with everyday, it’s important to be a great person to work with.  This doesn’t mean not speaking your mind, but it means doing so in a way that doesn’t step on toes.  A pleasure doing business with you – carries more weight than we might often think.

Newsletter 67 – Golden Rule In Business

Tags: ,

DBJ – Exotic Storage Engines for MySQL

In our March DBJ article we talked about some of the storage engines to choose from with MySQL.  With it’s plugin storage engine architecture, you have a range of options.  In our April article we continue to discuss a further selection of storage engines, and what features they offer to the DBA and database architect.

Database Journal – Exotic Storage Engines

Tags: , , , ,

iHeavy Insights 66 – Needs & Wants

Customers and consultants often have wildly different views of a business solution.  Consultants may see the devil in the details, how all the gears line up, and what each piece does.  The customer very clearly sees their business needs.  The trick is for the consultant to be able to translate needs to wants, and articulate that solution in a way that expresses the value to the business.  All that, and without getting tripped up on complex jargon, and too much technical detail.

iHeavy Insights 66 – Needs and Wants

Tags: ,

Surveying MySQL’s Popular Storage Engines

In this month’s Database Journal piece we look at the spectrum of MySQL storage engines available, and examine what some of their strengths and weaknesses are.

View the article here: Survey of MySQL Storage Engines

Tags:

iHeavy Insights 65 – How Many Hats

What’s your strongest suit?  You may have heard the question before.  It’s a simple and seemingly innocuous question, however by labeling and simplifying our skillset, we subtly pigeonhole our expertise unnecessarily.   Perhaps a better question might be “How many hats can you wear?”, or “Are you a jack of all trades?”.

This month’s newsletter ponders this topic to present a different perspective on subject matter expertise.

iHeavy Insights 65 – How Many Hats?