Nuffing.com

Many thanks to everyone who registered and/or participated in Tuesday’s webinar on backup strategies and best practices for MySQL, MariaDB and Galera clusters led by Krzysztof Książek, Senior Support Engineer at Severalnines. If you missed the session, would like to watch it again or browse through the slides, they’re now online for viewing. Also check out the transcript of the Q&A session below.

Watch the webinar replay

Whether you’re a SysAdmin, DBA or DevOps professional operating MySQL, MariaDB or Galera clusters in production, you should make sure that your backups are scheduled, executed and regularly tested. Krzysztof shared some of his key best practice tips & tricks yesterday on how to do just that; including a live demo with ClusterControl. In short, this webinar replay shows you the pros and cons of different backup options and helps you pick the one that goes best with your environment.

Happy backuping!

Questions & Answers

Q. Can we control I/O while taking the backups with mysqldump and mysqldumper (I’ve used nice before, but it wasn’t helpful).

A. Theoretically it might be possible, although we haven’t really tested that. If you really want to apply some throttling then you may want to look into cgroups – it should help you to throttle I/O activity on a per-process basis.

Q. Can we take mydumper with ClusterControl and is ClusterControl is free software?

A. We don’t currently support it, but you can always use it manually; ClusterControl doesn’t prevent you from using this tool. There is a free community version of ClusterControl, yes, though its backup features are part of the commercial version. With the free community version you can deploy and monitor your database (clusters) as well as develop your own custom database advisors. You also have a one-month trial period that gives you access to all of ClusterControl’s features. You can find all the feature details here: http://ift.tt/2qeERU7

Q. Can xtrabackup work with data-at-rest encryption?

A. It can work with encrypted data in MySQL or Percona Server – it is because they encrypt only tablespaces, which xtrabackup just copies – it doesn’t have to access contents of tablespaces. MariaDB encrypts not only tablespaces but also, for example, InnoDB redo logs, which have to be accessed by xtrabackup – therefore xtrabackup cannot work with data-at-rest encryption as implemented in MariaDB. Because of this MariaDB Corporation forked xtrabackup into MariaDB Backup. This tool supports encryption done by MariaDB.

Q. Can you use mydumper for point-in-time recovery?

A. Yes, it is possible. mydumper can store GTID data so you can identify last applied transaction and use it as a starting position for processing binary logs.

Q. Is it a problem if we use binary logs with xtrabackup with start-datetime and end-datetime instead of start-position and end-position? We make a full backup on Fridays and every other day an incremental backup. When we need to recover we take the last full and all incremental backups and the binary logs from this day starting from 00:00 to NOW … could there be a problem with apply-log?

A. In general, you should not use –start-datetime or –end-datetime when you want to reply binary log on the database. It’s not granular enough – it has a resolution of one second and there could be many transactions that happened during that second. You can use it to minimize timeframe to look for manually, but that’s all. If you want to replay binary logs, you should use –start-position and –end-position. Only this will precisely define from which event you will replay binlogs and on which event it’ll end up.

Q. Should I run the dump software on load balancer or one of the MySQL nodes?

A. Typically you’ll use it on MySQL nodes. Some of the tools can only do just that. For example, Xtrabackup – you have to run it locally, on the database host. You can stream output to another location, but it has to be started locally.

Q. Can we take partial backups with ClusterControl? And if yes, how can we restore a backup on a running instance?

A. Yes, you can take a partial backup using ClusterControl (you can backup separate schema using xtrabackup) but, as of now, you cannot restore a partial backup on a running instance. This is caused by the fact that the schema you’d recover will not be consistent with the rest of the cluster. To make it consistent, the cluster has to be bootstrapped from the node on which you restore a backup. So, technically, the node runs all the time but it’s a fairly heavy and invasive operation. This will change in the next version of ClusterControl in which you’d be able to restore backups on a separate host. From that host you could then dump contents of a restored schema using mysqldump (or mydumper) and restore it on a production cluster.

Q. Can you please share the mysqldumper command?

A. It’s rather hard to answer this question without doing copy and paste from the documentation, so we think it will be the best if we’d point you to the documentation: http://ift.tt/2rkeP32

Watch the webinar replay

Related whitepaper

 

The DevOps Guide to Database Backups for MySQL and MariaDB

This whitepaper discusses the two most popular backup utilities available for MySQL and MariaDB, namely mysqldump and Percona XtraBackup.

Download

via Planet MySQL
Watch the tutorial: backup best practices for MySQL, MariaDB and Galera Cluster

We are getting reports of an active shooter situation at Travis Air Base base just outside Fairfield, California.

Officials at the base posted the following statement on the Travis AFB Facebook page just before 3:30 p.m.:

“Travis Air Force Base is currently responding to a security incident,” Fairfield Police Department said this afternoon. “More details will be released as they become available. The public is being asked to stay away from the base to ensure emergency responders can respond accordingly.”

Travis AFB had been conducting exercise drills earlier today, but officials at the base have confirmed this is a “real world security incident,” not a drill.

Security alert @Travis60AMW. Shelter in place. Lock doors/windows. Await further info. Follow Travis Facebook page for updates.

— Travis AFB Official (@Travis60AMW) June 14, 2017

Loudspeaker outside Travis Air Force Base: Real World…LockDown. http://pic.twitter.com/WALDZNTFPs

— stevelarge (@largesteven) June 14, 2017

Witness: Active shooter alert at Travis Air Force Basehttps://t.co/B4XPWVyaba http://pic.twitter.com/ShY8cIyzhG

— CBS Sacramento CBS13 (@CBSSacramento) June 14, 2017

Travis has been involved in a base-wide exercise, but the situation at hand is a real-world alert.

— Travis AFB Official (@Travis60AMW) June 14, 2017

Security Alert Prompts Shelter In Place At Travis Air Force Base – CBS San Francisco https://t.co/NeZL8wYCmo

— Deborah (@deborahjuanita4) June 14, 2017

We will update you on the situation as more information becomes available.

The post BREAKING: Active Shooter Situation on Travis Air Force Base in California appeared first on Bearing Arms.

via Bearing Arms
BREAKING: Active Shooter Situation on Travis Air Force Base in California

via Dilbert
Dilbert 2017-06-14

Link

Big Bada Boom! Eclectic Method’s catchy EDM track is chopped up from sound bites from Luc Besson’s cult classic, and it actually sounds like a track which might have been played in a dance club in the world in which Korben, Leeloo, and Ruby Rhod reside in.

via The Awesomer
The Fifth Element Remix

When the Smith & Wesson M&P22 was rolled out in 2011 many shooters rejoiced that there was a new full size .22 on the market that closely resembled a centerfire handgun. At the time of its introduction, the number of choices in that segment was rather limited. In this episode of TFBTV, Patrick pulls the […]

Read More …

The post Smith & Wesson M&P22 Full Size .22 lr Pistol appeared first on The Firearm Blog.

via The Firearm Blog
Smith & Wesson M&P22 Full Size .22 lr Pistol

Hope you have been following our recent webinars on MySQL, Galera Cluster, AWS monitoring and more.

We are coming up with a webinar series in association with Eric Vanier, a leading MySQL expert consultant. The series will provide a step-by-step process to optimize MySQL database performance.

This webinar series is for everyone who is looking for ways to monitor their MySQL databases, simplify the process to manually analyze queries and achieve faster issue resolution time.

Eric Vanier will focus on key problem areas that are faced by DBAs and Shree will provide a solution-driven demonstration to overcome issues while monitoring the database performance. To make it simple, the series will comprise of three parts:

Part – 1: MySQL Performance Tuning
26 June; 10:00 am Eastern time

Troubleshooting a MySQL server performance problem is often a tedious activity as it’s difficult to figure out where to start and how to cope up with it. In the case of an increase in the volume of data and load on the server, the queries tend to run slower and deadlocks become a frequent occurrence.

In this webinar, you will learn the following:

– 3 different ways to identify slow queries.
– Spot query performance pattern over a particular period.
– Proactive monitoring by setting up server/ tag specific alert.
– Fetching deadlock information.
– Monitor MySQL log files on a remote machine.
– Product comparison between Monyog and MySQL Enterprise Monitor.

Register here

Part – 2: Real-time monitoring and RDS file-based log monitoring
03 July; 10:00 am Eastern time

Many of our customers use Monyog to help monitor data in real-time and find the problematic queries. Moreover, Monyog is the only tool that provides file-based log monitoring for Amazon RDS for MySQL & Aurora on RDS.

In the 2nd part of our webinar series, you will learn the following:

– Analyze queries without slow query file.
– Monitoring queries in real-time.
– Monitor log files for RDS instances.
– Performance overhead caused by Monyog.
– Hardware requirement for Monyog.
– Monyog architecture.

Register here

Part – 3: Achieve faster issue resolution time
10 July; 10:00 am Eastern time

In this final part of the webinar series, we will focus on effective practices of monitoring MySQL databases using Monyog. This will provide as in-depth learning session for making the best of the monitoring tool.

Learn the following in this webinar:

– Using explain plan in Monyog.
– Quickly monitoring database and tables size.
– Create Monyog users with restricted access and privileges.
– Minimize the data generated by Monyog.
– Create aggregated report of the data collected in Monyog.

Register here

If you are not able to attend the webinar live, register anyway and we’ll send you a link to the recording once the webinar session has ended.

The post Webinar series – A step-by-step process to optimize MySQL database performance appeared first on Webyog Blog.

via Planet MySQL
Webinar series – A step-by-step process to optimize MySQL database performance

We’ve all heard ridiculous claims about law enforcement, but this one really takes the cake.

State Representative Minnie Gonzalez (D-Hartford) had quite a bit to say about HB 6663, a Police Accountability Bill she is passionately supporting. Discussing the bill in front of the Connecticut Legislature’s General Assembly, Gonzalez said:

 “This bill is to hold accountable and to stop those cowboys that, because they got a bat and a gun, they think they can go shooting especially young kids in our community. This is not the Wild Wild West. And no consequences. Those cowboys doesn’t belong in the police department. This abuse has got to stop.”

While thousands of Connecticutians have spoken out against Gonzalaz’s ignorant and irresponsible remarks, but one response has gone viral. Marissa Cullen, the wife of a Hartford Police Officer, took the anti-gun liberal to task in an epic smackdown.

In an open letter, Cullen wrote:

To State Representative Minnie Gonzalez:

I am the proud wife of a Hartford Police Officer and Air Force Veteran. The men and women of the Hartford Police Department are some of the finest people I know and have more integrity than you could ever wish to have. They serve their communities with pride, dedication, and distinction. These officers put their lives on the line every single day, for little pay, little recognition, and with very little support from elected politicians. These men and women go into their neighborhoods every day truly trying to make a difference, something you know nothing about.

The comments made by you on June 5, 2017, in defense of Bill HB6663 were appalling, ignorant, and unnecessary. While you stated that you support the HPD and its officers, your statements were a direct contradiction to that. Let me address them one by one.

You stated that the officers were cowboys with guns and bats. I’m not sure I have ever seen them wear cowboy hats or boots to work. I have seen officers on horseback, however, they were not herding cattle. I have seen my husband come home with blood on his boots and tears in his eyes as he has faced some of the most horrific acts humans can do to one another. I’ve watched him on phone calls with other officers, consoling them as they attempted to come to terms with the suicide call, or child abuse case, or the senseless murders that occur all too frequently.

You stated that there are good and bad cops, you are correct. There are far more good ones than bad, which is more than I can say for politicians. The vast majority of police officers joined the force to do good, to make a change, and to be positive influences in their communities.

You stated that HPD officers have good pay, good benefits, and a good pension. What you fail to mention is that their good pay comes from countless hours of overtime, or road jobs (which are not paid for by the city, and the city actually makes money off of), you fail to mention the missed birthdays, holidays, anniversaries, and special occasions they have missed in order to protect your ignorance. From my understanding, you get paid a hefty stipend for being an elected official, receive benefits, and will receive a pension.

You stated that “you” pay for the officers’ lunch and dinner. I’m not sure how you determined that, as I send my husband with his meals daily, while he works his 16-hour shifts. He frequently comes home with his meals still in his bag, as they do not get a lunch break, and is often lucky if he can even get a bite in between calls.

You stated that these “cowboys” are killing young kids in our community with no consequences, and this abuse needs to stop. Since 2005 there have been 20 Officer Involved Shootings according to HPD data. That’s one shooting every 219 days by an officer. Considering the amount of public interaction, and the calls for service, this equates to a less than 1% chance of being shot by a police officer in Hartford. The last time a person was killed by a police officer in Hartford was in 2013, a whole 4 years ago, and it was entirely justified. Again, your ignorance is glaring, and your abuse of police officers needs to be stopped.

You stated that you pass laws frequently to protect and train police officers. The training is mandated by the State of CT, and you have done nothing to indemnify or protect officers of your community. In fact, based on your history, I am not even sure how you can remain in office. Your family has been called a “crime syndicate.” You have been found guilty of elections violations, you have the “Minnie Gonzalez Little League,” which receives over $75,000 a year in taxpayer money, and is managed by your husband. In fact, it seems as if you have a significant conflict of interest in presenting or debating any type of law enforcement bill, as taking power away from the police directly benefits you and your family.

It is very easy to sit in your safe office and make ignorant, untrue statements towards our officers. They need your support, not your condemnation. You lack integrity, honesty, and decency. You should take a ride along with a Hartford Police Officer on a Saturday night during the summer, and see what they are exposed to. Have you ever taken simulation training?  I’m sure you would not make accurate split-second decisions that you expect from our officers. You truly should be ashamed of your statements against HPD and in fact, should issue a very public apology for condemning them in the way you did.

Sincerely,

Marissa Cullen
The Wife Of A Hartford Police Officer

P.S.: Here is the link to your inaccurate, cowardly statements, to refresh your memory:

The post Wife of Hartford, CT Police Officer Destroys Anti-Gun Politician in Scathing Letter appeared first on Bearing Arms.

via Bearing Arms
Wife of Hartford, CT Police Officer Destroys Anti-Gun Politician in Scathing Letter

I really enjoyed this video, which shows us how CCI 22 rimfire ammo is made in CCI’s factory.

To begin, circles are punched out of sheet brass and cold-formed into small brass cups. Then to relieve the stress of the cold forming process, they are annealed. After a wash and dry, a drawing process reduces diameter and increases length.

The cup on the left is formed in the first step. The one on the right is ready to go into the header.

Next comes another wash & dry before hitting the header. The header is so named because it forms the case head — the part with the rim. It also adds the head stamp, which in this case is the C for CCI.

A surprisingly non-automated step comes next, in which the brass cases are placed into plates so they can be primed.

In rimfire ammo, priming compound is placed into the inside of the case head and made to flow into the rim from the inside. Then a firing pin strike can pinch the brass rim to ignite the priming mix and thus ignite the powder charge.

After priming, the case is of course charged with powder and a bullet is seated into it. Next comes the crimp, which tightens the case mouth so that it will hold onto the bullet properly. After that, the ammo can be sorted into trays and the bullets waxed, then it’s boxed (and presumably sent to Wal-Mart where one person will buy it all and cram it into a dank corner of his basement until the world ends).

Lead billets ready to be turned into bullets.

Next, we see how they make their bullets. The amount of lead the factory consumes in a day is tremendous, and the process of turning it into bullets is interesting. It’s molten and cast into large cylindrical six-inch-diameter 300-pound billets, which are then shoved through a press to form wire, which is then cut into slugs.

Reduced to small-diameter lead wire, the lead is then cut into slugs.

Each slug can then be formed into an actual bullet.

A slug next to a formed bullet.

Bullets are then coated with black lead or plated with copper before being loaded into ammo.

I like it.

The post Watch: How is 22 Rimfire Ammo Made? appeared first on AllOutdoor.com.

via All Outdoor
Watch: How is 22 Rimfire Ammo Made?

HTTPS is a must for every website nowadays: Users are looking for the padlock when providing their details; Chrome and Firefox explicitly mark websites that provide forms on pages without HTTPS as being non-secure; it is an SEO ranking factor; and it has a serious impact on privacy in general.

Additionally, there is now more than one option to get an HTTPS certificate for free, so switching to HTTPS is only a matter of will.

The post A Complete Guide To Switching From HTTP To HTTPS appeared first on Smashing Magazine.

via Smashing Magazine
A Complete Guide To Switching From HTTP To HTTPS

via DIYPhotography.net – Photography and Studio Lighting – Do It Yourself
Learn how to colorize black and white photos in only 4 minutes