In light of recent vigorous discussion on SlashDot concerning MySQL vs PostgreSQL vs SAPDB, etc... my management is contemplating dropping MySQL support :-( in favor of PostgreSQL or Firebird/Interbase and I need some help/ammo from you guys to defend MySQL.
Here are the concerns: 1) ACID compliant transaction support. There is concern as to whether InnoDB is ready for prime time, especially as regards backups and our 24X7 needs. Our databases can grow very rapidly and we can't afford to bounce the database just to add datafiles as is currently required for InnoDB. 2) Excessive code to work around non-support for subselects. While subselects are scheduled for stable release in mid 2003, we can't wait that long and, based on past delivery of MySQL promised features, the current view is that subselects won't really be tested and supported (in stable production) until mid 2004. Is anyone willing and able to help me provide some defense for MySQL on this? History: We have experienced dramatic growth and our software is somewhat mature being maintained and enhanced by over 2 dozen fulltime developers and 7 sysadmins. Generally there is one database for each customer and each customer may have 10,000's of endusers who access our hosted databases. Currently we host our web application to about 1000 customers/databases on several large multiprocessor database servers with a coule EMC disk farms. We have multiple data centers in multiple locations. We have many database.tables with multi-million rows and a lot of concurrent enduser query access. Larger customers have occasionally sustained peak loads of 200 queries per second and on a few rare occasions we have neared 1000 queries per second for a single database for relatively brief periods. There are a significant number of inserts/updates that have created table locking problems and future software releases will be even more transaction intensive. Management thinks we have outgrown MySQL and need a "better" database. I need some MySQL ammunition to defend against changing databases. HELP... TIA, D. B. __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- 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
