| 00:13.05 | *** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 00:13.06 | *** topic/#uphpu is Utah PHP Users Group | uphpu.org | Interested in a PHP course? contact macnewbold |
| 04:24.45 | bigdog_ut | evenin all |
| 04:25.00 | diskotec|w | Hi |
| 04:25.13 | bigdog_ut | whatz up diskotec|w |
| 04:26.15 | diskotec|w | not much....trying to decide whether or not forcefully uninstall a mysql client on my bsd box |
| 04:26.39 | diskotec|w | samba, koffice and kde depend on it for some reason. |
| 04:26.49 | diskotec|w | want to upgrade it to the version 5 client |
| 04:26.57 | bigdog_ut | wow |
| 04:27.03 | bigdog_ut | just do it! |
| 04:27.16 | diskotec|w | hehe...i don't know how to back up in case things fall apart |
| 04:27.27 | bigdog_ut | lol |
| 04:27.27 | diskotec|w | but I guess a reinstall should work |
| 04:27.38 | bigdog_ut | yeah i think so |
| 04:27.42 | diskotec|w | its not like it's a production server |
| 04:27.50 | diskotec|w | just a test box I'm messing around with |
| 04:28.36 | diskotec|w | at one point I got frustrated with bsd and downloaded a gentoo iso |
| 04:28.46 | diskotec|w | put in the cd... |
| 04:28.47 | bigdog_ut | yeah that is what im talking about |
| 04:29.02 | bigdog_ut | gentoo all the way |
| 04:29.12 | diskotec|w | and after it tried to mount the cdrom it froze |
| 04:29.31 | diskotec|w | I have two identicle machines and it froze at the same spot on both |
| 04:29.41 | bigdog_ut | what where you doing? |
| 04:29.42 | diskotec|w | so....I stuck with bsd |
| 04:30.05 | diskotec|w | just got past the boot loader and it froze |
| 04:30.09 | diskotec|w | right at the beginning |
| 04:30.13 | diskotec|w | couldn't do an install |
| 04:30.25 | bigdog_ut | wow...what type of box is it? |
| 04:30.43 | diskotec|w | old box....333 celeron....gateway |
| 04:30.56 | bigdog_ut | it should not have any issues |
| 04:31.10 | bigdog_ut | i have installed it on one of those |
| 04:31.18 | diskotec|w | yeah....but I don't have a 3rd box to try it out on. |
| 04:31.58 | diskotec|w | just doesn't like the cdroms i have....... I guess |
| 04:32.16 | bigdog_ut | i have had that problem too |
| 04:32.23 | bigdog_ut | i just got a new cdrom |
| 04:32.36 | diskotec|w | I even let it sit for about 30 minutes thinking something might be happening in the background....but nothin |
| 04:33.16 | bigdog_ut | i think it has something to do with the drivers for some reason |
| 04:33.19 | diskotec|w | heh....I'm getting used to bsd though....it's kind of painful to work with |
| 04:33.42 | diskotec|w | <------especially for a newbie |
| 04:33.50 | bigdog_ut | i know |
| 04:33.57 | diskotec|w | hehe |
| 04:38.18 | bigdog_ut | you should give gentoo another shot |
| 04:38.31 | bigdog_ut | maybe with another cdrom drive |
| 04:38.36 | diskotec|w | I wish I had a machine to try it out on |
| 04:38.39 | diskotec|w | yeah |
| 04:39.15 | bigdog_ut | yeah i have been using gentoo for years and really enjoy it |
| 04:39.32 | bigdog_ut | but i do give bsd props for its stability |
| 04:39.43 | bigdog_ut | i do have some bsd servers that run great |
| 04:41.01 | diskotec|w | I'll scrounge around our I.S. area for other cdroms |
| 04:41.14 | diskotec|w | I have yet to have a successful gentoo install |
| 04:42.29 | diskotec|w | I tried to install it 9-10 times about 4 years ago on my personal computer I had at the time....kept posting to a gentoo list and trying their suggestions but nothing worked....the last week I tried again on the hardware I just mentioned. |
| 04:43.08 | bigdog_ut | yeah...i have had issues with the cdrom drives you are refering too |
| 04:43.25 | bigdog_ut | i have 3 of those cdrom drives that i like to kick around |
| 04:43.37 | diskotec|w | on my personal computer, I believe there was something wrong with my motherboard |
| 04:43.40 | bigdog_ut | can you pick up another cdrom drive |
| 04:44.05 | bigdog_ut | i know that the livecd is alot better now so you might not have as many issues |
| 04:44.16 | diskotec|w | yeah....I'm going to look around our I.S. area to see what they have |
| 04:46.14 | diskotec|w | they got rid of a whole bunch of these same models so if they have any, it'll probably be the same brand....but nonetheless, they might have other brands. |
| 04:48.09 | bigdog_ut | yeah |
| 04:48.13 | bigdog_ut | where you work at? |
| 04:48.32 | diskotec|w | im in southern colorado....Alamosa |
| 04:48.39 | diskotec|w | I work at the local hospital |
| 04:48.40 | bigdog_ut | oh |
| 07:35.14 | *** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 07:35.14 | *** topic/#uphpu is Utah PHP Users Group | uphpu.org | Interested in a PHP course? contact macnewbold |
| 16:26.19 | *** join/#uphpu _psychic_ (n=_psychic@128.187.170.224) |
| 18:45.25 | mindjuju | you around bigdog |
| 19:22.59 | mindjuju | bigdog_ut |
| 20:41.11 | bigdog_ut | yes |
| 20:41.16 | bigdog_ut | whatz up mindjuju? |
| 20:41.43 | mindjuju | hey was just going to ask you about a database configuration, if you have a moment |
| 20:41.52 | bigdog_ut | yep go ahead |
| 20:42.33 | mindjuju | if you have a master database at a company and you want it to synchro with the database at the webserver, do you do that on the application level or do you do it on the sql server level using replication? |
| 20:43.00 | bigdog_ut | depends on the db |
| 20:43.08 | bigdog_ut | i have done it at 3 levels |
| 20:43.20 | bigdog_ut | application, db triggers, and replication |
| 20:43.39 | mindjuju | well the main database is MS SQL 2k5 |
| 20:43.46 | macnewbold | ewww gross |
| 20:43.51 | macnewbold | ~lart MS SQL |
| 20:43.53 | mindjuju | the web database is the one i was thinking of putting Postgre sql |
| 20:44.10 | bigdog_ut | there are other ways too |
| 20:44.19 | bigdog_ut | like using files and imports/exports |
| 20:44.36 | bigdog_ut | messaging queues too |
| 20:44.43 | mindjuju | i wanted them to be fairly current, like within 5 - 10 minutes |
| 20:44.58 | bigdog_ut | how far apart are they on the network? |
| 20:45.17 | mindjuju | right now, the databases don't talk and don't have anything in common |
| 20:45.35 | mindjuju | except the client names, etc --long story |
| 20:45.38 | mindjuju | wasn't my fault |
| 20:45.48 | bigdog_ut | what databases are you using? |
| 20:45.55 | bigdog_ut | or want to use? |
| 20:46.02 | bigdog_ut | or required to use? |
| 20:46.41 | mindjuju | well, the main database is MS SQL2k5, the webserver is my choice, was thinking postgresql but i have an approved PO for mssql2k5 |
| 20:47.23 | bigdog_ut | will you be moving to pgsql in the future to replace your sql server? |
| 20:48.14 | mindjuju | well, the pgsql option came in because i didn't think ms sql2k5 sounded like a good idea |
| 20:48.49 | mindjuju | does that make sense? |
| 20:48.50 | bigdog_ut | have two different dbs might cause issues with "replication" |
| 20:49.12 | bigdog_ut | meaning you might have issues getting data from "a" to "b" |
| 20:49.25 | mindjuju | right, if on the database layer, but if i have an app do the synchro then shouldn't matter |
| 20:49.43 | mindjuju | though hand writting an app to do the syncrho could be hard, never done it before |
| 20:50.04 | bigdog_ut | it is fairly difficult to get that type of performance |
| 20:50.11 | bigdog_ut | 5 - 10 minute latency |
| 20:50.28 | mindjuju | what is standard latency for this type project? |
| 20:50.29 | bigdog_ut | then you have the issue of network availablity |
| 20:50.54 | bigdog_ut | what happens when one db is down and vice versa |
| 20:51.23 | bigdog_ut | depends really...i have seen second to daily |
| 20:51.59 | mindjuju | good point, hadn't thought of that. i think sql server replication has provisions for that. though i've never done it, and especially over a VPN pipe |
| 20:53.09 | mindjuju | heya macnewbold, for a sec i thought it was bigdog that was larting MS SQL, didn't see your handle. your not usually in on Saturdays, are you? |
| 20:53.20 | bigdog_ut | so it really is subject...you really have to pull the requirements and see what you require |
| 20:54.09 | bigdog_ut | s/subject/subjective/ |
| 20:58.03 | bigdog_ut | so mindjuju is this a one-way replication type situation? |
| 20:58.14 | mindjuju | thanks for the direction. I'll identify the requirements and re-evaluate. Now that i think about it this way, all things being equal, it might be harder to put in provisions for every little thing that may stop the 2 databases from being synchronized and just use the replication that comes with MS SQL which i'm pretty sure has provisions for that type of thing |
| 20:58.20 | mindjuju | 2 way replication |
| 20:58.36 | mindjuju | where the clients can update info on themselves from the web server |
| 20:58.49 | mindjuju | where employees can update info on the client account from the office |
| 20:59.06 | mindjuju | so overlap on several tables |
| 20:59.10 | bigdog_ut | why cant you have a central db? |
| 20:59.34 | bigdog_ut | both servers use the same db? |
| 21:00.04 | mindjuju | because the web server and the database aren't at the same location, web server is colo |
| 21:01.12 | bigdog_ut | if they are that far apart you might have issues...i know that oracle has issues with its replication across the network it is very slow |
| 21:01.23 | bigdog_ut | mssql might have the same issue |
| 21:01.37 | bigdog_ut | for that fact all might have the same issue |
| 21:01.53 | bigdog_ut | all dbs mind you |
| 21:02.20 | mindjuju | yeah, was thinking Oracle as being the absolute best DB, so if Oracle has that prob, then 90% likely that MS would too |
| 21:02.29 | bigdog_ut | we looked at various solutions so let me know if you have questions, we actually went with a queuing system |
| 21:03.01 | bigdog_ut | that uses stored procedures to do replication |
| 21:03.06 | bigdog_ut | and staging tables |
| 21:05.26 | mindjuju | thnx for the info |
| 21:05.44 | mindjuju | what you listening to over there? want some breakbeats or other good techno? |
| 21:05.56 | bigdog_ut | heck no |
| 21:06.02 | bigdog_ut | i got some metal going |
| 21:53.55 | *** join/#uphpu el_gaucho (n=bigdog@207.135.132.13) |
| 21:53.55 | *** mode/#uphpu [+o el_gaucho] by ChanServ |
| 22:56.00 | *** join/#uphpu mindjuju (n=Administ@216.20.238.225) [NETSPLIT VICTIM] |
| 22:56.00 | *** join/#uphpu diskotec|w (n=UN@12.125.156.114) [NETSPLIT VICTIM] |
| 23:02.45 | *** join/#uphpu ChanServ (ChanServ@services.) |
| 23:02.45 | *** join/#uphpu com4 (i=com4@antitech.xmission.com) [NETSPLIT VICTIM] |
| 23:02.45 | *** join/#uphpu macnewbold (n=mac@69.2.248.251) [NETSPLIT VICTIM] |
| 23:02.45 | *** mode/#uphpu [+oo ChanServ macnewbold] by irc.freenode.net |
| 23:22.59 | *** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 23:22.59 | *** topic/#uphpu is Utah PHP Users Group | uphpu.org | Interested in a PHP course? contact macnewbold |
| 23:28.11 | bigdog_ut | all hail the bigdog_ut |
| 23:48.12 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |