2,319 reputation
21117
bio website bronosky.com
location Atlanta, GA
age 36
visits member for 5 years, 7 months
seen Nov 6 at 22:16

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."


Jul
29
comment How could I stop ssh offering a wrong key?
@AlvaroMaceda is correct. Adding IdentitiesOnly yes to the gitadmin.gammu.com and git.gammu.com Host entries is enough. You don't have to make a wildcard entry that will affect other hosts.
Apr
5
comment What useful things can one add to one's .bashrc?
@Rqomey, the whole point is that I don't have to encrypt my history as my passwords do not show up in my .bash_history because they are hidden by aliases or functions. In it you see things like MYsql < garbagecollect.sql instead of mysql -uadmin -psecret < garbagecollect.sql
Nov
7
comment Approximately how much would it cost to make an AMI image from a EC2 Micro server?
I think you meant: Note that EBS charges per allocated GB, while S3 charges per used GB
Jul
27
comment How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
Actually it's feature request #22 on the list. vim.org/sponsor/vote_results.php
Jul
27
comment How can I lauch a GNU screen from jailshell (no pty)
I did ask for access to bash and was told that it would give me root access and they, of course, can't do that on a shared server. I know that is a load of crap because my day job is as a MySQL DBA, Linux System Administrator, and Manager of a team of Linux System Administrators. I didn't argue because I know that arguing with someone who is willing to lie to you and insult your intelligence... is a fruitless demonstration of your lack of intelligence. What I didn't know is that WHM controls it. I will try to social engineer my way into it. Thanks for the lead.
Jul
23
comment How to export a MySQL DB to MSSQL Database?
Can you assure that there will be no data changes to the MySQL DB for the duration of the export? That opens up a lot of options.
Jul
20
comment MySQL Enterprise backup tool for automation and management
You don't mention: Host OS, MySQL version, storage engines used. You cannot get good advice without sharing those details.
Jul
9
comment Best way to make sure a MySQL database is fully in UTF8
Yeah, you'd need to use something like awk instead of grep. Because I cannot get legible formatting in a comment, I'll post it in another answer.
Jul
9
comment Web server and database server in completely different locations
Local replication is probably the solution for you. If you are able to modify you application to segregate reads (keeping them local) and writes (sending them to the master), then you are in business. If you are able to do this, you should also be able to modify the app to use memcached. If you can't modify the app, then you could use MySQL Proxy to do the segregation.
Jul
9
comment Fast Bulk Import of a Large Dataset into MySQL
info about the data source/format, MySQL version, preferred destination engine, and intended use after load would help us give you an excellent answer.
Jun
29
comment Best way to make sure a MySQL database is fully in UTF8
While I have great respect for bash-fu, these are inappropriate uses. You are obviously skilled and would benefit from getting familiar with dev.mysql.com/doc/refman/5.0/en/information-schema.html and the uber-useful dev.mysql.com/doc/refman/5.0/en/… The GROUP_CONCAT is very useful for generating valid SQL with SQL which is then piped to a secondary mysql call. I demonstrate this here: serverfault.com/questions/8860/…
Jun
25
comment MySQL 5.1.34 on NFS w/NetApp
Please specify which logs you are concerned about separating. I would assume you mean the ib_logfile* and I can understand your concern. If I found that I needed to squeeze out a little extra performance I would still separate it as I said in my answer, and just understand that I will have to recover it from local storage (or where ever) to repair after a crash. However, I see no risk in separating the mysql-bin.* or (shudder) mysqld.log (aka:General Query Log) if you happen to use them. I would strongly advise against the latter.
Jun
25
comment How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
SpoonMeiser is exactly correct.
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
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
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
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
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
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?