MySQL

Pythian Q1 2011 Speaking: Find us at RMOUG, Hotsos

Pythian will be at RMOUG in full force. Look for Alex Gorbachev, Kellyn Pedersen & Don Seiler. Be sure to stop by our table (#10), say hi to us & our friends from the OakTable Network, and enter our draw to win an Amazon Kindle, and software provided by Cary Millsap (MR-Trace, MR-Tools & Method-R Profiler) among a few other surprises. Pythian is agressively hiring top DBA talent. If this is you, register on our Career Center, or request a time for a short intro chat with Pythian. Alex, Kellyn or Don will be more than happy to give you the inside scoop on the company & share why they love working for Pythian.

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…

Page 32 of 84« First...1020...3031323334...405060...Last »