"mysql"

One Tag, I'll be a cloud.

One Tag, I'll be a cloud.

Sphinx - Free open-source SQL full-text search engine
- saved on: 2008-02-16
- uri: http://www.sphinxsearch.com/about.html
- about: Sphinx is a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).
- tags:
  - embedded,
  - engine,
  - free,
  - full-text,
  - mysql,
  - open source,
  - search,
  - sql,
  - xml
Database replication lag | Dries Buytaert
- saved on: 2007-08-25
- uri: http://buytaert.net/database-replication-lag
- about: Consider the following pseudo-code: $nid = node_save($data); $node = node_load($nid); Because node_save() executes a mutator query (an INSERT or UPDATE statement) is has to be executed on the master, so the master can propagate the changes to the slaves. Because node_load() uses a read-only query, it can go to the master or any of the available slaves. Because of the lack of synchronization between master and slaves, there is one obvious caveat: when we execute node_load() the slaves might not have been updated.
- tags:
  - architecture,
  - delay,
  - drupal,
  - mysql,
  - php,
  - replication
Using Flex, PHP, and JSON to Modify a MySQL Database
- saved on: 2007-08-07
- uri: http://blog.paranoidferret.com/?p=43
- about: This tutorial should show a decent way to send data in a database to and from flex to php using json.
- tags:
  - flash,
  - flex,
  - json,
  - mysql,
  - php
mysql-filesystem-engine - Google Code
- saved on: 2007-05-03
- uri: http://code.google.com/p/mysql-filesystem-engine/
- about: This is a project for the MySQL Filesystem storage engine. It translates normal files on your server into relational tables inside of MySQL.
- tags:
  - code,
  - filesystem,
  - google,
  - mysql,
  - storage
~jk ORDER BY RAND()
- saved on: 2007-02-28
- uri: http://jan.kneschke.de/2007/2/15/order-by-rand
- about: If you read the MySQL manual you might have seen the ORDER BY RAND() to randomize the the rows and using the LIMIT 1 to just take one of the rows.
- tags:
  - mysql,
  - performance,
  - random
Storing Passwords in MySQL
- saved on: 2007-01-25
- uri: http://mysqldatabaseadministration.blogspot.com/2006/08/storing-passwords-in-mysql.html
- about: 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.
- tags:
  - aes,
  - groupe:clever age,
  - md5,
  - mysql,
  - password,
  - security,
  - sha1
Conseils pour l'amélioration des performances InnoDB
- saved on: 2007-01-24
- uri: http://dev.mysql.com/doc/refman/5.0/fr/innodb-tuning.html
- about: Quelques conseils pour améliorer les perfs InnoDB
- tags:
  - innodb,
  - mysql,
  - performance,
  - tuning
ARC: ARC - RDF and SPARQL for PHP developers
- saved on: 2006-08-13
- uri: http://arc.web-semantics.org/home
- about: ARC facilitates the integration of RDF and SPARQL functionality in PHP/MySQL-driven frameworks.
- tags:
  - mysql,
  - php,
  - rdf,
  - semantic web
OpenMSS :: View topic - Howto install a webserver, php and mysql
- saved on: 2006-08-09
- uri: http://www.openmss.org/forum/viewtopic.php?p=1735
- about: How to build a linux + lighhttpd + PHP5 + MySQL platform over a simple Mactor Shared Storage network disk.
- tags:
  - install,
  - lighthttpd,
  - mysql,
  - openmss,
  - php
Tutorial: ISP-style Email Service with Debian-Sarge and Postfix 2.1
- saved on: 2006-04-19
- uri: http://workaround.org/articles/ispmail-sarge/
- about: Un système de mails complet avec des utilisateurs virtuels gérés par MySQL
- tags:
  - debian,
  - email,
  - mysql