androidbruce | seattlegaucho, are you a mysql guru? | 05:14 |
---|---|---|
valorie | he is! | 05:16 |
androidbruce | well then he and I need to talk | 05:18 |
valorie | he's been scarce | 05:19 |
valorie | I've been wishing he was in #amarok more too, but I see him rarely | 05:20 |
androidbruce | yeah, gotcha | 05:20 |
androidbruce | did you see that 11.04 is using banshee as it's default player instead of rhythmbox | 05:20 |
androidbruce | that makes me a sad panda | 05:20 |
valorie | eh | 05:21 |
valorie | amarok uber alles | 05:21 |
valorie | lol | 05:21 |
androidbruce | hahah yeah | 05:24 |
androidbruce | i'm running it now in a vm | 05:25 |
valorie | \o/ | 05:28 |
androidbruce | seattlegaucho: you around | 17:22 |
seattlegaucho | androidbruce: I am now | 18:48 |
androidbruce | seattlegaucho: i am in need of some mysql schooling | 19:01 |
androidbruce | can you provide help/support? | 19:01 |
androidbruce | what's your consultant fee? | 19:01 |
seattlegaucho | no fee, my schedule is busy enough as-is to be able to moonlight :) | 19:01 |
seattlegaucho | however, depending on the extent of what you need I can: a) point you in the right direction as you did when I rooted my G1 | 19:02 |
androidbruce | seattlegaucho: i gotcha. well if you could point me to some cool resources to learn mysql that would be great | 19:02 |
seattlegaucho | b) if you just need a couple of hours, get more involved hands-on and leave at a point from where either you finish it yourself or be back at a) | 19:03 |
seattlegaucho | c) recommed a person and/or company that can help you out | 19:03 |
* seattlegaucho points at himself for a starting point :) | 19:03 | |
seattlegaucho | shoot your first Q or describe your difficulties | 19:04 |
androidbruce | well for starters what is the best way to manage mysql? phpmyadmin? | 19:05 |
androidbruce | also, are most commands performed in mysql, or mysqladmin? | 19:06 |
androidbruce | im in the early stages of creating databases and websites. and i've just been reading and hacking through tutorials. | 19:06 |
seattlegaucho | the prefferred way it 'mysql' ... the CLI utility | 19:23 |
seattlegaucho | if you're more of a GUI guy, try out the latest MySQL Workbench | 19:23 |
seattlegaucho | I never liked phpMyAdmin very much | 19:23 |
seattlegaucho | it's too fat for the little it offers | 19:23 |
androidbruce | seattlegaucho: how would i go about learning to use the CLI utility? | 19:28 |
androidbruce | help and man pages? | 19:28 |
seattlegaucho | you have 2 main resources: a) docs and b) \h on the tool's command line | 19:29 |
androidbruce | here is a softball for ya? what are the uses of mysql and are they're any alternatives? | 19:29 |
seattlegaucho | as in 'mysql' the CLI tool or MySQL the product? | 19:30 |
androidbruce | ummm mysql the product | 19:31 |
androidbruce | then if you could elaborate on the cli vs gui/webinterface | 19:32 |
seattlegaucho | alternatives to MySQL: a) MariaDB is my favorite ... it has all the worthy patches | 19:33 |
seattlegaucho | b) stay MySQL: it's very good at what it does and Oracle is doing a very good job at fixing bugs and keep improving it | 19:34 |
seattlegaucho | mysql CLI offers a flexibility that no other tools comes close | 19:34 |
androidbruce | i have phpmyadmin installed, how would i access that interface on my box? i have apache installed and working | 19:35 |
seattlegaucho | GUI usually tackle the basic stuff, they can't go as deep as the CLI can go | 19:38 |
seattlegaucho | it probably has a URL or a HTTP port | 19:39 |
androidbruce | yeah, i'm wondering where that config might be, guess i need to rtfm | 19:39 |
seattlegaucho | http://localhost:xxx/ would be my first guess (don't know what xxx value is) as with samba, cups, etc | 19:39 |
androidbruce | got it | 19:39 |
androidbruce | it's localhost/phpmyadmin by default | 19:40 |
seattlegaucho | that'd would've been my 2nd gues | 19:40 |
seattlegaucho | *guess | 19:40 |
seattlegaucho | however, once you get familiar with the CLI ... it's what everybody uses for admin | 19:40 |
androidbruce | so i can create databases, and have cms's use those db's that i've created in mysql | 19:40 |
androidbruce | gotcha | 19:40 |
seattlegaucho | yep | 19:40 |
seattlegaucho | every app has it's own ways of dealing with it | 19:41 |
androidbruce | what is a collation exactly? | 19:41 |
seattlegaucho | how you sort | 19:41 |
seattlegaucho | different alphabets use different ordering criteria ... 90% of the times, you shouldn't worry about that | 19:42 |
androidbruce | ahhh gotcha | 19:42 |
androidbruce | can you have a mysql server in a different location than the webserver? | 19:42 |
seattlegaucho | for low volume data not necessarily, for medium to big data: mysql server should run on it's own | 19:43 |
seattlegaucho | keep in mind that memory is more important than cores | 19:43 |
androidbruce | space? | 19:43 |
seattlegaucho | depends on data volume | 19:43 |
androidbruce | how much 'storage' should one allocated? | 19:43 |
seattlegaucho | *don't* use regular NFS | 19:43 |
seattlegaucho | we DB running with 1~2 GB and others with 600GB | 19:44 |
androidbruce | ahh ok | 19:44 |
androidbruce | don't use regular NFS? what do you reccommend? | 19:44 |
seattlegaucho | if you run it off a VM *never* run data and/or logs off a virtual disk | 19:44 |
seattlegaucho | either local storage or a good SAN | 19:44 |
androidbruce | ahhh dude to corruption? | 19:45 |
androidbruce | due** | 19:45 |
seattlegaucho | yep ... LVM degrades performance up to a 20% ... maybe more, maybe less depending on actual load | 19:45 |
seattlegaucho | many people swear that XFS is better than ext3/4 for data | 19:45 |
seattlegaucho | again ... depends on data traffic | 19:46 |
seattlegaucho | if you use KVM for virtualization, go with *raw disk* for data and map it to an actual partition on disk | 19:46 |
seattlegaucho | ... need to go, be back in ~1hr | 19:46 |
androidbruce | thanks a lot man | 19:52 |
seattlegaucho | androidbruce: I'm back | 20:43 |
androidbruce | seattlegaucho: you rock bro, i owe you a beer | 20:46 |
androidbruce | seattlegaucho: how do i view docs/ help pages again? | 20:46 |
seattlegaucho | we're even ... I'd never had that G1 running if it weren't for you :) | 20:46 |
seattlegaucho | if you're on the 'mysql' CLI ... type \h to get UI help or ... HELP command | 20:46 |
seattlegaucho | the 2nd one points you gives you enough information to not need to remember syntax specifics and ... | 20:47 |
seattlegaucho | the URL to the docs on the web | 20:47 |
seattlegaucho | the one I use the most is: pager | 20:48 |
seattlegaucho | or \p | 20:48 |
seattlegaucho | 'pager less' pipes all the output to 'less' ... you can use more sophistaced pipes | 20:48 |
seattlegaucho | 'pager' returns to use stdout | 20:49 |
seattlegaucho | also, it's awesome to pipe commands through it | 20:49 |
seattlegaucho | are we going to organize something for 11.04 release? | 20:49 |
* seattlegaucho hates .10 releases, they always have something broken | 20:49 | |
seattlegaucho | 10.04 worked great w/ OpenVPN + NetworkManager | 20:50 |
seattlegaucho | 10.10 with exactly the *same* settings, doesn't work | 20:50 |
seattlegaucho | too bad that one of the LTS broadcomm wireless drivers broke and couldn't find a solution | 20:51 |
androidbruce | sorry for no response, day job got me busy seattlegaucho | 21:14 |
seattlegaucho | np | 21:25 |
seattlegaucho | my day job tends to do the same to me :) | 21:25 |
androidbruce | exit | 22:46 |
androidbruce | exit | 22:46 |
androidbruce | seattlegaucho: you there bro | 23:16 |
seattlegaucho | working on an email ... so if you can deal with the pauses ... yes | 23:16 |
androidbruce | seattlegaucho: if you were starting on a fresh machine, how would you go about getting mysql installed? | 23:30 |
seattlegaucho | for fooling around, go with the packages in teh distros repositories, unless you're in RH | 23:31 |
seattlegaucho | for production, go with the latest package/tarball in the MySQL downloads section | 23:31 |
seattlegaucho | ... today the choice of using 5.1 or 5.5 depends mostly on the app | 23:31 |
seattlegaucho | some bad apps break when using 5.5 | 23:32 |
androidbruce | gotcha. ok how would you go about installing joomla on a fresh machine? install apache2, then mysql? | 23:38 |
androidbruce | i already have it installed and running. but i dunno if i've used the best of methods | 23:40 |
seattlegaucho | hmm ... I'd would've done it the other way around -> infrastructure first | 23:55 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!