Fedora Linux Support Community & Resources Center
  #1  
Old 2nd July 2008, 10:27 AM
ajeetraina Offline
Registered User
 
Join Date: Sep 2007
Posts: 93
MySQL or PostgreSQL?

have experienced MySQL in a telecom fault management system and although the usage is quite simple in setup and maintenance it did tend to get corrupted quite easily with high transaction volumes. Not a big problem for a fault management application because the next 300.000 error messages will be coming in in the next half hour anyway but not if you want to keep the data safe. I would not recommend MySQL for high reliability data storage.



Sofar I have had good experiences with PostgreSQL on stability and reliability level, I don't know about the transaction volume it can handle though. But there is as far as I know no limit on database size besides your storage and processing capacity of the server.



Any Comment?Which DB Gonna be suitable?
Reply With Quote
  #2  
Old 2nd July 2008, 10:32 AM
ivancat Offline
Registered User
 
Join Date: Dec 2007
Posts: 596
if you have to process a really large amount of transactions then of course PostgreSQL is a better choice. Also, you may consider using Oracle
__________________
Ivan Cat (registered linux user #471784)
Linux Projects: constat | nconv
Fedora-related: Message In the Bottle
Reply With Quote
  #3  
Old 6th July 2008, 09:19 PM
simonapnic Offline
Banned
 
Join Date: Jul 2008
Posts: 2
Post

Oracle is commercial as far as I know, so it's not wise to use it if you don't want to spend money. I'd recommend MySQL though, even if data can get corrupted as you say when dealing with large amounts of it.
What MySQL version have you "experienced" ? MySQL 5 has had significant updates and improvements, not to mention feature enhancements.
Reply With Quote
  #4  
Old 6th July 2008, 09:25 PM
bee Offline
Banned
 
Join Date: Jun 2008
Posts: 1,315
Quote:
Originally Posted by ajeetraina
have experienced MySQL in a telecom fault management system and although the usage is quite simple in setup and maintenance it did tend to get corrupted quite easily with high transaction volumes. Not a big problem for a fault management application because the next 300.000 error messages will be coming in in the next half hour anyway but not if you want to keep the data safe. I would not recommend MySQL for high reliability data storage.



Sofar I have had good experiences with PostgreSQL on stability and reliability level, I don't know about the transaction volume it can handle though. But there is as far as I know no limit on database size besides your storage and processing capacity of the server.



Any Comment?Which DB Gonna be suitable?
I agree. MySQL for PHP websites. PostgreSQL for everything else.
Reply With Quote
Reply

Tags
mysql, postgresql

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP & PostgreSQL northabc Servers & Networking 5 16th April 2005 06:16 AM
PostgreSQL dmode Servers & Networking 2 8th February 2005 08:40 AM
Postgresql VS MySQL (InnoDB) Lawes Using Fedora 2 17th January 2005 08:57 PM


Current GMT-time: 09:05 (Wednesday, 27-08-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat