mysql

Hello. We've got 15 subscribers to our Huntsville Drupal group, but we are still kind of dead. Let's figure out a way to build a community of Huntville (or North Alabama/Tennessee Valley) Drupal users.

First off, I'd like to invite everyone to the PHP/MySQL/LAMP users group of Huntsville meeting in two weeks. The meeting will take place at 7PM in Huntsville on July 27. While these meetings are usually held somewhere like "Barnhills Grill", the current meeting doesn't have an announced meeting place. However, http://codango.com is sponsoring the meeting and will provide drinks and pizza. Stay tuned to that group for a finalized meeting place.

Go here for more information about the the Huntsville PHP/MySQL/LAMP meetup: http://php.meetup.com/348/

Secondly, be sure to subscribe to the RSS feed for this Huntsville Drupal group: http://groups.drupal.org/node/1183/feed

Finally, feel free to post to this group about the Drupal projects you are working. I'm always interested in seeing what others are making. I've got a couple of projects that I will be sharing here in a short while.

By the way, I've had the pleasure to meet Tony Gettig, Mike Stinson, and Philip Reed (current Huntsville Drupal users). If we can't get together for a group meeting, maybe we can meet in smaller groups for lunch or coffee.

Anyone else have any ideas on building our Huntsville group?

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.