Running MySQL 4 And MySQL 5 Concurrently

This tutorial shows how to install MySQL 5 on a system where MySQL 4 is already running. It also shows how to configure phpMyAdmin to use both databases.

I was poking around the MySQL Worklog again over the weekend, and found a request for materialized views for MySQL. This feature has existed in Oracle for a while, in DB2 as a materialized query table, and appeared in MS SQL Server 2000 and 2005 as indexed views.

What is a materialized view?

A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, and other materialized views. (from Oracle).

Essentially a materialized view …

Well, the first summary of last 10 variable day outs.

Day Outs:

• Day Out #1: delay_key_write
• Day Out #2: key_buffer_size
• Day Out #3: max_connect_errors
• Day Out #4: innodb_buffer_pool_size
• Day Out #5: innodb_thread_concurrency
• Day Out #6: …

If you’re an advanced MySQL person, you might already know these, in which case, please read anyway, because I still have some questions. On the other hand, f you’re someone who launched an application without a lot of database background, thinking “MySQL Just Works”, you’ll eventually figure out that it doesn’t, and in that case, maybe these tips will be of some use. Note that I’m speaking specifically about InnoDB and MyISAM, since this is where most of my experience is. Feel free to add more to this content in the comment area. 

InnoDB vs. MyISAM

Which one to use really depends on the application, how you’re deploying MySQL, your plans for growth, and several other things. The very high-level general rule you’ll see touted on the internet is “lots of reads, use MyISAM; lots of writes, use InnoDB”, but this is really an oversimplification. Know your application, and know your data.  If all of …

Oursql-conferences is a discussion list for a community conf, not to compete with but augmenting the Sun/MySQL one. We're here to discuss such an event, its potential, dates/location, and get it going!

It's a public group, please blog & tell others about it!
Sheeri suggested OurSQL, like her podcast.

Members: 91

Discussions:

Conference Outline
By Eric Day - May 6 - 4 authors - 5 replies

Would a Virtual Conference Work?
By Sheeri K. Cabral - Apr 29 - 7 authors - 11 replies

How about a community build?
By Arjen Lentz - Apr 27 - 6 authors - 6 replies

Creation of oursql-sources Group
By Mark Schoonover - Apr 25 - 1 author - 0 replies

What about MySQL Camp?
By Keith Murphy - Apr 25 - 2 …

Oursql-conferences is a discussion list for a community conf, not to compete with but augmenting the Sun/MySQL one. We're here to discuss such an event, its potential, dates/location, and get it going!

It's a public group, please blog & tell others about it!
Sheeri suggested OurSQL, like her podcast.

Members: 91

Discussions:

Conference Outline
By Eric Day - May 6 - 4 authors - 5 replies

Would a Virtual Conference Work?
By Sheeri K. Cabral - Apr 29 - 7 authors - 11 replies

How about a community build?
By Arjen Lentz - Apr 27 - 6 authors - 6 replies

Creation of oursql-sources Group
By Mark Schoonover - Apr 25 - 1 author - 0 replies

What about MySQL Camp?
By Keith Murphy - Apr 25 - 2 …

Oursql-sources email group was created to discuss community MySQL builds, patches and adding features using the GPL'd version of MySQL sourcecode.

Members: 27

Discussions:

The MySQL CLA - A barrier to community contributions?
Source trees, Public Development and Builds - Version control, community contributions.

-- MarkMySQL DBA & Programming Blog by Mark Schoonover

Oursql-sources email group was created to discuss community MySQL builds, patches and adding features using the GPL'd version of MySQL sourcecode.

Members: 27

Discussions:

The MySQL CLA - A barrier to community contributions?
Source trees, Public Development and Builds - Version control, community contributions.

-- MarkMySQL DBA & Programming Blog by Mark Schoonover

Ask any DBA what are his top priorities for backup of MySQL. Chances are that hot backup and recovery to a specific point-in-time (or transaction) will be on top of everybody?s list.

The recovery to any point-in-time has been always an ultimate goal for data protection. Traditional backup solutions allow recovering only to a point in time when the last backup took place, e.g. last night. A lot of new data could be created and lost since that last backup. That is why in the last several years many vendors have been working on Continuous Data Protection (CDP).

Storage Networking Industry Association (SNIA) defines Continuous Data Protection (CDP) as “a class of mechanisms that continuously capture or track data modifications enabling recovery to previous points in time”.

I need to generate large (1TB-3TB) synthetic MySQL datasets for testing, with a number of requirements:

a) custom output formatting (SQL, CSV, fixed-len row, etc)
b) referential integrity support (ie, child tables should reference PK values, no orphans,etc)
c) able to generate multiple tables in parallel
d) preferably able to operate without a GUI and/or manual intervention
e) uses a well defined templating construct for data generation
f) preferably open source

Does anyone out there know of a product that meets at least most of these requirements?

*edit*
I found a PHP based data generation script (www.generatedata.com) that is extensible in its output formatting, so it should do everything I need it to do.