extending a database over several servers

[Daniel Page]

Hi,

Is it possible to extend a MySQL database over several servers in such a way that when 
space is exhausted on one server, a second machine can be added and used?

Cordially,
Daniel Page

MySQL spanned over several systems

[Daniel Page]

Hi,

I would like to try to implement a MySQL server that is spanned over several
machines (a sort of database cluster) - as this is only a test, I am not too
woried about the end OS, but I will probably use a Mandrake 8.1 or 8.2 Linux
distribution.

I have found in the manual information about running several servers on the
same system, but nothing on running one (or several linked) servers that can
run queries on a database distributed over several systems...

Any information, passed experiences, or links to ressources on the web will
be greatly appreciated.

Cheers,
Daniel



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: InnoDB and lock wait timeout

[Daniel Page]

Hi,

Generally, an apache setup will kill a PHP enabled page when it has run for
30 seconds. Also, when a php script exits, all connections to the database
are closed, so somwhere you need to keep the results of your script somwhere
(hidden HTML variables, URI string), otherwise, when you change pages (and
scripts of course), you lose your connection... and the transaction will
probably abort...

IMHO, you can only use a transaction within 1 PHP program (therefore within
1 page only), and remember your 30 second execution limit).

If you are implementing a PHP / HTML application, I would guide the user
over PHP enabled HTML form pages, and pass the result via a post or a URI
string to the next page, etc. When you have all the info that you need, you
send all the information from your previous pages to 1 parser script, which
inserts all info into the database, with or without a transaction. This is
the price you have to pay for a stateless connection - Your script is only
active when your page is active.

Hope that helps !

Cheers,
Daniel Page


-Original Message-
From: Victor [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 06, 2002 10:58 PM
To: MySQL
Subject: InnoDB and lock wait timeout


Hi. I have a question about rollbacks and innodb.

Suppose that a query begins with begin. Then a couple inserts happen but
before the commit statement is executed, the client hits stop in the
browser. What is going to do the rollback? If there is a persistent
connection, is it going to wait for 8 hours or so and what would happen
then?

Is there a significant increase in speed using persistent connections in
MySQL? I am using PHP and I am cuious how one would do a persistent
connection example. Does php would keep a class loaded in mem like java
would? It doesn't sound plausible since php is loaded with an apache thread,
which gets recycled every now and then, leaving the connection open on the
mysql side but never used by apache agian.

What are some approaches to solving these issues?

Thanks


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Distributed Database

[Daniel Page]

Hi,

This maybe a recurring question, but can MySQL be configured to work as a
distributed database? As a distributed database, I mean having the database
spanning several servers. For example:

Server 1 has 30 gb of free disk
Server 2 has 50 gb of free disk
Server 3 has 90 gb of free disk

My database will be 140Gb, and has to be spanned over Server1, server2 and
server3.

Preferably, I would like to use Windows NT Server / 2000 Advanced Server, as
we do not have the time to learn Linux at this time (and the company in
question does not believe in free software, but that will change :) - a
Linux or FreeBSD solution could be envisaged if needed - Would the
installation of the database on an NFS volume be a solution? I no very
little about NFS but it sounds interesting.


Any and all input welcome!

Cordially,

Daniel Page


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php