Sponsorised links
11 May 2008
Racklabs - Thoughts on the Hosted IT Revolution » Tech Talk videos online
MapReduce vs MySQL (speaker Stu Hood)
Next Generation Data Storage with CouchDB (speaker: Jan Lehnardt)
09 May 2008
07 May 2008
MySQL Conf - Memcached Internals - igvita.com
Don't think row-level (database) caching, think complex objects
Sponsorised links
05 May 2008
Nexen.net : portail PHP et MySQL - MySQL Online Backup : BACKUP et RESTORE
MySQL Online Backup est un projet de sauvegarde en fonctionnement d'un serveur MySQL. Il s'agit d'un client MySQL, qui exporte les données sans bloquer l'ensemble des autres clients, ou d'imposer un temps d'arrêt au serveur. Le MySQL Online Backup exporte aussi les données statistiques de la table (celles de SHOW TABLE STATUS), pour pouvoir y accéder indépendamment dans la sauvegarde.
01 May 2008
28 April 2008
27 April 2008
25 April 2008
24 April 2008
Les requêtes complexes avec MySQL
Jointures, unions, sous-requêtes, tables temporaires : quelques-unes des fonctionnalités de MySQL à ne pas oublier quand vient le moment de traiter des données sur plusieurs tables
23 April 2008
Sauvegarder/Eporter une base mysql depuis php
Fonction qui retourne l'entier d'un base mysql depuis php
22 April 2008
MySQL Conf - Memcached Internals - igvita.com
Brian Aker and Alan Kasindorf gave a great talk on Memcached - every developer's favorite caching layer - at MySQL User Conference earlier last week.
with sample architectures in the slides
16 April 2008
Testing PHP/MySQL Applications with PHPUnit/DbUnit - Sebastian Bergmann
Here is the presentation material I used for my "Testing PHP/MySQL Applications with PHPUnit/DbUnit" presentation at the MySQL Conference in Santa Clara, CA today.
14 April 2008
11 April 2008
10 April 2008
MySQL and UTF-8 [Web Application Component Toolkit]
Code to generate a mass change of collations:
09 April 2008
scalr - Google Code
Scalr is a fully redundant, self-curing and self-scaling hosting environment utilizing Amazon's EC2.
It allows you to create server farms through a web-based interface using prebuilt AMI's for load balancers (pound or nginx), app servers (apache, others), databases (mysql master-slave, others), and a generic AMI to build on top of.
The health of the farm is continuously monitored and maintained. When the Load Average on a type of node goes above a configurable threshold a new node is inserted into the farm to spread the load and the cluster is reconfigured. When a node crashes a new machine of that type is inserted into the farm to replace it.
4 AMI's are provided for load balancers, mysql databases, application servers, and a generic base image to customize. Scalr allows you to further customize each image, bundle the image and use that for future nodes that are inserted into the farm. You can make changes to one machine and use that for a specific type of node. New machines of this type will be brought online to meet current levels and the old machines are terminated one by one.
The project is still very young, but we're hoping that by open sourcing it the AWS development community can turn this into a robust hosting platform and give users an alternative to the current fee based services available.
