Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
2
Newest
 Commentator
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 15 votes cast
Feb
14
comment Monitoring mysql with munin - worse MySQL performance?
I suspect that the statistics in phpmyadmin make phpmyadmin itself that much slower, not so much the server itself. Perhaps someone who uses pma it could weigh on on that, but I doubt there's much correlation between that and any impact from monitoring with munin (which I expect would be negligible).
Feb
9
comment make HAPROXY log to a local file instead of syslog?
I don't think HAProxy can log to a file, and I suspect the reason for this is that writes to disk are a blocking operation. Why do you really not want to use syslog? Config is not all that tricky. You can assign a local facility to HAProxy and configure your syslog daemon to write those entries to a different file, and not to other syslog files (or network streams), if you're not wanting the HAProxy logs not to be mixed in with everything else.
Nov
18
comment Proxy Filtering with Squid
This will depend heavily on the capability of the VPN router, but correctly configured to tunnel all internal traffic to the proxy, yes, it should work.
Oct
27
answered How to load balance mutiport traffic using HAProxy
Oct
13
comment Valid root/user passwords not working on EC2
It sounds as if, in /etc/ssh/sshd_config, you at some point enabled PasswordAuthentication yes and that setting has been changed or commented out, perhaps by the update... but you really should not be allowing password-only authentication.
Oct
13
comment Valid root/user passwords not working on EC2
This page you mentioned has nothing to do with the "root" account on your instances. It is an entirely different and completely unrelated use of the term "root." Similarly, ec2 get-password-data only applies to Windows instances. You shouldn't be able to log in as root. That's normal, unless you explicitly changed it. If you can still log in with your private key, it isn't really clear what problem you are having.
Sep
4
comment How do I find out hard disk model and serial number in amazon machine?
@shas, everything is virtualized in EC2. Perhaps we could help you solve your problem if you would explain why this information would be useful.
Sep
4
comment How do I find out hard disk model and serial number in amazon machine?
Actually @galaxy even the local (ephemeral) hard drives are still virtualized -- they're just local to the host machine instead of network-attached.
Aug
2
awarded  Commentator
Aug
2
comment MySQL won't start at boot with bind-address set to IP
As a DBA, I use custom settings for my MySQL deployments, but my guesses of the most likely places to look would be /var/log/mysql, /var/lib/mysql, or /usr/local/mysql/data. I would expect the error log to be called ${hostname}.err.
Aug
2
comment MySQL won't start at boot with bind-address set to IP
Check the actual mysql error log, rather than syslog. Also, why would you not use the standard value of 0.0.0.0?
Jul
22
comment etc/apt/sources.list contents for EC2 Instances upon AWS
afaik, "who decides" is Ubuntu/Canonical. The images for Ubuntu on EC2 are "official" images. cloud-images.ubuntu.com/releases
Jul
22
comment etc/apt/sources.list contents for EC2 Instances upon AWS
This sounds like it could be something done by cloud-init: help.ubuntu.com/community/CloudInit
Jun
8
comment Route dies on Ubuntu 14.04.2
Is this VPC? This isn't a normal configuration (imho). Normally, a route like this would be set up in the VPC route table, not the instance's route table. Can you provide more information about your setup?
Feb
20
comment bash permissions - unknown problem
Excellent. It's also possible that the drill is not a drill, it's a gun, and that's not the wall, it's your foot.
Sep
26
comment Mysql database didn't connect through sqlyog or any other mysql software?
The number in parentheses at the end of the error (not included in your question) is critical for understanding the specific reason why you can't connect. It may not be "permission" related.
Jul
8
comment mysql restoration process takes longer time
The problem with backing up the datadir is that unless mysqld is stopped when you do so, the best outcome you can hope for is that the server where you restore to will attempt to recover from the crash it will believe occurred previously, because of the inevitable inconsistencies. If the new server version is the same or newer, and the my.cnf is identical in a few important ways, then yes, this works. We use a simiar process, when possible, for cloning replication slaves.
Oct
4
awarded  Supporter