Posts Categorized: Pythian

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!

Storage Replication for Oracle Database and Licensing

While doing my high availability deep dive at Collaborate 12 few weeks ago, I stated that storage replication qualifies for the cold failover licensing rules (see slide #128). During collaborate, I spoke to one person at Oracle who definitely knows the rules. Simon Haslam also reached out to me by email pointing out that things might not be that rosy. I will update the slides accordingly. In any case, please do your own homework and don’t trust my conclusions here — don’t take this as licensing advice by any means.

How Do You Moderate LinkedIn Discussion Forums?

These are my personal rules to moderate the public forums on LinkedIn. I’ve posted on that topic in the discussion on the IOUG Exadata SIG forum. As I’m passing RAC SIG group to the next folks on the board (I’m the RAC SIG president until end of August), I needed to hand over my forum management duties too. I decided that it might be useful to the wider audience, so why don’t I just publish this on the blog?

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.

Page 62 of 223« First...102030...6061626364...708090...Last »