mysql

I am seeking advice about what might be the best database program to use to create a large pre-MySQL database, from which I will select the content to export/import/enter into a Drupal MySQL database.

I am developing my first Drupal site -- a web portal where information will be organized by relevance to various generations. The site will launch with a Baby Boomer orientation, with information organized for various baby boomer niches, and then expand to serve more generational niches.

Business Integration Technology has just released SQL ICE, the Internet Computing Environment for SQL Experts. Although SQL ICE can do a lot of things, one that may be of interest to Drupal Users is the ability to connect to your Drupal database and write MySQL queries to get reports that can be displayed, downloaded, and shared with other users.

All you need to do is add a Connection to the target database and write a query in SQL. The data is exposed as an XML document accessed by a REST Web service. For example, a simple query like:

Select

Hi there,

We had a second site in the cloud that has all of our sites set up and ready to go with a quick DNS change. MySQL is kept up to date with replication over an SSH tunnel, and we use lsync to keep the files in sync. The problem that I'm seeing is that, if we switch to the disaster recovery/second site and new data starts to be written to MySQL on the slave server, what would be the best workflow for returning this data back to the primary site?

A note from the developer who oversees one of my Drupal sites. We could use your help.

Hello,

I have a rather burly Drupal based site that seems to be causing some
problems, today we had a major outage. There are many slow queries
and also mysql related iowait that causes server processes to hang, at
least that is the theory.

Here you can examine some of the stats on the server:
http://andric.us/load/localdomain/localhost.localdomain.html

You can see my iowait stats here, which are pretty high:
http://andric.us/load/localdomain/localhost.localdomain-cpu.html

I setup a MySQL 5.0 Cluster on a spare server with multiple Xen VMs and discovered that Drupal 6 (and most likely D7 as wel) as it exists today cannot function properly under the MySQL NDBCLUSTER engine. It seems that under the NDBCLUSTER engine (also known as NDB), D6 has a table called menu_router that fails to be converted.

I posted a bug report about it under the D6 platform as it is rather detailed, but I have an idea this will affect D7 as well.
http://drupal.org/node/391130

Reading the MySQL Performance Blog I've found that they have released a new storage engine that's based on InnoDB with a few performance additions. I thought it could be of interest to some of you.

Here's a few links about it:

<

ul>

Its about drupal installation
I have have uploaded the drupal 6.3
but facing problems in database commands as i am new to mysql and drupal as well
will it be possible for anyone to give few minutes if i forward my account info.
Regards.
gitesh