Installing Apache2 With PHP5 And MySQL Support On Fedora 12 (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Fedora 12 server with PHP5 support (mod_php) and MySQL support.
The tracks of this year's "MySQL & Friends" Developer Room at FOSDEM 2010 have now been scheduled - please check the Wiki page for details on the talks as well as some background information about the speakers. This info should soon be available via the FOSDEM conference system as well. We had some last-minute changes and we actually managed to schedule two more talks due to a small glitch in the initial calculation. The topics look very interesting, we hope that we can provide some valuable information for developers, users as well as MySQL DBAs!
One of our speakers (Kris Buytaert) suggested to arrange a joint dinner for Saturday evening, which is indeed a good idea! Thankfully he also volunteered for coordinating it - thanks in advance! If …
[Read more]
Like a lot of you, I’ve been following with interest Percona’s testing of the open source column
databases. One thing I think is pretty cool about some column
databases that work with MySQL is that they don’t require you to
create indexes. The reason is, in general, the column is the
index. Not having to create indexes is nice because lots of
indexes can really bog down a database if you’ve got a lot of
load or DML activities because the indexes have to be maintained
for all data input and alterations.
In Percona’s test, they showed the load time for all the
different databases, but I noticed that the times didn’t include
the index creation for LucidDB or MonetDB. I decided to follow
Vadim’s link on the …
Around a year ago, I took on a new role at Sun as vice president of lifecycle marketing. While the title was an odd one, the charter was pretty straightforward: Bring the best practices of open source, Web 2.0, and modern online marketing to Sun's portfolio of servers, storage, software, and services in order to drive up revenues and drive down customer acquisition costs.
Open source was an incredible calling card that we could use to determine what customers were interested in. Now we just needed to figure out how to harvest that interest. It worked for …
[Read more]
I received a question from my last entry on how to let others see
your MySQL Certifications. In the past, the MySQL site had a list
of those with the various certifications. Sun's certification
system is different.
-
- Go to the Sun Certification Database
- Enter your ID and password. The format for the ID is usually
SUNnnnnnnn but it may be different. There is a First Time
Users link and a link to get your ID and password (you do
remember the email you used when you took that MySQL, don't
you?). And if you get stuck, contact Certificiation@SUN.Com
- On the left hand menu, under Certifications will be a
link for Publish Credentials.
- Here you provide an email address …
Last week some one asked how to Copy the tables (Only structure
and NO DATA..also no other DB objects) from one schema to another
on EE. This can be easily done from command line but user wanted
to do this thru stored procedure.
http://www.experts-exchange.com/Database/MySQL/Q_25024073.html
So I came with a very small MySQL procedure which was doing as
needed by the user. I'm not sure whether this is the best way to
do this but "There is always room for
improvement."
DELIMITER $$
DROP PROCEDURE IF EXISTS `CopySchema`$$
CREATE PROCEDURE `CopySchema`(sourceSchema
VARCHAR(64),targetSchema VARCHAR(64))
BEGIN
DECLARE no_more_rows BOOLEAN;
DECLARE loop_cntr INT DEFAULT 0;
DECLARE num_rows INT DEFAULT 0;
DECLARE …
MySQL/Galera release 0.7.1 ships out.
This is a maintenance release, which has fixes for 9 issues,
listed in launchpad release page:
https://launchpad.net/codership-mysql/0.7/0.7.1
It makes sense to upgrade, if you suffer from any of the
above.
Most notable changes are perhaps fixes for running concurrently
DDL and DML queries. The MySQL version has also been bumped two
notches up to 5.1.41
Prebuilt binary downloads are available, as usual, in the
launchpad site:
https://launchpad.net/codership-mysql/+download.
Pay attention to pick the latest 0.7.1 version, as launchpad
seems to give precedence for the old 0.7 release (no matter how
hard I try to configure LP...).