2,219 reputation
11017
bio website bronosky.com
location Atlanta, GA
age 35
visits member for 5 years, 4 months
seen Sep 16 at 20:57

Mobile Solutions Architect, Cox Media Group Technology

I'm on LinkedIn, Facebook, Twitter

NOTE TO ALL: Everyone should have some form of contact info in their profiles. If nothing else, it is respectful to the people who answer your questions to allow them to tweet you to say, "I gave you a rock'n answer a few weeks ago, but you haven't given any feedback. Did it work for you?" or "Hey there are comments on your question asking for more details, but you are not giving us what we need to help you properly."


Jun
22
comment Is it time to upgrade production MySQL 5.0 servers to 5.1?
We have ~25 apps on the 3 platforms mentioned. Nearly all of them see new releases at least every 3 weeks. Most of them several times a week, and a few several times a day during sprints. I think the developers could weed out anything on the dev/staging env. Since they all use ORM's I can't imagine any issues. Better query optimization, and index selection are only behavior changes I foresee in the handling of the kind of SQL generated by these ORM's. I'm more concerned with: Has MySQL 5.1 proven itself yet?
Jun
22
asked Is it time to upgrade production MySQL 5.0 servers to 5.1?
Jun
20
answered Optimize apache/php/mysql running on VPS for heavy load
Jun
20
answered Fastest way to move MySQL database to a new system while minimizing downtime?
Jun
16
answered vim re-edit as root
Jun
16
comment vim re-edit as root
@dbr, I think it is worth mentioning that after you overwrite the file (with tee as sudo), you will get prompted with [O]k or [L]oad. The later option will erase your undo history an reset the "modified flag" allowing you to exit without being warned to save changes. The former option, which I prefer, will preserve your undo history, but will cause you to get warned when you try to quit. You have to use :q! to quit in this case. I do this so I can validate (e.g. :!sudo /etc/init.d/httpd configtest) and rollback/reedit if I need to.
Jun
16
comment vim re-edit as root
@rkthkr, if "vim restarted and run as root" you would be unable to save any edits you have made, and lose your undo history. But if that is what you want... [Ran out of characters.] See the "answer" I'm about to write.
Jun
16
awarded  Commentator
Jun
15
comment How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
This looks like a very cool plugin. From what I can tell it modifies that file, rather than simply presenting it in a special way. Thank you for the lead. I will use this plugin for some things, but I cannot use it for my DNS zone files. The admin would flip out (and rightfully so) if I alter every line of every file I touch.
Jun
15
answered Is there any reason to use 64bit MySQL (and OS) on small databases?
Jun
15
comment Is there any reason to use 64bit MySQL (and OS) on small databases?
How big do you expect your dataset to grow to? Disk space and/or number of rows is what I am asking for.
Jun
15
asked How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
Jun
13
comment How can I export the privileges from MySQL and then import to a new server?
Great info in that link, thanks. Bookmarked.
Jun
13
answered Permanent SSH Connection via Bash Script?
Jun
13
awarded  Critic
Jun
13
comment How can I export the privileges from MySQL and then import to a new server?
Merging into a existing mysql schema, data extracted from a mysql schema via mysqldump is almost certain to be problematic. You are manipulating a complex schema with enforced relationships, etc. This schema is so complex, in fact, that they created dedicated SQL syntax (GRANT, REVOKE, DROP USER, etc.) for dealing with it. Your extract, however, consists of only INSERT statements. I'm running out of characters here. Need I continue?
Jun
12
answered Visualization Tools for Web App and Database Servers Performance Monitoring
Jun
12
comment Transferring data between SQL Server and MySQL
I spent months with our MSSQL and SSIS guys trying to get various "connectors" to allow MS to insert/update data on my MySQL servers. We got a lot of implementations functioning, but none were production-safe. I had one of my Python developers right a command line app that uses the pymssql and MySQLdb libraries. It is fast and reliable (cron-safe in production). We haven't FOSS'ed it yet because every now and then we find a datatype that needs mapping. We make all of our offerings under the MIT license. Are you interested? I can introduce it as a 0.x release.
Jun
12
comment How can I lauch a GNU screen from jailshell (no pty)
No offense, but I hope there is something you guys are overlooking. I'm going to leave this open a little longer. What I have is a working terminal (ssh connection), but I have a limited (possibly chrooted) shell.
Jun
12
answered Using MySQL replication to enable a read-only copy of a database in a DMZ