, these are distinct products: Both are DBMSs which speak SQL, but
coming from separate code bases they have different properties /
features and were (originally) targeted at different environments.
Can anyone tell me what the practical day-to-day differences between the two
products would be?
MaxDB
as though MySQL was playing cath-up to MaxDB. However, considering how many
people
use MySQL there must be some driving reason behind that choice.
Thanks for any help you can provide me on this front.
Darrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Could some one enlighten me about the differences between these 2 mysql
products?
Thanks
Juan M. Quiroz
Oregon Department of Agriculture
Systems Analyst
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Juan,
MAXDB is a totally different product, more akin to the corporate
databases like Oracle, Informix, Sybase etc. A description from the
mysql web site ( www.mysql.com )
MaxDB(tm) by MySQL
For the most demanding enterprise applications, MySQL offers MaxDB by
MySQL. Formerly known as SAP DB
Logan, David (SST - Adelaide) wrote:
Hi Juan,
MAXDB is a totally different product, more akin to the corporate
databases like Oracle, Informix, Sybase etc. A description from the
mysql web site ( www.mysql.com )
MaxDB(tm) by MySQL
For the most demanding enterprise applications, MySQL offers MaxDB
417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Kevin A. Burton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 4 January 2005 10:32 AM
To: Logan, David (SST - Adelaide)
Cc: Juan M.Quiroz; mysql@lists.mysql.com
Subject: Re: What is the difference between 4.1 and MAXDB 7.5
Hi,
While creating db instance, I have this error after
db_admin:
2004-08-10 11:38:12 1 ERR 11277 IPC
create_sem: semget error, No space left on device
I'm running MaxDB on Solaris 9. Could this be solved
by increasing semaphores? How do you increase
semaphores?
Thanks
On Tue, Jul 20, 2004 at 04:18:42PM +0800, [EMAIL PROTECTED] wrote:
I am new to MaxDB and clustering. It seems that both products provide
enterprise features and high availability.
Is clustering replacing MaxDB?
What are the difference between them?
Are they targeting different users?
Based
I'm maintaining 2 instances of MySQL running as slave/master on the same
machine. I was asked to install MaxDB on the slave server for testing...
The purpose of this post is for clarification... is MaxDB it's own db
instance or does it need MySQL running already running...
Depending
I am new to MaxDB and clustering. It seems that both products provide
enterprise features and high availability.
Is clustering replacing MaxDB?
What are the difference between them?
Are they targeting different users?
Thanks.
--
MySQL General Mailing List
For list archives: http
I find there is not much documentation about MaxDB.
Anybody know why do we need MaxDB?
Do you have a list of feature that is available on MaxDB only?
Thanks,
Joseph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hello Joseph,
you might want to look at these places:
General Overview: http://www.mysql.com/products/maxdb/index.html
Documentation, Articles, HowTos: http://dev.mysql.com/doc/maxdb/
Cheers,
Alexander Schröder
SAP DB, SAP Labs Berlin
-Original Message-
From
I'm working with maxDB 7.5 and trying to figure out whether mySQL 4.0.x database files
can be read by it. I'm getting the impression we will need to run a sqlimport from a
mysql dump to get the data. Is this the case? Has anyone been successful in
migrating to maxDB from mySQL 4.0.x?
thanks
Hallo !
Strange problem with maxdb odbc connections.
I installed maxdb, databasemanager and sqlstudio on my local windows xp
pc and did some testing.
My application connects via system-dsn MAXDBLOKAL
STORE
SQLSTRINGCONNECT('dsn=maxdblokal;port=7210;uid=DBA;pwd=DBA;DATABASE=BWNE
U
Hi Friends,
I am working on a pilot project that
will introduce open source databases in my organisation.
In my search I have found that MySQL
and MaxDB both are open source databases, but MaxDB is being used very
less in comparison to MySQL. If I link this with the fact that MaxDB provides
out there that will
interface with MySQL
[EMAIL PROTECTED] wrote:
Hi Friends,
I am working on a pilot project that will introduce open source databases
in my organisation.
In my search I have found that MySQL and MaxDB both are open source
databases, but MaxDB is being used very less
amounts of software out there that will
interface with MySQL
--8
Just to add a few more thingies:
Even though MaxDB has better looking admin tools (even the documentation
is visually more appealing) MySQL is by a _BIG_ far easier to manage,
learn and use (even easier to install!). I
,
running RedHat 9 if I set it to run in level 3 as compared to 5 that I am in
now?
Second I have tables in MS SQL Server that have over 50,000,000,000 records,
will SQL Server handle that, and would it be a benefit to use MaxDB? I read
through the MaxDB docs and am not sure when it is appropriate
Hello!
I was just wondering if I am the only one that's having problem
extracting maxdb .tgz file or there is someone else out there facing
similar problem.
tar zxvf filename.tgz or
gunzip filename.tgz , tar xvr filename.tar or
zcat filename.tgz | tar xvf -
should work, but i tried all
Can I install MaxDB 7.5 on Suse 9?
If yes How?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
!! Just an Idea.
Thanks
Emery
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 10:07
Subject: Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
Looking at the facts, the number of files used to store your data
Loosing one table [one data file] is less affecting than 10.
My view is that MySQL is good because it uses different data files. If one
data file gets corrupt, you will loose less information since it is only
one
table [meaning one data file] that is affected.
I am not an expert
Hi Mike,
I've asked this question a year ago on the Borland forums but didn't get
any replies. Do you know of any websites (non-programming related) that
are
using Interbase/Firebird for their primary webserver database? I don't
mean
programmer hangouts like www.mers.com or www.tamaracka.com
Hi,
Jerry,
Interbase/Firebird looks good on paper. But there are a
couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if
it is
still an issue. I know from reading their newsgroups a few years back
,
there were quite a
On Dec 17, 2003, at 7:35 AM, Matthew Stanfield wrote:
Wouldn't it be great if all mailing lists and newsgroups were as
friendly and helpful as the mysql ones are.
shameless plug
I host a couple of lists: ProLinux and ProPython, which are for
developers that are new to Linux and Python, and
Jerry Apfelbaum wrote:
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
Jerry -- See what I meant when I said:
very active mailing lists where list subscribers are helpful and quick to
respond.
I think we all deserve a
Yes, Matthew, the response to my original query here has been almost overwhelming, far
surpassing what I had expected.
Yes, you certainly all deserve a pat on the back.
Thanks to everyone who took the time to respond. This has proven to be a useful short
cut to ascertaining some of strengths
Martijn,
I've asked this question a year ago on the Borland forums but didn't get
any replies. Do you know of any websites (non-programming related) that are
using Interbase/Firebird for their primary webserver database? I don't mean
programmer hangouts like www.mers.com or www.tamaracka.com
Looking at the facts, the number of files used to store your data is of
very little consequence at the end of the day. Looking
at the following:
* MS SQL Server stores database data in a single file and logs in another.
* Oracle and FoxPro both have a pretty large number of files, for very
Hi!
--cut
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to resolve
Dr. Frank Ullrich wrote:
Hi!
--cut
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely
Jeremy Zawodny wrote:
On Tue, Dec 16, 2003 at 12:01:55PM +0700, David Garamond wrote:
Sven K?hler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's
Chris Nolan wrote:
Regarding mysqldump, it handles binary data through escaping the
required characters. pg_dump is similar if memory serves me correctly.
Thanks Chris.
So dumping binary data / large objects using myslqdump is fine. I looked up
if this is ok with pg_dump as well and it is but
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the BIT field act just like a single-bit
field.
Regards,
Chris
Sure --
Matthew Stanfield wrote:
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the BIT field act just like a
single-bit field.
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to resolve these
David Griffiths wrote:
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to
High-end database systems perfer more files, as they can be spread across
multiple (usually fast SCSI) disks. Most databases recommend logs be kept
on
seperate disks than database files.
Changes in the number of files can resolve problems if the problems are
the
result of low disk IO and
At 01:59 PM 12/14/2003, you wrote:
Hello.
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
The O/S is most likely to be Linux, although FreeBSD could possibly be used
(lower probability).
So far, it seems that MySQL, MaxDB
Hi,
Many Thanks.
Jerry Apfelbaum
Toronto
Jerry,
Interbase/Firebird looks good on paper. But there are a couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if it is
still an issue. I know from reading their newsgroups a few years
32-bit filesystem limits?
Looking at any modern Linux FS, your file size limits are not hindered
by 32-bit anything or even
the FS itself. On kernel 2.4, internal kernel structures limit the
maximum size of block devices to around 1 TB.
As a result, you can only have files of about that size
At 04:07 PM 12/16/2003, you wrote:
Hi,
Many Thanks.
Jerry Apfelbaum
Toronto
Jerry,
Interbase/Firebird looks good on paper. But there are a couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if it is
still an issue. I know from
Hi,
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird
are
possible candidates.
Does anyone know why we should or should not use any of these? Does
anyone
know of other possibilities?
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird are
possible candidates.
Does anyone know why we should or should not use any of these? Does anyone
know of other possibilities?
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database
It is a mystery to me how the PostGreSQL work. I cannot recomm to use
any feature discovered in PostGreSQL since some of the more uncommon
feature are broken.
Would you care to elaborate? I've used both PostgreSQL and mySQL, but
certainly not all features, and I'm curious about what issues
regards,
Chris
Sven Köhler wrote:
So far, it seems that MySQL, MaxDB, PostgreSQL, and
Interbase/Firebird are
possible candidates.
Does anyone know why we should or should not use any of these? Does
anyone
know of other possibilities?
I was very disappointed by Interbase/Firebird
for incoming connections
just like with MySQL, MS SQL Server, Oracle etc etc...
Well, the network-server seemed to me like an application that uses the
library i mentioned above. It doesn't seem to me like a big application
like MySql or MaxDB. In other words: Firebird seems to be light weight
DBMS. MySQL
or MaxDB. In other words: Firebird seems to be light weight
DBMS.
Light weight it sure is. Very modest on memory requirements, for example.
A bit too modest sometimes :-)
MySQL and MaxDB have a multi-threaded kernel that maintains its
own cache, coordinates locks, etc.
I don't think
process waiting for incoming connections
just like with MySQL, MS SQL Server, Oracle etc etc...
Well, the network-server seemed to me like an application that uses
the library i mentioned above. It doesn't seem to me like a big
application like MySql or MaxDB. In other words: Firebird seems
Firebird/Interbase have all those nice things like row-level locking
(although it doesn't seem to have multiversioning like InnoDB,
PostgreSQL or Oracle), deadlock detection, prepared statements, views,
Yes it DOES have multi-versioning. Actually, I believe it was the
first (InterBase that is)
Martijn Tonies wrote:
Firebird/Interbase have all those nice things like row-level locking
(although it doesn't seem to have multiversioning like InnoDB,
PostgreSQL or Oracle), deadlock detection, prepared statements, views,
Yes it DOES have multi-versioning. Actually, I believe it was the
Hi Chris,
Firebird/Interbase have all those nice things like row-level locking
(although it doesn't seem to have multiversioning like InnoDB,
PostgreSQL or Oracle), deadlock detection, prepared statements, views,
Yes it DOES have multi-versioning. Actually, I believe it was the
first
I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2
to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
since SQL-Statements are limited in length.
--
MySQL
Are they? Shoving in rows that are several meg in size didn't pose any
problems. The restore procedure looked like this:
bunzip2 dumpfile | mysql -u db_grunt -p projectdb
May I ask where the limitation you mentioned is documented? Maybe the
situations we were using it in didn't come close to
issues.
7.3 ands 7.4 are GPL/LGPL, since 7.5 aka MaxDB LGPL is dropped,
so you are forced to pay for Userlicences. Refer to http://www.mysql.com
We are thinking about to fork the SapDB 7.3/7.4 Brances to continue in
GPL/LGPL.
mfG
Jürgen
automatiX Linux Support Crew
- --
Jürgen
Sven Köhler wrote:
I set the isolation level to READ_REPEATABLE and use mysqldump |
bzip2 to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
since
Tobias Asplund wrote:
Sven Köhler wrote:
I set the isolation level to READ_REPEATABLE and use mysqldump |
bzip2 to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's
that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird are
possible candidates.
Does anyone know why we should or should not use any of these? Does anyone
know of other possibilities?
Id very much appreciate hearing your comments and recommendations.
I have only recently started
with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
The O/S is most likely to be Linux, although FreeBSD could possibly be
used (lower probability).
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird
are possible candidates.
Does
FreeBSD could possibly
be used
(lower probability).
So far, it seems that MySQL, MaxDB, PostgreSQL, and
Interbase/Firebird are
possible candidates.
Does anyone know why we should or should not use any of these? Does
anyone
know of other possibilities?
Id very much appreciate hearing your
: e-commerce, B2B, high availability.
The O/S is most likely to be Linux, although FreeBSD could possibly be
used (lower probability).
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird
are possible candidates.
Does anyone know why we should or should not use any of these? Does
On Tue, Dec 16, 2003 at 01:11:21AM +1100, Chris Nolan wrote:
To backup those funky sleek MyISAM tables, you could just issue a
LOCK TABLE statement or two (LOCK DATABASE?), do a FLUSH and copy
the files. If I recall correctly, (and I'm sure sirs DuBois and
Zawodny will find out where I live
I have only recently started these evaluations. BTW, my own background is
from the Oracle DBA world.
MySQL is certainly popular and seems to have very good performance, but I am
concerned that the lack of Triggers, Stored Procedures, User-Defined
Functions, and Views (to a lesser degree )
Sven Köhler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's inferior or
[intentionally] crippled like MS-Access. SQL server also works on
regular files (db is
On Tue, Dec 16, 2003 at 12:01:55PM +0700, David Garamond wrote:
Sven K?hler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's inferior or
[intentionally]
Hello.
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
The O/S is most likely to be Linux, although FreeBSD could possibly be used
(lower probability).
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase
Message -
From: Matthew [EMAIL PROTECTED]
To: Keith Bussey [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 4:18 PM
Subject: Re: MySQL vs. MaxDB
from http://www.mysql.com/press/release_2003_35.html
The MySQL database is a high performance relational database management
Hola,
I was wondering if anyone could point me to any articles or URLs that could
give me an idea of the differences between MaxDB and MySQL, specifically if
one were to use MaxDB instead of MySQL, what disadvantages would come with the
advantages (which to me are basically some
from http://www.mysql.com/press/release_2003_35.html
The MySQL database is a high performance relational database management
system that is noted for its speed, stability and ease of use, while MaxDB
is certified for SAP applications and includes features such as stored
procedures, triggers
On Fri, 28 Nov 2003, Lemasson Sylvain wrote:
May be this not the good mailing list. I have recently installed maxdb.
I have create succefully a database instance but when I try to launch it
(admin or onlyne mode) I have a runtime environment error saying I must
have a look to the application
I have an application written in Visual Basic and MS-ACCESS. I want to
migrate it to MySQL but MySQL does not support sub sub query. Does the maxdb
supports sub query ?
best regards,
Eduardo F. Melo
PRO-IT Serviços em Informática S/C Ltda.
Telefone : (19) 3897-5005
Fax : (19) 3909-4566
Resume
Eduardo,
I have an application written in Visual Basic and MS-ACCESS. I want to
migrate it to MySQL but MySQL does not support sub sub query. Does the maxdb
supports sub query ?
Yes. MySQL also supports subqueries as of 4.1, which will become Alpha
very soon.
http://www.mysql.com/doc/en
May be this not the good mailing list. I have recently installed maxdb. I have create
succefully a database instance but when I try to launch it (admin or onlyne mode) I
have a runtime environment error saying I must have a look to the application event
log. Where could I found this apllication
Hi.
Some curiosity. Does anyone know when the release of MySQL MaxDB 7.5 version
will come out?
In the MySQL web page at http://www.mysql.com/sapdb/timeline.html says that
the release was planned for 15 of October but now we are at 11 of November
and nothing has been released. Is it delayed
/mysql/
On Tuesday 11 November 2003 19:23, Iago Sineiro wrote:
Hi.
Some curiosity. Does anyone know when the release of MySQL MaxDB 7.5
version will come out?
In the MySQL web page at http://www.mysql.com/sapdb/timeline.html says that
the release was planned for 15 of October but now we
out of the
transaction context, so I must be very careful with this.
I know that MySQL 5 will support stored procedures, just like SAP DB supports them now.
Does anyone know how SAP DB (or MaxDB) will be integrated with MySQL? Will it be
supported just like InnoDB? So I would be able to access my
What is all this talk about max db, like why did they go and buy out SAP
DB ? What is going to happen to different databases under the mysql banner
or will the maxdb be implemented in mysql ?
Because some of the features in sap, i think everyone would want into
mysql, man i wish i could code c
Dear MySQL users,
The second press release about the partnership between MySQL and SAP is
out. We have now announced MaxDB by MySQL as the new name for SAP DB, as
well as some of the technical specifications for the first MaxDB release,
MaxDB 7.5, out Q4 2003.
What does this mean for you
78 matches
Mail list logo
