Look forward in documentation at http://dev.mysql.com/doc/
for "Replication" and "MySQL Cluster" sections. Hopefully one
or both will be answer for you.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
On June 28, 2003 05:33 am, Aodhan Cullen wrote:
> 6/27/03 6:37:49 PM, Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> >> My read/update ratio would be something along the lines of 1:3, 3
> >> updates for every read. So it is highly unusual, and more or less
> >> rules replication out of the picture.
>
6/27/03 6:37:49 PM, Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
>> My read/update ratio would be something along the lines of 1:3, 3
>> updates for every read. So it is highly unusual, and more or less
>> rules replication out of the picture.
>
>I'm unclear why you can't use replication for this. T
On Thu, Jun 26, 2003 at 08:33:15PM +0100, Aodhan Cullen wrote:
>
> I've got an interesting problem for you all. I'd love to hear what
> you think.
>
> I've simplified the database design of my web application to its
> root problem, so it'll be very easy to see my difficulty, and if
> you're feelin
>I think it's always a bad idea to create complex setups like you are
>contemplating.
I'd agree. They are very hard to maintain if you need to change things in the
future.
>see any reason to use varchar, that creates variable length records
>which you want to avoid if you can. Especially with
> adding an integer 'userid' to member table and using it as a foreign key
> in member_log table instead of username.
You're right. The main reason i'm doing this, is due to legacy reasons.
> Also, I don't know what you mean by 'medint' but if it is a mediumint,
> you will be in trouble since its
I think it's always a bad idea to create complex setups like you are
contemplating. I would try everything else first. For instance, I don't
see any reason to use varchar, that creates variable length records
which you want to avoid if you can. Especially with the number of
records you are comp
Sorry to reply to myself but after reading your post again,
I think you can use replication to maintain member table in sync:
it is possible to restrict replication to a some tables within a
database: check 'replicate-do-table' option.
Hope this helps
Joseph Bueno
Joseph Bueno wrote:
I don't have d
I don't have direct answers to your questions but you should consider
adding an integer 'userid' to member table and using it as a foreign key
in member_log table instead of username. It will make selects and joins
faster, data and index sizes smaller.
Also, I don't know what you mean by 'medint' b
I've got an interesting problem for you all. I'd love to hear what you think.
I've simplified the database design of my web application to its root problem,
so it'll be very easy to see my difficulty, and if you're feeling generous
possibly offer a solution.
I have two tables.
member table (ci
Hi Bruce,
- Original Message -
From: "Bruce Feist" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, March 16, 2003 7:03 AM
Subject: Re: Looking for a bona fide distributed database that is open
source
> Gelu Gogancea wrote:
&g
Gelu Gogancea wrote:
You make confusion between terms, CONCEPTS and TECHNOLOGIES.Is not yet
invented the tools which should THINK instead of our BRAIN when must design
a system...any kind of.
You are mistaken if you think that I am confused about this.
There are RDBMS's out there that support
]
[EMAIL PROTECTED]
- Original Message -
From: "Bruce Feist" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, March 15, 2003 3:26 AM
Subject: Re: Looking for a bona fide distributed database that is open
source
> Gelu Go
"MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 5:26 PM
Subject: Re: Looking for a bona fide distributed database that is open
source
> Gelu Gogancea wrote:
>
> >It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have
> >imp
TECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 5:26 PM
Subject: Re: Looking for a bona fide distributed database that is open
source
> Gelu Gogancea wrote:
>
> >It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have
&
Gelu Gogancea wrote:
It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have
implemented facilities for this.
Distributed database can be achieved,like example, using DISTRIBUTED
OBJECTS(let's say CORBA).In my understanding that means that MySQL already
can be
Hi,
- Original Message -
From: "Brian Johnson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 7:14 PM
Subject: Re: Looking for a bona fide distributed database that is open
source
> My experience may be limited bu
Hi,
IMHO:
The distributed database is a concept which is can not be assign to the SQL
engine standards(AFAIK).Stored procedures,triggers are described in the SQL
92 or SQL 99 standards.
It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have
implemented facilities for
QL do that?
>>
>>Bruce Feist
>
>No. A given connection is a connection to a specific server. You cannot
>access tables managed by different servers within a single query.
>
>>
>>>--
No. A given connection is a connection to a specific server. You cannot
access tables managed by different servers within a single query.
- Original Message -
From: "james" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 4:44 PM
I am looking for a bona fide distrib
No, it is not distributed.
Bruce Feist wrote:
Gelu Gogancea wrote:
To anyone that *didn't see the forest because of the trees*.
You already find it.
Is MySQL really distributed, or just client-server? I've seen no
indication of distributed capabilities; I'm new to MySQL, so maybe I
just hav
uot;james" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 4:44 PM
I am looking for a bona fide distributed database system, like Oracle or
SQLServer, but open source running on Linux.
-
Before posting, pleas
ginal Message -
From: "james" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 4:44 PM
Subject: Looking for a bona fide distributed database that is open source
> To anyone that cares
>
> I am looking for a bona fide distributed databas
To anyone that cares
I am looking for a bona fide distributed database system, like Oracle or
SQLServer, but open source running on Linux. I have found one, Backplane,
but as I understand it it is used for BSD Unix. If anyone can help it would
be much appreciated.
tx Jimmy the hat
> Is MySQL support distributed database or not ?
> If yes, then please let me know , how it's doing .
Maybe not in a sense you'd like, but it has support for replication. Just
read up on the manual, as in (the url will propably wrap):
http://www.mysql.com/documentation
Dear Sir,
Is MySQL support distributed database or not ? If yes, then please let me know , how
it's doing .
Regards
Rajesh Matkar
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
27 matches
Mail list logo
