2008
Mark's IT Blog: How to Hire a Great MySQL DBA
by mbertier (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 mbertier & 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
by mbertier (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 mbertier & 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 mbertier & 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 mbertier & 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
by mbertier (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
by mbertier
So what would be my list of limits and watch outs in this case ?
MySQL AB :: Improving Database Performance with Partitioning
by mbertier
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 dièse & 4 others (via)
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.
MySQL Cluster: Two webserver setup
by mbertier & 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.
1
(16 marks)
