public marks

PUBLIC MARKS from mbertier with tag mysql

March 2008

Mark's IT Blog: How to Hire a Great MySQL DBA

Hiring a MySQL DBA can be challenging, especially when the demand for MySQL DBAs is greater than there are qualified people to fill those positions. This article will go into some details on how to recruit, recognize, and interview a great MySQL DBA. (For the rest of this article, MySQL DBA and DBA are the same.)

Ivan Zoratti's Blog (on MySQL): Meetup Group and Thoughts on MySQL Proxy

I have created a shortlist of what the Enterprise customers like to see with Proxy. Jan and the engineering team are working at some of these features, but it would be really great to see the contribution from the Community as well.

Design details of’s high performance MySQL search engine |

As I mentioned before, search was one of most interesting problems I worked on at Audiogalaxy. It was one of the core functions of the site, and somewhere between 50 to 70 million searches were performed every day. At peak times, the search engine needed to handle 1500-2000 searches every second against a MySQL database with about 200 million rows. It was frequently hard to design for more than 10 or 100x our current traffic (and our growth was so dramatic that there wasn’t really ever time to spend more than a few weeks on the problem), so it wasn’t until the 4th major iteration on the cluster design that I really considered the scale problems to be solved.

February 2008

TagSchema - MySQLForge Wiki

by 2 others (via)
This page and related pages describe various issues surrounding the Web 2.0 tagging and folksonomy concepts, including discussions on schema architecture, common data access patterns, and replication/scale-out guidelines.

January 2008

MySQL Swiss Army Knife | lefred's blog

by 3 others (via)
In this post I present my MySQL Swiss Army Knife, all the tools that make my life related to MySQL easier :-)

November 2007

August 2007

GreenSQL - Open Source Database Firewall Solution

by 4 others
GreenSQL is an Open Source database firewall used to protect databases from SQL injection attacks. GreenSQL works in a proxy mode and has built in support for MySQL. The logic is based on evaluation of SQL commands using a risk scoring matrix as well as blocking known db administrative commands (DROP, CREATE, etc). GreenSQL is distributed under the GPL license

The open-source community's double standard on MySQL | The Open Road - CNET Blogs

When IBM, Adobe, Oracle, Novell, SAP, or other proprietary companies release even a modicum of code, they get universal plaudits. When 100% open-source companies like Red Hat and MySQL rejig the way they release code (while still releasing it and fully complying with open-source licenses), they get tarred and feathered.

MySQL Community split officially a failure

MySQL fundamentally misunderstands their community

Download | Community MySQL Builds

DorsalSource is a community-focused website whose goal is to provide builds of MySQL and related products. It will be maintained and run by the community. Solid Information Technology and Proven Scaling took the initiative to launch it. We will add additional contributors over time.

Target Practice - A Workshop in Tuning MySQL Queries - Jay Pipes

I gave a tutorial at OSCON last week on tuning MySQL queries, the EXPLAIN statement, the optimizer, and benchmarking. I've gone ahead and put the tutorial materials online now:

MySQL Performance Blog » Landscape of Transactional Storage Engines for MySQL

talks about current state behavior and performance properties of Innodb, Falcon, PBXT and SolidDB Storage Engines

July 2007

Diamond Notes » Blog Archive » Fantastic New Tool!!!!!

The tool is called Querysniffer and it grabs MySQL queries from “the wire”. It does this in real time. You don’t have to stop/start your MySQL server or have to enable the general query log. You can start and stop the Querysniffer at any time.

Mark's IT Blog: MySQL 5 High Availability with DRBD 8 and Heartbeat 2

In this article, we're going to go through the entire process of installing, configuring and testing DRBD, Heartbeat and MySQL running in a 2 node cluster environment. This will be a bare bones configuration, best practices and security will take a back seat while we learn how all the different pieces work together.

June 2007

MySQL and the The Death of RAID « Kevin Burton’s NEW FeedBlog

RAID is dying. Shocked? The prediction might be a bit early for some folks. It’s still somewhat conventional for some people to think that RAID is a conservative way to scale your IO.

April 2007

Google Code - Updates: Google releases patches that enhance the manageability and reliability of MySQL

by 1 other (via)
The high availability features include support for semi-synchronous replication, mirroring the binlog from a master to a slave, quickly promoting a slave to a master during failover, and keeping InnoDB and replication state on a slave consistent during crash recovery. The manageability features include new SQL statements for monitoring resource usage by table and account. This includes the ability to count the number of rows fetched or changed per account or per table. It also includes the number of seconds of database time an account uses to execute SQL commands.

March 2007

Introducing MySQL Table Sync - Xaprb

MySQL Table Sync efficiently finds and resolves data (not structural) differences between two MySQL tables, which may be on different servers. It offers two search algorithms to find the rows that differ, and several methods to bring the destination table into sync with the source.

February 2007 MySQL Toolkit

by 2 others (via)
This toolkit contains essential utilities for MySQL developers and administrators, such as a query profiler, a duplicate index and foreign key checker, and a table checksum tool.

January 2007

MySQL AB :: Managing Hierarchical Data in MySQL

by 13 others (via)
What I would like to focus on in this article is a different approach, commonly referred to as the Nested Set Model. In the Nested Set Model, we can look at our hierarchy in a new way, not as nodes and lines, but as nested containers.

How to make MySQL replication reliable - Xaprb

by 1 other
This article explains how to avoid problems, help your slaves stay in sync with the master, and recover from disasters more quickly.

MySQL: Storing Passwords in MySQL

by 2 others (via)
Securing plain text passwords in MySQL is NEVER a good idea. As a DBA you should take great care in protecting the users' information. Fortunately MySQL provides you with several options to protect passwords.

MySQL Performance Blog » Performance impact of complex queries

What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which were taking milliseconds to stall for few seconds, especially in certain OS configurations, and on low profile servers (ie having only one disk drive) even if you just have one such query running concurrently.

December 2006