Re: Postgres in Utah
On Tue, Nov 17, 2009 at 6:33 PM, Jim Wright wrote: > Are there many companies in Utah using Postgres? I have been trying to > do a search for companies doing work with it on a large scale and have > only found a handful. Backcountry and EMC and a few others and that is > about it. Why aren't a lot of companies using it? I have some thoughts on why it's not used more: - Market share. MySQL has more market-share. More beginning database admins are going to know about MySQL than they are about Postgresql. If you counted the database books at a local bookstore, I think those about MySQL would far outnumber those about Postgresql. And most of the books about PHP (another market-share leader) are likely going to have a chapter about accessing MySQL databases from PHP in them (and less likely to have a chapter about accessing Postgresql). MySQL has its own large O'Reilly conference (Google tells me Postgresql has its own conference, but I had never heard of it until now). - Replication. Unless things have changed drastically in the last year and a half (I haven't kept up with Pg much in that time period), setting up reliable and robust replication in Postgresql is nowhere near as simple as it is with MySQL. - Flexibility/Simplicity. MySQL is rather flexible when you stick with the basics. MyISAM is drop-dead easy to admin. It's (relatively) easy to back up, it's easy to schlep a 'database' from one machine to another when you need to, and so forth. That simplicity is probably a major reason why Omniture^WAdobe has MySQL (and not Postgresql) running on thousands of machines. - MySQL (for the reasons in the previous bullet point and more) has a less-demanding learning curve. All the above said, having admin'ed both in production environments, I find PG a much better designed database engine. In so many ways, it just feels better-engineered. I attended the MySQL conference this year, and was dismayed to see entire companies built around offering solutions to the headaches inherent in scaling MySQL. Sessions about running multiple instances of MySQL on a single box because MySQL can't scale well beyond a few cores. Having said that, my mantra is 'all databases stink, some just stink more than others.' The major movement right now with NoSQL data stores like CouchDB and its associates is a testament to the fact that traditional relational[sic] databases don't scale (well) to the massive amounts of data the likes of Google, Amazon, and Facebook are wrangling. I agree with Sasha--If you can find someone with good knowledge of the fundamentals of the relational model, data access, and database structures, someone who can tell you (for example) what the structure of a B-tree index looks like, why full-table scans, in some instances, are preferable to indexes, how to analyze and optimize queries (his/her first question should be along the lines of "What's this product's equivalent of EXPLAIN ..."), then with some ramp-up time (all db engines have their peculiar warts you have to learn about), you'll have someone who can do a good job with any database product you throw at them. OK, I've rambled enough. Time for bed. Best, Dan /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
lcd touchscreen
Hey Does anyone have a standalone lcd touchscreen that works with linux that I could borrow for a week or buy? We just found out slimage's "linux support" consists of a driver built in 2007 and never updated. I need something I can get this weekend to really make the client happy again. Brad /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
On Fri, Dec 4, 2009 at 8:40 PM, Shane Hathaway wrote: > Gabriel Gunderson wrote: >> No really, it's marvelous. Think about it... you get all the >> benefits of a truly enterprise DB (MSSQL) and world-class webserver >> (IIS) without having to leave Linux. And thanks to the Wine project, >> it Just Works. >> >> The best part is that doing a simple "apt-get install wine" is much >> easier then installing Windows and keeping it updated. Well, since >> we're using Fedora[1] for our production servers, it's more like "yum >> install wine", but you get the picture. > > Ok, but I thought the main reason people want an enterprise database is > to get commercial support. There's no way Microsoft is going to support > a Wine-based installation. I'm guessing you're supporting some existing > application that only runs on MSSQL. For all new development, surely > you'd want a database designed for Unix. Right. Like you said, one of the main reasons that one chooses an Enterprise DB (over some community developed one) is the support. It's totally reassuring that you can pick up the phone and get someone with the serious technical expertise needed to get things working again. Not to mention, they'll have access to internal KBs that nobody else does. Heck, they might even have access to the source code and be able to take it line by line until they find your problem. You can't put a price on that kind of support. They would *not* be thrilled to know that I'm running IIS and MSSQL Server on Wine, but really, have you ever been asked that question when you call tech support? I just don't mention it. And when they say, "OK, click on the START button on the bottom, left-hand part of the screen," I just wait a moment and say, "OK." They never really know, so yeah, that works great. You gotta remember, when you're supporting Enterprise systems, you can't do anything that might limit your access to that support --that's why we shell out the big bucks of the products in the first place. And if you're doing something like running MSSQL under Wine, you just need to keep it low key. Gabe /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
Gabriel Gunderson wrote: > No really, it's marvelous. Think about it... you get all the > benefits of a truly enterprise DB (MSSQL) and world-class webserver > (IIS) without having to leave Linux. And thanks to the Wine project, > it Just Works. > > The best part is that doing a simple "apt-get install wine" is much > easier then installing Windows and keeping it updated. Well, since > we're using Fedora[1] for our production servers, it's more like "yum > install wine", but you get the picture. Ok, but I thought the main reason people want an enterprise database is to get commercial support. There's no way Microsoft is going to support a Wine-based installation. I'm guessing you're supporting some existing application that only runs on MSSQL. For all new development, surely you'd want a database designed for Unix. Shane /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
Gabriel Gunderson wrote: > On Fri, Dec 4, 2009 at 1:42 PM, Michael Torrie wrote: >> I didn't know MSSQL could run on Linux. > > Michael, you should know better. I run MSSQL Server & IIS using wine > on Linux all the time - it runs wonderfully well. The performance is > really impressive and it's nice to have "Enterprise" database and > webserver options that work well on Linux. I'll write up some > documentation and post it for those who might be interested. That's awesome! /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
On Fri, 2009-12-04 at 18:21 -0700, Gabriel Gunderson wrote: > No really, it's marvelous. Think about it... you get all the > benefits of a truly enterprise DB (MSSQL) and world-class webserver > (IIS) without having to leave Linux. And thanks to the Wine project, > it Just Works. > > The best part is that doing a simple "apt-get install wine" is much > easier then installing Windows and keeping it updated. Well, since > we're using Fedora[1] for our production servers, it's more like "yum > install wine", but you get the picture. /me crawls under his desk and sobs quietly -- "XML is like violence: if it doesn't solve your problem, you aren't using enough of it." - Chris Maden /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
On Fri, Dec 4, 2009 at 5:11 PM, Shane Hathaway wrote: > Stuart Jansen wrote: >> On Fri, 2009-12-04 at 14:31 -0700, Gabriel Gunderson wrote: >>> On Fri, Dec 4, 2009 at 1:42 PM, Michael Torrie wrote: I didn't know MSSQL could run on Linux. >>> Michael, you should know better. I run MSSQL Server & IIS using wine >>> on Linux all the time - it runs wonderfully well. The performance is >>> really impressive and it's nice to have "Enterprise" database and >>> webserver options that work well on Linux. I'll write up some >>> documentation and post it for those who might be interested. >> >> Okay, good one. You got me. >> >> At least I hope you're kidding. >> >> You are kidding, aren't you? >> >> Please say you're just kidding! > > Lurkers everywhere would like to hear the answer to this one. :-) No really, it's marvelous. Think about it... you get all the benefits of a truly enterprise DB (MSSQL) and world-class webserver (IIS) without having to leave Linux. And thanks to the Wine project, it Just Works. The best part is that doing a simple "apt-get install wine" is much easier then installing Windows and keeping it updated. Well, since we're using Fedora[1] for our production servers, it's more like "yum install wine", but you get the picture. Best, Gabe 1) Fedora generally has the latest packages, and that's *key* when running Wine in production environment. /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
looking for a sys admin
LINUX SYSTEMS ADMINISTRATOR RemedyMD, a Salt Lake City-based company, is currently recruiting a Linux System Administrator who will manage our corporate servers and networks, as well as help manage our production systems. DUTIES AND RESPONSIBILITIES - Manage 30+ linux servers - Manage 30+ desktop computers (mostly Windows) - Provide internal technical support to employees - Arrange purchases for corporate workstations, software, and peripherals - Track all corporate assets and software licenses - Learn to manage an Oracle 11g database REQUIRED SKILLS - Know your way around linux command line. - Ability to learn new technologies and concepts quickly. - Good communication and follow-up with users. OTHER BENEFICIAL SKILLS - Google apps - If I teach you something once, I don't want to ever teach it to you again. - Redhat/CentOS, Debian - Jira management - Oracle installation and management - Apache tuning and server management - PHP installation - Java application server management Salary range - $35K - $60K /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
Stuart Jansen wrote: > On Fri, 2009-12-04 at 14:31 -0700, Gabriel Gunderson wrote: >> On Fri, Dec 4, 2009 at 1:42 PM, Michael Torrie wrote: >>> I didn't know MSSQL could run on Linux. >> Michael, you should know better. I run MSSQL Server & IIS using wine >> on Linux all the time - it runs wonderfully well. The performance is >> really impressive and it's nice to have "Enterprise" database and >> webserver options that work well on Linux. I'll write up some >> documentation and post it for those who might be interested. > > Okay, good one. You got me. > > At least I hope you're kidding. > > You are kidding, aren't you? > > Please say you're just kidding! Lurkers everywhere would like to hear the answer to this one. :-) Shane /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
On Fri, 04 Dec 2009 13:42:30 -0700 Michael Torrie wrote: > > I didn't know MSSQL could run on Linux. At least as well as it does on Windows. -- Charles Curley /"\ASCII Ribbon Campaign Looking for fine software \ /Respect for open standards and/or writing? X No HTML/RTF in email http://www.charlescurley.com/ \No M$ Word docs in email Key fingerprint = CE5C 6645 A45A 64E4 94C0 809C FFF6 4C48 4ECD DFDB /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
On Fri, 2009-12-04 at 14:31 -0700, Gabriel Gunderson wrote: > On Fri, Dec 4, 2009 at 1:42 PM, Michael Torrie wrote: > > I didn't know MSSQL could run on Linux. > > Michael, you should know better. I run MSSQL Server & IIS using wine > on Linux all the time - it runs wonderfully well. The performance is > really impressive and it's nice to have "Enterprise" database and > webserver options that work well on Linux. I'll write up some > documentation and post it for those who might be interested. Okay, good one. You got me. At least I hope you're kidding. You are kidding, aren't you? Please say you're just kidding! -- "XML is like violence: if it doesn't solve your problem, you aren't using enough of it." - Chris Maden /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
On Fri, Dec 4, 2009 at 1:42 PM, Michael Torrie wrote: > I didn't know MSSQL could run on Linux. Michael, you should know better. I run MSSQL Server & IIS using wine on Linux all the time - it runs wonderfully well. The performance is really impressive and it's nice to have "Enterprise" database and webserver options that work well on Linux. I'll write up some documentation and post it for those who might be interested. Gabe /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
Jeff Moyes wrote: > All, > > Dumb question and i should know the answer - can you have multiple > DBMSes running at the same time on the same server? (I would think yes > with possibly the proviso that they are listening on different ports?) I didn't know MSSQL could run on Linux. > I'm doing a project for someone who has a co-located windows box that > runs multiple sites using IIS and MSSQL but we're looking at installing > a new web app that requires mySQL. Can we keep the existing site on the > IIS+MSSQL and have it peacefully coexist with IIS+mySQL? I host MySQL and PostgreSQL on the same box. I'm not sure anything can peacefully coexist with IIS. But yes, IIS and MSSQL should be able to handle MySQL as well on the same box. /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Re: Can mySQL and MSSQL coexist on the same server peacefully?
Certainly, as long as the box has enough resources to support both servers. On Fri, December 4, 2009 12:14 pm, Jeff Moyes wrote: > All, > > Dumb question and i should know the answer - can you have multiple > DBMSes running at the same time on the same server? (I would think yes > with possibly the proviso that they are listening on different ports?) > > I'm doing a project for someone who has a co-located windows box that > runs multiple sites using IIS and MSSQL but we're looking at installing > a new web app that requires mySQL. Can we keep the existing site on the > IIS+MSSQL and have it peacefully coexist with IIS+mySQL? > > Any help would be appreciated > > Jeff > > > /* > PLUG: http://plug.org, #utah on irc.freenode.net > Unsubscribe: http://plug.org/mailman/options/plug > Don't fear the penguin. > */ > -- Matthew Walker Kydance Hosting & Consulting, Inc. - http://www.kydance.net/ PHP, Perl, and Web Development - Linux Server Administration /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
Can mySQL and MSSQL coexist on the same server peacefully?
All, Dumb question and i should know the answer - can you have multiple DBMSes running at the same time on the same server? (I would think yes with possibly the proviso that they are listening on different ports?) I'm doing a project for someone who has a co-located windows box that runs multiple sites using IIS and MSSQL but we're looking at installing a new web app that requires mySQL. Can we keep the existing site on the IIS+MSSQL and have it peacefully coexist with IIS+mySQL? Any help would be appreciated Jeff /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
