MySQL

Securing MySQL on Linux Systems

MySQL is one of the most, if not the most, popular relational databases chosen by internet based startups in the last decade. Although it is a very robust platform and offers many of the necessary features to support the database needs of today’s internet giants, it also suffers from some security issues that must be…

Log Buffer #271, A Carnival of the Vanities for DBAs

They say that “April showers bring May flowers”. Basically, nature brings different things in different colors aimed at improvement. That is also true for the blogging world. This Log Buffer Edition brings out different blog posts to improve the Oracle, SQL Server, and MySQL worlds, so enjoy!

Hardware Component Failures – Survey Results

When preparing for the the IOUG Collaborate 12’s deep dive on deploying Oracle Databases for High Availability, I wanted to provide some feedback on which hardware components are failing most and least frequently. I believe I have a reasonably good idea of the answer, but I thought that providing some more objective data would be better. I couldn’t find results from a more scientific research, so I decided to organize a poll. This blog post shows the results, which I promised to share with several groups.

Log Buffer #270, A Carnival of the Vanities for DBAs

As Summer begins in many parts of the world, not only is nature waking up, but many bloggers are also coming out of hiatus and the database blogsphere is seeing new sensational activity. This Log Buffer Edition includes blogging tidbits from Oracle, SQL Server, and MySQL. Enjoy!

Collaborate 2012 as Seen by a MySQL DBA

I spent last week at Collaborate 2012 in Las Vegas, and it was a really great experience in many ways. I am a MySQL DBA and have been working with MySQL for most of my career, so Collaborate didn’t seem like an obvious choice. It turned out that I had so much to learn from Oracle professionals and the Oracle community that could be applied in the MySQL world. For me, an indication of a good conference is when you come back inspired and full of ideas.

Some Fun with MySQL’s History List

Why this article? First, I had fun digging in the code. Then, I was reading about the future improvements for MySQL 5.6 and about some currently in 5.5. Most of them are well covered by people with more expertise than me. So I read, but after a while I became curious, read the code, and performed tests. I was looking at how the new Purge thread mechanism work and its implications. Here’s what I found.

Log Buffer #269, A Carnival of the Vanities for DBAs

There is no replacement for the documentation of database products. There is no alternative to forums for these technologies, and no alter-ego for database blogs. They create yet another avenue to explore for professionals who need help. This Log Buffer Edition helps professionals locate a few blog posts from across the databases. Enjoy!

Collaborate 2012… And They’re Off

The thirsty attendees at this latest IOUG/OAUG/Quest show are keen. The registration lines were long, but no significant Oracle wait events. The show may officially kick off today, but the education began yesterday. Our very own Alex Gorbachev discussed HA all day in prep for a full week of education sessions. Yury has traveled all the way from Australia, and we’re glad he did. COLLABORATE often fights with one of my other passions – NHL playoff hockey. When you look deeper into both of these pastimes, they are remarkably similar.

Page 14 of 84« First Page...1213141516...20...Last Page »