Posts Categorized: Pythian

Hashing Algorithm in MySQL PASSWORD()

Recently we had a question from a customer: what is the hashing algorithm implemented in PASSWORD() ? The manual doesn’t give a straight answer in any of these two pages: http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_password http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html   It is enough to dig a bit more to find the solution in http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#4.1_and_later that specifies “mysql.user.Password stores SHA1(SHA1(password))” .   Instead of blindly…

Exadata Memory Expansion Kit

I was just looking at an Exadata X2-2 ordering document and noticed that it included 144GB of RAM. The sales rep pointed at the Exadata X2-2 datasheet and showed the 96GB to 144GB memory expansion option.

Building libMemcached RPMs

A client running CentOS 5.4 Amazon EC2 instances needed the latest libMemcachedversion installed. With the inclusion of the “make rpm” target, libMemcached makes it easy to build the libMemcached RPMs by doing the following: Spin up a new CentOS Amazon EC2 instance, As root on the new instance: yum install @development-tools yum install fedora-packager /usr/sbin/useradd…

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

Simple messages are the most powerful. Keep it simple is the advice given by top technologists. One reason why blogs are extremely popular is their simplicity. This simplicity comes from the shortness and focus of the message of the blog. This Log Buffer Edition collects some simple yet powerful blog posts for you in Log Buffer #248.

Using HAProxy for MySQL failovers

There are a number of solutions available for MySQL architecture that provide automatic failover, but the vast majority involve potentially significant and complex changes to existing configurations. Fortunately, HAProxy can be leveraged for this purpose with a minimum of impact to the current system.  Alex Williams posted this clever solution a couple years ago in…

UoK? Better Believe It

anticipate seeing people from all over the continent at UKOUG. The attendance over the past few years has been growing and nothing short of astounding. I am giving two papers at the show … one on a dear friend of us all called rman and the other on a close second … the physical standby. For me, even in the midst of emerging technology solutions, there’s still nothing like the old-fashioned Oracle CORE database arena.

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

Thanksgiving is here and the circular chain of thankfulness is going on. Clients are thankful that they have applications, applications are thankful to their databases, database are thankful to their DBAs, and DBAs are thankful to clients. And they all are thankful that there is weekly Log Buffer Edition, of which the latest is Log Buffer #247. :)

Last Day at PalominoDB

I have been the Community Liaison and a Senior DBA at PalominoDB for 15 months, and doing remote DBA work for 4 years.  In that time I have learned that “consultant” need not be a dirty word, and that in the DBA world it is actually extremely valuable to have a remote DBA with lots…

Page 80 of 232« First Page...10...7879808182...90...Last Page »