Open Source NoSQL Databases Ramp Up

For most of the Web era, Relational Database Management Systems (RDBMS) based on SQL have dominated the database landscape. But over the course of the last year, a new approach has begun to take hold known as NoSQL, offering an alternative to the traditional RDBMS. This week at the NoSQL Live conference in Boston, multiple [...]

Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2010.0

New tutorial added to HowtoMatrix database.
Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2010.0
Lighttpd is a secure, fast, standards-compliant web server designed
for speed-critical environments. This tutorial shows how you can
install Lighttpd on a Mandriva 2010.0 server with PHP5 support (through
FastCGI) and MySQL support.
Link to the original site

Why PostgreSQL is a better enterprise database than MySQL

When it comes to open source databases, MySQL gets the lion’s share of attention. MySQL is an easy-to-use database, and a lot of open source Web applications are geared towards it. The other primary open source database is PostgreSQL which, while widely known, doesn’t have the same mindshare that MySQL has obtained. This is unfortunate, [...]

EU Commission Approves Oracle-Sun Deal With No Conditions

It’s official. The Oracle-Sun merger has been approved by the EU Commission. There are no conditions. Here’s the press release, in which Neelie Kroes states that she is now satisfied that the transaction would not significantly impede effective competition: “I am now satisfied that competition and innovation will be preserved on all the markets concerned. [...]

Monty launches frantic ‘save MySQL’ web campaign

In a desperate last gasp bid to stop Oracle buying Sun Microsystems and its precious MySQL kit and kaboodle, the database’s co-creator – Michael ‘Monty’ Widenius – has launched a campaign to “help keep the internet free.” As we reported earlier this month, the European Commission welcomed a series of promises made by Oracle about [...]

MySQL: Two Potential Oracle Moves

Oracle has assured the European Union that the software giant will continue investing in Sun’s MySQL open source database. That move potentially clears the way for Oracle’s pending buyout of Sun Microsystems, according to published reports. But more importantly, the move positions Oracle to potentially undercut Microsoft’s SQL Server database. Will VARs choose sides? Let’s [...]

MySQL 5.5 Milestone 2 improves replication and stored procedures

The MySQL developers have released milestone 2 of MySQL 5.5, on the path to a general release in mid-2010. The new milestone release incorporates semi-synchronous replication in MySQL 5.5 based on patches to InnoDB developed by Google. This is designed to ensure that when a change is committed in the master database, at least one [...]

MySQL Community Server 5.0.88 has been released

MySQL Community Server 5.0.88 has been released. This release includes a security fix along with other bug fixes. “Security Fix: MySQL clients linked against OpenSSL did not check server certificates presented by a server linked against yaSSL.” Read more at LWN.net

Evolving A Database With MySQL

New tutorial added to HowtoMatrix database.
Evolving A Database With MySQL
This tutorial explains how to grow your own database definition in a way that is maintainable, by using so-called recreate scripts. These scripts can be used to both create a database from scratch and update an existing database.
Link to the original site

Stallman opposes Oracle’s takeover of MySQL

Following on from MySQL founder Monty Widenius, Richard Stallman, president of the Free Software Foundation, and non-profit organisations Knowledge Ecology International (KEI) and the Open Rights Group (ORG) have advised European Commissioner for Competition Neelie Kroes not to grant approval for Oracle’s takeover of MySQL. In a joint open letter, they argue that the takeover [...]

Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2009.1

New tutorial added to HowtoMatrix database.
Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2009.1
table align=left cellpadding=0 cellspacing=0 width=43 height=40 style=margin-top:0px;margin-bottom:0px;trtdimg class=teaser-image-even src=http://images.howtoforge.com/images/teaser/mandriva.gif width=40 height=40 alt= //td/tr/tablepbInstalling Lighttpd With PHP5 And MySQL Support On Mandriva 2009.1/b/p
pLighttpd is a secure, fast, standards-compliant web server designed
for speed-critical environments. This tutorial shows how you can
install Lighttpd on a [...]

Installing MySQL And phpMyAdmin On FreeNAS

This howto was written when I needed to run some php based web
applications and the only system around was FreeNAS. Although many
people are using php and MySQL on a FreeNAS box successfully I couldn’t
find any simple tutorial for the purpose, so I wrote one in case anyone
needs it.
Read more at HowtoForge

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 9.04

Cherokee is a very fast, flexible and easy to configure Web Server.
It supports the widespread technologies nowadays: FastCGI, SCGI, PHP,
CGI, TLS and SSL encrypted connections, virtual hosts, authentication,
on the fly encoding, load balancing, Apache compatible log files, and
much more. This tutorial shows how you can install Cherokee on an
Ubuntu 9.04 server with PHP5 support (through [...]

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 9.04 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 9.04 server with PHP5 support (mod_php) and MySQL support.
I do not issue any guarantee that this will work for you!
1 Preliminary Note
In this tutorial I use the hostname server1.example.com with the IP address [...]

Install PHP 5.3.0/Lighttpd On Debian (Lenny) With Imap, MySQL, Sqlite3 And ImageMagick Support

This tutorial covers the setup of PHP 5.3.0/Lighttpd on Debian (lenny) with imap, mysql, mysqli, sqlite3, ImageMagick and mycrypt support.
For this tutorial I will assume you are logged in as root this is not advised.
First we need to install the webserver:
aptitude install lighttpd
Now we install the packages needed for mysql and mysqli support. You will [...]

MySQL’s Future: Clues At Avnet Compass Conference?

As Oracle prepares to consume Sun Microsystems (and the open source MySQL database), The VAR Guy wonders: What does the future hold for MySQL’s channel partner strategy? Hmmm. An August 2009 Sun partner conference, called Avnet Compass, could provide some chatter on the topic. Avnet Compass, scheduled for Aug. 16-18 in Denver, Colo., is an [...]

Howto install Cherokee web server with MySQL, PHP support on Jaunty

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, SSI, TLS and SSL encrypted connections, Virtual hosts, Authentication, on the fly encoding, Load Balancing, Apache compatible log files, Data Base Balancing, Reverse HTTP Proxy, Traffic Shaper, Video Streaming and much more.
Read the [...]

How to repair a corrupt table in MySQL

Occasionally, under circumstances involving high load on the server, multiple INSERTs and UPDATEs, coupled with many SELECTs (see Section 28.5 for the syntax of SQL code), or hardware failure, your database server may corrupt a table. This is something it shouldn’t happen, but of course this doesn’t help you if it does. According to the
Read [...]

Sun Connector for MySQL Beta released

Sun Microsystems has announced the release of the first beta of the MySQL SDBC driver, aka Sun Connector for MySQL and formerly known as the MySQL Native Driver. The beta can be used by OpenOffice 3.1 to connect to a MySQL server running version 5.1 or later. The extension integrates seamlessly into OpenOffice and is [...]

Open Database Alliance created for MySQL

The Open Database Alliance (ODA) has been launched. The consortium, founded by Monty Program AB, the company created by MySQL founder Monty Widenius, and MySQL specialists Percona, has been created as a focal point for all companies, organisations and individuals with an interest in MySQL and the future development of the open source database. According [...]