DevOpsDays Toronto: Community, Collaboration and Supporting the change in IT

I recently attended DevOpsDays Toronto 2017, my first proper DevOpsDaysTO event.  I had the pleasure of attending and being able to immerse myself in this openly collaborative and supportive culture of IT professionals.  The variety of considerations expressed for delivering software features in a rapidly, frequently and reliable release focused manner was really intriguing….but not without its own complexities.… Read More »

Enterprise Ready InnoDB Clusters

Recently MySQL launched the General Availability of their Group Replication enhancements via the MySQL Shell and MySQL Router. Although these URLs just noted go to their respective documentation pages, these collectively are part of the InnoDB Cluster offering. The MySQL shell provides sophisticated provisioning, monitored insight and management of a Group Replication setup. When provisioned as such, you… Read More »

Group Replication GCS Troubleshooting

In the last post I shared the simple set of steps to configure a Group Replication setup using SQL commands, and a few in the configuration file too. Indeed, it can be simple.  But then there are times where there are more requirements and configurations need more attention. Maybe the OS environment we use for MySQL setups has never impacted us… Read More »

Binary Log Growth Handling in MySQL

So today we look at an aspect of capacity management or planning and how it relates to MySQL and its Logging.  For this blog I’m primarily going to look at MySQL’s binary logs. They have a tendency to grow, and will continue to if not held in check.  Happily, they tend to be easy to… Read More »