mysql

In order to make a CRM in drupal that has a local and a remote version I had to try to synchronise the two.
I have tried to do that in three steps

Good to know is, that I made the synchronisation program in vb.net, my knowledge of PHP was to small to make it in PHP.
It will only work with mysql 5 because that has the table with meta-data (information_schema)
I don't know if mysql 4 has this but I have been told that it hasn't.

The program is dual layered. It has a data connection layer that handles the connection between the program and mysql.

Web Applications Programmer

Reply to: employment@ewg.org

The Environmental Working Group (EWG) is a national, non-partisan organization that uses the power of information to protect the environment and human health. EWG seeks a detail-oriented, creative, deadline-driven applications programmer to assist with development of ewg.org and our other web sites. This full-time position is based in our Washington, D.C. headquarters.

RESPONSIBILITIES

Ok, i'll be the one to call the pink elephant in the room.....stored procedures do exisit. There I said it. :). With MySQL 5 starting to support them, Postgres has had them, and the push latley to start using a wider array and more robust DB's (oracle, mssql, DB2), it is time I think to start thinking about a database abstraction layer to handel stored procedures. I'm thinking perhaps something like this:

/**
* @param $proc_name Name of the stored proc.
* @param $args Argements to send to the proc indexed by the variables name. e.g. array('name' => 'Jim Smith');

Hi,

Here's a couple of tools that may help in monitoring MySQL performace:

• mysqlresources script - Measuring resources for a MySQL server on Linux (looking at /proc)
• innotop script - MySQL and InnoDB monitor (requires InnoDB)

Anyone using similar scripts to monitor high performance mysql servers?

Cheers

This group is an attempt to get a serious discussion started around database scalability with Drupal sites.

Right now, Drupal mostly relies on direct connections with mysql to generate Web pages. There is an internal caching mechanism which can help alleviate load, but which introduces some problems of its own (like the user login problem, where users have to reload a page after logging into the system). Typically, mysql optimizations and hardware concerns become a primary area of focus after Drupal has reached its caching limits. While there are not that many massively trafficed Drupal sites around (massive means greater than 100k hits an hour), they are coming, and it would be great to have some defined paths people could follow to build up their sites.