MySQL

DBIx::Class::DeploymentHandler is Awesome

DBIx::Class::DeploymentHandler is a fairly young module. It’s a little raw at the edges and a wee bit terse in term of documentation. It’s also a complex thing and, trust me, it’ll takes more than a few minutes of playing with it to get your mind around how it works. But once you begin to understand what it can do, Whoa, that’s one seriously powerful beast, that module is. But don’t take my word for it, let me show you.

What Happens when InnoDB Fails to Start

Today I’ve spent some time (more than this issue was worth, actually) on a client’s system trying to find out why table was not accessible and failed. The error message suggested something went very wrong with .frm file and I already started thinking about restoring the table from backup, when I noticed that accessing any InnoDB table was producing same error. A quick check of the error log showed that when MySQL server was restarted some time ago InnoDB failed to initialize due to a memory issue.

Video: MySQL Cluster Overview by Bill Papp

At the December 2010 Boston MySQL User Group meeting a few days ago, Oracle/MySQL sales engineer Bill Papp gave a presentation on ‘An Overview of MySQL Cluster’. Slides are online at http://technocation.org/files/doc/2010_12MySQLClusterOverview.ppt The video is on YouTube at http://www.youtube.com/watch?v=-XLc8OA8UOY. Here is the description Bill gives of this presentation: Now, more than ever, databases have to scale linearly to…

MySQL 5.5 is GA!

Today it was announced that MySQL 5.5 is GA.  This is very exciting news; we have not had a GA announcement since MySQL 5.1 two years ago.  There are tons of new features, mostly performance enhancements, that I am looking forward to.  Here is why I am excited about MySQL 5.5: First and foremost:  the…

Zabbix Templates for MySQL

We recently had a client come to us, and ask us to improve their MySQL monitoring inZabbix. So, we did. The approach we took was to port the MySQL script from the superb mysql-cacti-templates project to work with Zabbix. This works out well, because Zabbix is like cacti and nagios combined, and, what we wound up getting, are some…

Video: Database Change Management by Jacob Nikom

At the November 2010 Boston User Group, Jacob Nikom presented his solution for database change management using MySQL. This system is designed to keep a repository of tables and data that an application needs to function. For example, an application might need at least one administrative user, or a table with a list of countries….

Page 33 of 85« First Page...10...3132333435...40...Last Page »