MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  separate DB server from web server          MySQLTalk.org Forum Index -> Eventum General Discussion View previous topic :: View next topic   Author Message Barry Benowitz Guest Posted: Wed May 16, 2007 4:34 pm    Post subject: separate DB server from web server Is anyone using eventum with the web server running on a different box than the MYSQL engine? Do you see a performance boost when you do that? Thanks, Barry Back to top Bryan Alsdorf Guest Posted: Wed May 16, 2007 7:49 pm    Post subject: Re: separate DB server from web server Barry, Barry Benowitz wrote: Quote: Is anyone using eventum with the web server running on a different box than the MYSQL engine? Do you see a performance boost when you do that? Yes. If you see a performance boost will depend on your workload and specs of the machines. Are you having any performance problems right now? -- Bryan Alsdorf, Manager of Support Systems MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification Back to top Barry Benowitz Guest Posted: Wed May 16, 2007 7:57 pm    Post subject: RE: separate DB server from web server No, it appears to be running very well. We are receiving some complaints from users but they appear to be VPN and network related. I was just asked about a plan for expansion when the day comes. We currently run apache, MYSQL and CVS on the same box and we are moving CVS off this year, mostly to lower the risk of catastrophe. I know other commercial systems recommend separating the servers from each others from the start. I am thinking about taking a course on performance or admin so I can do a little more tweaking of the my.cnf file. -----Original Message----- From: Bryan Alsdorf [mailto:bryan (AT) mysql (DOT) com] Sent: Wednesday, May 16, 2007 10:50 AM To: Barry Benowitz Cc: eventum-users (AT) lists (DOT) mysql.com Subject: Re: separate DB server from web server Barry, Barry Benowitz wrote: Quote: Is anyone using eventum with the web server running on a different box than the MYSQL engine? Do you see a performance boost when you do that? Yes. If you see a performance boost will depend on your workload and specs of the machines. Are you having any performance problems right now? -- Bryan Alsdorf, Manager of Support Systems MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification Back to top Gaetano Giunta Guest Posted: Wed May 16, 2007 8:01 pm    Post subject: RE: separate DB server from web server You probably are already using it, but the most bang for the buck (in term of response times) comes from installing a php opcode cache, such as eAccelerator, APC or xcache. Quote: -----Original Message----- From: Barry Benowitz [mailto:barry.benowitz (AT) raritan (DOT) com] Sent: Wednesday, May 16, 2007 4:57 PM To: Bryan Alsdorf Cc: eventum-users (AT) lists (DOT) mysql.com Subject: RE: separate DB server from web server No, it appears to be running very well. We are receiving some complaints from users but they appear to be VPN and network related. I was just asked about a plan for expansion when the day comes. We currently run apache, MYSQL and CVS on the same box and we are moving CVS off this year, mostly to lower the risk of catastrophe. I know other commercial systems recommend separating the servers from each others from the start. I am thinking about taking a course on performance or admin so I can do a little more tweaking of the my.cnf file. -----Original Message----- From: Bryan Alsdorf [mailto:bryan (AT) mysql (DOT) com] Sent: Wednesday, May 16, 2007 10:50 AM To: Barry Benowitz Cc: eventum-users (AT) lists (DOT) mysql.com Subject: Re: separate DB server from web server Barry, Barry Benowitz wrote: Is anyone using eventum with the web server running on a different box than the MYSQL engine? Do you see a performance boost when you do that? Yes. If you see a performance boost will depend on your workload and specs of the machines. Are you having any performance problems right now? -- Bryan Alsdorf, Manager of Support Systems MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- Eventum Users Mailing List For list archives: http://lists.mysql.com/eventum-users To unsubscribe: http://lists.mysql.com/eventum-users?unsub=giunta.gaetano@sea- aeroportimilano.it Back to top Jostein Martinsen Guest Posted: Wed May 16, 2007 8:05 pm    Post subject: Re: separate DB server from web server And use ip-adress instead of hostname (f.ex. localhost) in both mysql and config.inc.php to avoid dns queries. On Wed, 16 May 2007 17:01:21 +0200 "Gaetano Giunta" <giunta.gaetano@sea-aeroportimilano.it> wrote: Quote: You probably are already using it, but the most bang for the buck (in term of response times) comes from installing a php opcode cache, such as eAccelerator, APC or xcache. -----Original Message----- From: Barry Benowitz [mailto:barry.benowitz (AT) raritan (DOT) com] Sent: Wednesday, May 16, 2007 4:57 PM To: Bryan Alsdorf Cc: eventum-users (AT) lists (DOT) mysql.com Subject: RE: separate DB server from web server No, it appears to be running very well. We are receiving some complaints from users but they appear to be VPN and network related. I was just asked about a plan for expansion when the day comes. We currently run apache, MYSQL and CVS on the same box and we are moving CVS off this year, mostly to lower the risk of catastrophe. I know other commercial systems recommend separating the servers from each others from the start. I am thinking about taking a course on performance or admin so I can do a little more tweaking of the my.cnf file. -----Original Message----- From: Bryan Alsdorf [mailto:bryan (AT) mysql (DOT) com] Sent: Wednesday, May 16, 2007 10:50 AM To: Barry Benowitz Cc: eventum-users (AT) lists (DOT) mysql.com Subject: Re: separate DB server from web server Barry, Barry Benowitz wrote: Is anyone using eventum with the web server running on a different box than the MYSQL engine? Do you see a performance boost when you do that? Yes. If you see a performance boost will depend on your workload and specs of the machines. Are you having any performance problems right now? -- Bryan Alsdorf, Manager of Support Systems MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- Eventum Users Mailing List For list archives: http://lists.mysql.com/eventum-users To unsubscribe: http://lists.mysql.com/eventum-users?unsub=giunta.gaetano@sea- aeroportimilano.it Back to top Harri Porten Guest Posted: Mon May 21, 2007 9:38 pm    Post subject: Re: separate DB server from web server On Wed, 16 May 2007, Bryan Alsdorf wrote: Quote: Yes. If you see a performance boost will depend on your workload and specs of the machines. Are you having any performance problems right now? A performance problem we have is with the download_emails.php script using POP to fetch mails. It consumes a lot of CPU. Guess it's not very effective when it decodes and parses the mails. Harri. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> Eventum General Discussion All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.