#mysql

WeSQL is an innovative MySQL distribution that adopts a compute-storage separation architecture, with storage backed by S3 (and S3-compatible systems). It can run on any cloud, ensuring no vendor lock-in.

BrewBlogger 2.3.2 is a easy to set up, easy to use, browser-based homebrew logging and calculation suite. It is a PHP/MySQL-based system that provides today's brewer not only a fast and easy way to record their brewing activities, recipes, and awards, but also forum to share their zymurgistic efforts and expertise with the homebrewing community around the world.

BrewBlogger 2.3.2 is a easy to set up, easy to use, browser-based homebrew logging and calculation suite. It is a PHP/MySQL-based system that provides today's brewer not only a fast and easy way to record their brewing activities, recipes, and awards, but also forum to share their zymurgistic efforts and expertise with the homebrewing community around the world.

Found this via kellan. Wow, and I *just* hit this issue yesterday on a MySQL 5.1 instance

"Shown below is a (single query) SQL-generated pie chart. I will walk through the steps towards making this happen, and conclude with what, I hope you’ll agree, are real-world, useful usage samples."

"One problem with the MySQL command line client is that queries with lots of columns tend to wrap crazily based on your terminal size. To overcome this, you can get a vertical output by terminating your queries with \G instead of ;. I find this format extremely helpful in cases where I know only one row will be returned. "

"Spock Proxy supports range-based horizontal paritioning of a large MySQL database. The proxy intercepts SQL queries from the client, sends queries to the correct databases based on how the database is partitioned, then aggregates the results from each database and returns them to the client as a regular MySQL result set. "

"The primero recommendation for speeding up a website is almost always to add cache and more cache. And after that add a little more cache just in case. Memcached is almost always given as the recommended cache to use. What we don't often hear is how to effectively use a cache in our own products. MySQL hosted two excellent webinars (referenced below) on the subject of how to deploy and use memcached."

"At peak times, the search engine needed to handle 1500-2000 searches every second against a MySQL database with about 200 million rows."

Noticing one thing missing from most tagging schemes: Preservation of the order of tags as entered with the item. Seems minor, but it's actually important for capturing intent.

"It seamlessly passes log data through the file system and directly into a database. Unlike existing log parsers, which often run periodically and scan the entire file for changes, LoggerFS takes a unique approach by masking the database backend with a fi

"Independent developer Mark Atwood has been working on a MySQL interface to Amazon S3."

"A single-page solution for exploring and editing databases from a browser."

"XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl."

"MySQL is just not built for large tag-systems. It just doesn't scale. It does scale up to 1 Million items but delicious does have far more posts."