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.
I'm
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. There must
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'
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
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
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'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 the
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 feeling
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
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:
You make confusion between terms, CONCEPTS
]
[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 Gogancea wrote:
It's quite right, some SQL
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
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, please check:
http://www.mysql.com/manual.php (the manual)
http
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
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 distributed database system, like Oracle or
SQLServer, but open source
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, please check:
http://www.mysql.com/manual.php (the manual)
http
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
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 but I don't know of any database
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 used like
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
implemented facilities for this.
Distributed database can be achieved,like
, 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
implemented facilities for this.
Distributed database can be achieved,like example, using
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
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 database system, like Oracle or
SQLServer, but open
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/mysql/bychapter
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