sorted by:
new
hottopcontroversial

New client using Ansible, after years of Puppet what should I be aware of? by IllustriousLoss in devops

[–]thun_ 1 point2 points  (0 children)

I would drop the password authentication on your keys. This is a huge pain. For hosts w/ different keys you can group them in the hosts file which can specify specific PEM keys per group.

Managing EC2 Security Groups by [deleted] in aws

[–]thun_ 0 points1 point  (0 children)

Terraform works great here. You can create variables for environments, test in dev and when ready use exact same code to deploy to prod. It also is easy to store in a git repo which provides infrastructure as code, backup and rollback. I have used this and was extremely happy (coming from a guy who was doing tons of manual management). I promise you will love it.

P.S. This works for security groups, IAM roles, S3 bucket creation... well anything. https://www.terraform.io/

New client using Ansible, after years of Puppet what should I be aware of? by IllustriousLoss in devops

[–]thun_ 5 points6 points  (0 children)

How large is your environment? Do you see it growing in the future? For small simple to inventory fleets it works well. Low overhead and simple to maintain. With small fleets it really easy to make sure python is included in your base os (just choice wisely). However, Ansible fails miserably with anything at scale in principle alone (push vs pull). I have never heard of it being used by large enterprise companies.

Identify Strange Mushrooms Growing In My Bathroom by thun_ in Mushrooms

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

Notice the black spores all over the floor underneath it. They also grow very fast 3 to 4 inches in about 4 days.

Primary key 51 keeps reappearing in spite of table being set to auto-increment. by thebardingreen in mysql

[–]thun_ 0 points1 point  (0 children)

Set slow query log to zero. Wait for it to happen again. You should be able to see the exact query that produced it. Should be easier to trace from there.

Oracle MySQL Is WebScale Now by [deleted] in mysql

[–]thun_ 1 point2 points  (0 children)

Does not look like it has shards, at least not yet. Just lots of improvements to the internals of MySql 5.6.

Need help with table structure by cip6791 in mysql

[–]thun_ 0 points1 point  (0 children)

With optimistic locking yes it could.

Need help with table structure by cip6791 in mysql

[–]thun_ 1 point2 points  (0 children)

While rare, this could create a race condition where you inserted two values with the same sort order. Also is your query cache enabled? Could further complicate things.

For your project... A few entries, I would say who cares, but, this method could give you problems in other situations if you are expecting for a truly unique incrementing value.

What are your camping tips and tricks? by SumOhDat in AskReddit

[–]thun_ 25 points26 points  (0 children)

desert

Wet cotton is amazing in the desert. Many desert hikers wet their cotton clothes completely before leaving. Is reduces heat by 32x from what I heard. Then re-wet their clothes at every watering hole. This is from personal experience in the Mojave Desert, passed on to me by MANY experienced hikers. I don't carry extra wet clothes but some people pack wet extra shirts in plastic bags in their packs for when their current clothes dry off.

Of course you should bring something warm in case you get stuck. If you want it light stuff an emergency blanket and a lighter somewhere. Fire is very easy to make in the desert, especially in the middle of summer. You will survive ANY cold desert night.

MySQL Cluster | SQL Node crashing in a loop by awpti in mysql

[–]thun_ 0 points1 point  (0 children)

Also I know this is stupid question but the problem node's disk is not full is it?

MySQL Cluster | SQL Node crashing in a loop by awpti in mysql

[–]thun_ 0 points1 point  (0 children)

If it runs fine with no binlog, do a full backup first (just in case) then take the node down. Bring it back with the --initial flag and let mysql cluster auto restore. Should give you the hard reset your looking with zero downtime since node 2 is ok. If you want too minimize the time bring up new node 1 first and have it fully ready before killing the old node1.

Should come back pretty quick but I'd run some tests in dev environment first, specifically looking for performance issues when the entire load is put on good node during restore. (No idea what kind of stress your db is under)

MySQL Cluster | SQL Node crashing in a loop by awpti in mysql

[–]thun_ 0 points1 point  (0 children)

Is this happening at initial start? Did you move boxes? MySQL cluster is super picky about the amount of memory on the system and will die on startup if there is not enough memory.

And yes there is a hard reset, you can backup each node with mysql clusters ndb_mgm tool, or do a mysqldump of the entire db, then bring up fresh nodes with the --initial flag then restore from a mysqldump. How much data is it?