You should be just fine with mysql, yahoo finance runs everything under mysql. I route 2 million messages a day using mysql, (Includes spam preference lookups for everyone, destinations, routing, auth, pop3 and IMAP, radiator auth/acct) on one mysql (w/ a hot backup of course) 2x Xeon 500Mhz. You may get even better luck turning on query caching, which can improve speed substantially. http://www.eweek.com/article2/0,3959,293,00.asp http://www.mysql.com/information/benchmarks.html
-Dan Queries per second avg: 40.143 -----Original Message----- From: DUFOUR Geoffrey [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 9:16 AM To: [EMAIL PROTECTED] Subject: (RADIATOR) Radiator and Mysql under load Hello, � We plan to run RADIATOR on RH Linux and authenticate users from a mysql database (accounting information will be stored in the same database). We have to work with a data model that allows us to handle "group attributes" (reply and check), �"user attributes" (reply and check), and a few other things, meaning that the AuthSelect query will deal with several tables. � We should have up to 50.000 users in the database and 1000 realms in the config file (1500000 CDRs a month). � 1st question : Knowing all this, do you see any problems running RADIATOR with mysql (performance problems, ...). It seems a lot of people are working with MSSQL or Oracle databases to authenticate users. � 2nd question : Is it a problem for RADIATOR to handle a lot of realms, knowing all the information is kept in memory ? I am concerned about performance. � Thanks for your help. � Regards. � Geoffrey Dufour === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
