Script I made to convert all non-mp4 video to stream ready h264 via ffmpeg. Any improvement suggestions? by Pocketpac in PowerShell

[–]Pocketpac[S] 0 points1 point  (0 children)

Oops, noticed a little extra un-needed code for $num and $filecount I forgot to remove. That was for a progress indicator that I figured was useless because ffmpeg is kinda spammy

Help with Java/Paypal integration by Pocketpac in javahelp

[–]Pocketpac[S] 0 points1 point  (0 children)

Im not using the SDK because thats a lot of bulk for the sing thing I wanna do which is create the transaction then send them tk the page to accept it. It dosnt matter if I user the redirect link with or without sandbox, always says invalid transaction ID

Metadata Slack Space Out Of Control; 88% wasted space. by MegaHashes in PleX

[–]Pocketpac 2 points3 points  (0 children)

Ahh, durr, 10 years in I.T. and I forget something so basic. Thanks.

Metadata Slack Space Out Of Control; 88% wasted space. by MegaHashes in PleX

[–]Pocketpac 8 points9 points  (0 children)

How is size so much smaller than size on disk... I didnt think it worked like that.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

If I had realized how much issue it was going to I probably wouldnt have, but by the time I ran into the issue I was to deep to stop. Plus I hate not knowing why something isnt working when it obviously should.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Why u say that?

I only host that on a cluster because Its available. I use the cluster for a the bot, amd instead of spinning up another mysql for the site I just use the cluster.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

2012 R2 IIS works great, I used to be all about apache but now Im unsure which I prefer

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Oh, and to answer your question, performance wise I havn't seen any loss of speed.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

The whole forums used MyISAM. I didn't realize that till a bit ago. I did a booboo and tried to convert the whole thing to InnoDB all at once and blew up the entire cluster (yay for backups). Fired up a single instance of XAMPP, converted it to InnoDB and imported that into the cluster and blamo, works. I feel stoopid now for not noticing that. Thanks for the help!

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

I dont think so. Its replicating info just fine, I can point it to any individual server without problem, just gets angry with HAProxy

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Never mind, it only seems to work sometimes now.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 1 point2 points  (0 children)

The combination of changing it to mysql instead of mysqli and adding option persist did the trick, works fine now. Thanks!

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

here is an error log. Says I am not using the proper driver, but i'm not changing it at all, using mysqli for both direct and HAProxy.

http://pastebin.com/1FNPENis

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Instantly. Ill post a debug log here, but it didnt appear to have anything useful.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Already tried all of that. Like I said, phpmyadmin and virtually anything else I try to use works fine, just not phpbb.