Hi list, I've been using MySQL for small databases for 6 - 7 years (if I recall correctly), from php/web-applications to ODBC-applications in various languages and the native C API from C and C++ applications. The databases so far has varied from a few hundreds kbytes to a few gigabytes.
Now I'm working on two new projects. One commercial project that will hava a database with billions of records and an estimated database-size of > 1TB. Briefly, it will collect data from a number of MS SQL database-servers in a datacenter, and put everything into one huge database for reporting and analyzing. The big tables has small record-sizes with just a few numerical (32-bit and 64-bit) fields. The other project is an Open Source full-blown Internet news (nntp) server. I plan to store spool-records, header-information and small messages in the SQL-database (and data in large round-robin spool-files or raw disk-partitions). I have no experience with MySQL and databases of this size, so I'm looking for relevant articles and/or books. I have to figure out _if_ MySQL can do the job, how to tune it for top performance, how to make the databases reliable, how to backup/restore such databases, and what hardware and opertating system to reccommend. I'm greatful for any relevant information :) Jarle -- Jarle Aase email: [EMAIL PROTECTED] Author of freeware. http://www.jgaa.com news:alt.comp.jgaa War FTP Daemon: http://www.warftp.org War FTP Daemon FAQ: http://www.warftp.org/faq/warfaq.htm Jgaa's PGP key: http://war.jgaa.com/pgp NB: If you reply to this message, please include all relevant information from the conversation in your reply. Thanks. <<< no need to argue - just kill'em all! >>> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]