public marks

PUBLIC MARKS from mbertier with tags mysql & bestpractices

2008

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

(via)
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.)

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.

2007

Introducing MySQL Table Sync - Xaprb

(via)
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.

SourceForge.net: 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.

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.

2006

MySQL Backup and Recovery - The Open Source Backup Wiki (Amanda, MySQL Backup)

by 1 other (via)
Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server.

Converting to MySQLi - MySQLForge Wiki

(via)
We have good news for those of you who fear the work of converting thousands of lines of source code manually: MySQL has developed a tool which helps you with the conversion of the code.

MySQL Performance Blog » Thoughts on MySQL Replication

So what would be my list of limits and watch outs in this case ?

MySQL AB :: Improving Database Performance with Partitioning

I firmly believed how good physical database design was far and away the leading component of superior database performance.

2005

MySQL Cluster: Two webserver setup

by 4 others
This HOWTO was designed for a classic setup of two servers behind a loadbalancer. The aim is to have true redundancy - either server can be unplugged and yet the site will remain up.