April 2007 - WLUG - wlug.mailman3.com

MySQL Server Hardware

by joel d

I'll take a stab at this one. At work our MySQL database contains product info and indexing data. The reasoning for designing and taking this outside of the business application is the business app. doesn't do web communication well (limited functionality and at times spotty app reliability). The business app doesn't matter (and I bet no one has heard of it anyway). Our design spec was hearty at a HP DL 385 with dual AMD CPUs (dual core I think) 5GB of RAM and around 7 internal 15k drives in RAID 5. Every bit of hardware is HP/Compaq. Without starting a distro thread we picked Red Hat AS V4. This combo has served us well and I am sure *many* other distros would do this at least as well. For us our biggest corporate reason for R.H. was most of our application vendors suported R.H in one way or another (a vote for getting good at only one skillset/distro). During application & DB development we considered uptime and ordered a second identical box mainly for a total server failure of any sort. They run very well as MySQL master and slave. In the year it has been up we are very happy with this combination. Feel free to forward any specific questions (direct or via the group). Hope this helps, Joel ============================= Date: Tue, 24 Apr 2007 14:59:55 -0400 From: "John Westcott, IV" <John.Westcott(a)tufts.edu> Subject: [Wlug] MySQL Server Hardware To: wlug(a)mail.wlug.org Message-ID: <20070424145955.3hftuclhdwg0ck4s(a)webmail.tufts.edu> Content-Type: text/plain; charset=ISO-8859-1; format="flowed" Howdy All, I work in a place that has traditionally used Sun Sparc hardware running Solaris to host a production MySQL environment. We are going to be replacing our database servers this year and I am trying to determine if I want to maintain the norm or if I want to try to change. I am interested to see what other people use for hardware/OS for a production MySQL installation that requires a high amount of uptime. Thanks in advance for any replies. -John Westcott

April 27, 2007

Re: [Wlug] MySQL Server Hardware

by Tal Cohen

We use the Crux Linux distribution with MySQL. Our production systems handle high volumes of traffic and database transactions...without incident (unless the hardware fails as I mentioned in a previous post). Tal -----Original Message----- From: wlug-bounces(a)mail.wlug.org [mailto:wlug-bounces@mail.wlug.org] On Behalf Of John Westcott, IV Sent: Tuesday, April 24, 2007 3:00 PM To: wlug(a)mail.wlug.org Subject: [Wlug] MySQL Server Hardware Howdy All, I work in a place that has traditionally used Sun Sparc hardware running Solaris to host a production MySQL environment. We are going to be replacing our database servers this year and I am trying to determine if I want to maintain the norm or if I want to try to change. I am interested to see what other people use for hardware/OS for a production MySQL installation that requires a high amount of uptime. Thanks in advance for any replies. -John Westcott _______________________________________________ Wlug mailing list Wlug(a)mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug

April 26, 2007

PGP Key Signing Party

by Eric Martin

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This upcoming meeting we are going to have a PGP Key Signing Party. For those of you who don't know what PGP is, allow me to briefly explain. This is all base off of the GPG Key Signing HOWTO (http://www.rubin.ch/pgp/kspa/gpg-party.en.html) which I suggest for further reading. Those who do know can feel free to skip down to the next paragraph. PGP stands for Pretty Good Privacy, and is a Public Key Infrastructure that allows us to communicate securely and deal with data in a secure fashion. There is a public key that one would typically upload to a server and a private key that you hold on to. With the private key you can decrypt / sign, and with the public key you can encrypt / verify emails and documents. Key signatures come into play when you validate that a specific key belongs to a specific person and extend the web of trust. Here's what needs to be done BEFORE the meeting on your computer, or on a secure terminal (e.g. not in a computer lab on your campus). I'll post directions both for GPG (Gnu Privacy Guard) and Kgpg (the KDE front - -end to gpg for all of those who like GUIs). 1. Generate a Key Pair / Verify your key won't expire soon gpg --gen-key (Default values of DSA/Elgamal is fine and the default of 2048 is good.) I recommend 3 - 5 years for a key lifespan (how long the key will be good for) 1a) for those of you wishing to use Kgpg, goto Keys -> Generate Key Pair and fill in the dialog box Once you create the New key pair, check the Save As box under _Revocation Certificate_ to save a Revocation Certificate (see 2) 1c) For those of you who already have a key, make sure yours isn't about to expire (like mine did). If it has expired, you can extend the life by $ gpg --edit-key <key-id> and typing expire at the command prompt next, generate a new key-pair and sign your new key with your old key so anyone who trusted your old one will trust the new one. 2) Generate a revocation certificate Revocation certificates are for situations where you forget your passphrase, the key becomes comprised, etc you can revoke your key. $ gpg --output revoke.asc --gen-revoke <key-id> Save this in multiple places, print a copy etc in case you need it. 2GUI) If you didn't create a revocation cert in Kgpg, just right click on your new key and select Revoke Key. when the box pops up only check Save As 3) Upload your key to the Designated server for this party (pgp.mit.edu) $ gpg --send-key --keyserver=pgp.mit.edu <key-id> 3GUI) Right Click on the Key, select Export Public Keys, select Default Key Server (make sure it's pgp.mit.edu under Settings) 4) Email me your key's fingerprint so I can add it to the list $ gpg --fingerprint <key-id> Copy and Paste that into an email to the coordinator (me, Eric Martin). 5) print out a copy of that same output and bring it to the meeting. I'll make up a check list and bring them to the meeting for everyone to use. Example output from Step 4: pub 1024D/A9413B9F 2007-04-09 [expires: 2010-04-08] Key fingerprint = D1C4 086E DBB5 C18E 6FDA B215 6A25 7174 A941 3B9F uid Eric J. Martin <eric.joshua.martin(a)gmail.com> uid Eric J. Martin <freak4uxxx(a)gmail.com> sub 2048g/01F81B8E 2007-04-09 [expires: 2010-04-08] my <key-id> is A9413B9F (which is always the same as my last 8 hex digits of my fingerprint). If like me you don't always remember your key-id you can use your email address and it will still work. My full key information is: Key ID: A9413B9F Key Type: DSA Hex Fingerprint: D1C4 086E DBB5 C18E 6FDA B215 6A25 7174 A941 3B9F Key Size: 1024 (The DSA key is always 1024 bits. The ElGamal Encryption key is 2048 bits in my case, but isn't needed for the keysigning party.) What you should bring to this party 1. Yourself, no exceptions 2. Two forms of positive photo ID - driver's license and passport are good 3. Key Id, Key Type, Hex Fingerprint and Key size info ***Please print out your own copy of your info to compare against mine when you arrive *** 4. Pen / Pencil What you Should Not Bring 1. Computer I want to thank Chuck Anderson for helping me out. If you have any questions please let me know. Eric -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGMBvKaiVxdKlBO58RAsCVAJ9cA488l+SybdxD+rgqNWGi/U9tUQCeMvH8 UAhMTFVRG5SbVVn5jqbVwqg= =BSzn -----END PGP SIGNATURE-----

April 26, 2007

I'd like to see Windows do this....

by Tal Cohen

Hi Folks, I recently ran across an interesting situation that I wanted to share this group. A customer of ours called us, letting us know that our server in their data center was beeping. We tried to ssh into the box, but kept getting connection refused. I asked the customer to hook up a monitor and keyboard to the box, and try a simple TTY. Sure enough, he was unable to log in. It turns out that the hard drive that holds the OS (Crux Linux) failed. Now, that in and of itself is not very interesting. What is interesting is that our software kept running even without the OS drive functioning. Our software resides on a separate drive. Since it was already loaded into memory and almost never needs to touch the OS drive, it just kept going.and going..and going.. Tal

April 25, 2007

MySQL Server Hardware

by John Westcott, IV

Howdy All, I work in a place that has traditionally used Sun Sparc hardware running Solaris to host a production MySQL environment. We are going to be replacing our database servers this year and I am trying to determine if I want to maintain the norm or if I want to try to change. I am interested to see what other people use for hardware/OS for a production MySQL installation that requires a high amount of uptime. Thanks in advance for any replies. -John Westcott

April 24, 2007

2 things

by Mike Leo

We talked about this at one point: http://arstechnica.com/news.ars/post/20070422-child-porn-case-shows-that-an… also.....wlug.org is down?

April 24, 2007

Re: [Wlug] Hauppauge 500 woes

by Mike Perry

Alright. After a lot of tweaking I think I got the settings right and the picture is much better. I had to set the recording resolution to 720x480. I also had to put it to 1% vertical overrun to get rid of a flicker at the top of my screen. I also added their repository so I could get the correct firmware. I've never seen so many options in my life. Those things seems to affect it the greatest. Anyone have any luck with filters? ~Mike On Mon, 2007-04-16 at 13:14 -0400, Mike wrote: > Sorry that email was pretty rushed [because I'm in the office]. Here is > the directions I plan on following tonight: > > https://help.ubuntu.com/community/Install_IVTV_Feisty > > Note the bottom which states "Newer Firmware". > > I'll give it a shot. If that doesn't make a difference I could try the DVD > player idea. Actually I think my VHS player is the only one with an RF > out. > > If the VHS player is fine do you think it is a signaling problem? > > ~Mike > > > <quote who="Mike"> > > Thanks for the advice. I'll try that. > > > > I'm also going to try running through the firmware from the ivtv > > repository that I read on the Ubuntu site. > > > > ~Mike > > > > > > > > > > <quote who="Karl Hiramoto"> > >> Mike wrote: > >>> I've been working on setting up a MythTV box with a Hauppauge 500. The > >>> reception I am getting is a bit grainy. I read that it could be the > >>> firmware, too high of a signal, or too low of a signal. I took care of > >>> the > >>> firmware last night by following the directions on their wiki. The > >>> picture > >>> is still a bit grainy. Before I go out an buy a signal booster I was > >>> wondering if anyone had any ideas or experience with the 500. > >>> > >>> ~Mike > >>> > >> You can try hookup your PVR500 directly to the output of a VCR, or DVD > >> player that has an RF output. > >> > >> Also try having your PVR as the only device in the house hooked to the > >> line, and with no splitters inline. Each device creates load, and your > >> PVR500 is really two devices. > >> > >> If you take a look at the ivtv mailing list archives, you'll find a lot > >> of people with the same issue. > >> > >> -- > >> karl > >> > > > > > > -- > > Emacs would be a far better OS if it shipped with a halfway-decent text > > editor. --Anonymous > > > > > >

April 22, 2007

Re: [Wlug] New ULTRA1 - one step forward, two steps backward....

by Mike Frysinger

On Thursday 19 April 2007, ken jones wrote: > Nevertheless I had a very difficult time with manual configuration of > the kernel. I had not the faintest idea which modules I could ignore > and which I needed to modularize the Gentoo docs dont really go into this sort of detail > Question: is there a log somewhere? I did emerge syslog-ng. syslog-ng is a userspace system logger ... it doesnt log the kernel messages you're looking for > Another question: Where is the detailed documentation on all the modules? it's in the kernel menu itself ... hit "?" when selecting an interesting option > Final question: How do I get a hint at what I did wrong? it may be a lot easier if you start from something known to work ... aka the livecd kernel ... you can copy /proc/config.gz and use that as a starting point for your kernel .config or you could copy the livecd kernel + modules to your root filesystem and use that to boot ... -mike

April 20, 2007

3D support

by dulsi＠identicalsoftware.com

I started looking for a new laptop. I'd like one that can play Neverwinter Nights with open source drivers. Obviously that is a problem since 3D support without the binary drivers is not great. I figured since the game is rather old a good cpu (or two for the duo) and a well supported open source driver (I remember hearing Intel having released an open source driver) that it could run reasonably. I asked some linux laptop vendors and everyone told me that I would need the binary drivers. Are they right and we still can't run a 5 year old game? Am I stuck waiting for nouveau? Dennis Payne dulsi(a)identicalsoftware.com

April 19, 2007

New ULTRA1 - one step forward, two steps backward....

by ken jones

Folks, When the box failed to boot, you might remember, it complained that the kernel was "too old". I remade the box using the newer kernel 2.6.20. I apparently configured the correct silo.conf (there are five of them in there when using the livecd). It looked like it was going to BOOT!! :-) See below..... Trouble is this is as far as it got. I printed and used as reference the Gentoo Linux 2006.1 SPARC Handbook, the Using UTF08 with Gentoo document and the Gentoo Upgrading Guide. Nevertheless I had a very difficult time with manual configuration of the kernel. I had not the faintest idea which modules I could ignore and which I needed to modularize Question: is there a log somewhere? I did emerge syslog-ng. Another question: Where is the detailed documentation on all the modules? Final question: How do I get a hint at what I did wrong? Ken ----------------snip of hyperterminal watching SUN ULTRA boot.------------ Sun Ultra 1 UPA/SBus (UltraSPARC 200MHz), No Keyboard OpenBoot 3.11, 192 MB memory installed, Serial #9633364. Ethernet address 8:0:20:92:fe:54, Host ID: 8092fe54. Initializing Memory \ Initializing Memory \ Initializing Memory \ Initializing Memory - Initializing Memory - Boot device: disk File and args: SILO Version 1.4.13 boot: Allocated 8 Megs of memory at 0x40000000 for kernel Loaded kernel version 2.6.20 Remapping the kernel... done. Booting Linux... -----------------------------------end snip-----------------------------

April 19, 2007