Best places to look for MySQL help
This is not a resource list post. It is actually a question for you: where do you go, when you’re looking for MySQL help?
For the last few months I been feeling an itch – having some MySQL experience, I would really like to spend some time helping people solve their MySQL issues for free. But I’ve been blocked on the fact that I don’t really know what is the best place to do this.
Naturally, first place to look for MySQL help is Google. But what do you do when Mr. Google can’t help? Stackexchange? Quora? Percona forums? Maybe some mailing lists ? Do you just leave comments on blog posts that are somewhat on-topic?
Please leave a comment and/or upvote an existing one.
I really appreciate it.
The post Best places to look for MySQL help appeared first on Speedemy.
Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown
U.S.A. –-(Ammoland.com)- Sturm, Ruger & Co., Inc. (NYSE: RGR) proudly introduces the Silent-SR ISB for the 10/22 Takedown platform. The ISB, or Integrally Suppressed Barrel, is an exciting addition to the Ruger Silent-SR family that delivers quiet and accurate performance in a compact and truly user-serviceable package.
Known for its unrelenting reliability, durability and accuracy, the 10/22 Takedown rifle is the ideal platform for an integral suppressor. The Silent-SR ISB quickly and easily assembles to any Ruger 10/22 Takedown or 22 Charger Takedown, and features an induction-hardened breech with cold hammer-forged barrel that provide easy takedown and accurate return-to-zero – the same elements that have made the 10/22 Takedown an instant classic worthy of its heritage.
Reducing sound pressure levels of .22 LR to an average of 113.2 dB with standard velocity ammunition, a 10/22 Takedown rifle equipped with the Silent-SR ISB is as quiet as a bolt-action rifle with a thread-on silencer. Its compact, 16.12″ barrel length makes the Silent-SR ISB easy to handle, and the relatively long barrel of the Silent-SR ISB (compared to other integral suppressors) means the bullet generates energy near that of a 16″ gun for consistent, accurate and effective performance on target. The pushed-cone baffle geometry has been stretched to utilize the volume under the barrel maximizing suppression of the gunshot without disturbing the travel of the bullet.
Disassembly for cleaning is as simple as separating the barrel from your firearm and loosening the Silent-SR ISB’s single assembly screw using the included 5/32″ hex key tool. Once loose, pull the screw to remove all six 17-4 stainless steel baffles, spacer and front cap free of the sleeve for cleaning. The sealed baffles keep the fouling away from the serialized sleeve, yet easily come apart even after thousands of rounds. Finished with Cerakote, the Silent-SR ISB is engineered and built for a lifetime of hard use without clogged ports, seized components or loss of suppression that often plague other integrally suppressed rimfire barrels.
Suppressed firearms help to preserve our hearing, make verbal communication on the range easier and make shooting more fun. Paired with the Ruger 10/22 Takedown, the Silent-SR ISB makes the perfect training, plinking and small-game hunting platform.
All information, including the press release for these products, can be accessed through the links below:
Ruger Silent-SR ISB Information by AmmoLand Shooting Sports News on Scribd
For more information on the Silent-SR ISB or to learn more about the extensive line of award-winning Ruger firearms, visit www.Ruger.com or http://ift.tt/J2iqf9. To find accessories for Ruger firearms, visit ShopRuger.com or your local independent retailer of Ruger firearms.
This post Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown appeared first on AmmoLand.com Shooting Sports News .
via AmmoLand.com Shooting Sports News
Ruger Introduces An Integrally Suppressed Barrel for the 10/22 Takedown
Percona Live 2017: Lessons Learned While Automating MySQL Deployments in the AWS Cloud
The last day of Percona Live 2017 is still going strong, with talks all the way until 4:00 pm (and closing remarks and a prize giveaway on the main stage then). I’m going to a few more sessions today, including one from Stephane Combaudon from Slice Technologies: Lessons learned while automating MySQL deployments in the AWS Cloud.
In this talk, Stephane discussed how automating deployments is a key success factor in the cloud. It is actually a great way to leverage the flexibility of the cloud. But often while automation is not too difficult for application code, it is much harder for databases. When Slice started automating their MySQL servers at Slice, they chose simple and production-proven components: Chef to deploy files, MHA for high availability and Percona XtraBackup for backups. But they faced several problems very quickly:
- How do you maintain an updated list of MySQL servers in the MHA configuration when servers can be automatically stopped or started?
- How can you coordinate your servers for them to know that they need to be configured as a master or as a replica?
- How do you write complex logic with Chef without being trapped with Chef’s two pass model?
- How can you handle clusters with different MySQL versions, or a single cluster where all members do not use the same MySQL version?
- How can you get reasonable backup and restore time when the dataset is over 1TB and the backups are stored on S3?
This session discussed the errors Slice made, and the solutions they found while tackling MySQL automation.
Stephane was kind enough to let me speak with him after the talk: check it out below:
There are more talks today. Check out Thursday’s schedule here. Don’t forget to attend the Closing Remarks and prize give away at 4:00 pm.
via MySQL Performance Blog
Percona Live 2017: Lessons Learned While Automating MySQL Deployments in the AWS Cloud
Steyr Arms to Unveil the Rimfire Scout RFR at the NRA Annual Meetings
BESSEMER, Ala. -(Ammoland.com)- The Steyr Scout RFR, a blazingly fast straight-pull rifle that emulates the look and feel of the original Steyr Scout Rifle on a rimfire platform, will make its official debut to the American public in the Steyr Arms booth (#3258) at the NRA Annual Meetings of Members and Exhibits in Atlanta tomorrow.
Based on the proven, biathlon-inspired SPA action built by fellow Austrian firearms manufacturer ISSC, the Steyr Scout RFR was designed from the ground up as an economical, minimal-recoil Scout Rifle trainer. Available in .22 LR, .22 WMR, and .17 HMR, the Scout RFR has an exceptionally smooth straight-pull action fed from its 10-round magazine, allowing for extremely fast cycling that makes training easy and range time enjoyable.
Code-named “Cub Scout” during its development, the Scout RFR features the same stock lines as the original Steyr Scout, as designed by Steyr engineers with the continual input of scout-rifle-concept visionary, Col. Jeff Cooper.
The Scout RFR provides a 30-slot Picatinny rail along its barrel for forward-mounted optics. An integrated 3/8-inch dovetail base also runs the full length of the receiver’s topside, and a set of Weaver bases are also included for conventional scope mounting.
The Scout RFR also features a 20-inch heavy-barrel configuration for maximum accuracy. Both the .17 HMR and .22 LR barrels are 1/2-20 UNF threaded for the users’ choice of attachments, while the .22 WMR barrel is not.
The overall length of the Scout RFR is 35.6 inches, and its base weight is 7.3 pounds. An optional knife tucks away neatly into the stock, and the standard Steyr SBS/Scout buttplate spacers can be swapped in or out to adjust length-of-pull.
The Scout RFR may not be exactly what Col. Cooper envisioned with his center-fire scout-rifle concept, but this rimfire rifle makes the idea as accessible to everyone as easy as it makes taking squirrels in your back yard or gaining a merit badge.
The Steyr Scout RFR includes two Weaver bases; one 10-round, steel-box magazine; and an owner’s manual. The suggested retail of the Scout RFR is $599.
About Steyr Arms:
Steyr Mannlicher, GmbH, is one of the world’s oldest and most prestigious firearms manufacturers. Steyr’s comprehensive lines of premium hunting rifles and precision sporting and tactical firearms are technically mature, and their subtle elegance also communicates the harmony between appearance and substance. Steyr’s legendary SBS actions and cold-hammer-forged barrels are distinctive and unparalleled. Steyr Arms is the subsidiary headquarters of Steyr Mannlicher in the U.S.
For more information, contact Steyr Arms at 2530 Morgan Rd., Bessemer, AL 35022; call (205) 417-8644; or visit their website.
This post Steyr Arms to Unveil the Rimfire Scout RFR at the NRA Annual Meetings appeared first on AmmoLand.com Shooting Sports News .
via AmmoLand.com Shooting Sports News
Steyr Arms to Unveil the Rimfire Scout RFR at the NRA Annual Meetings
An Accurate and Automatic Device for the Detection of Chemicals on Food Produce
Today, scanning for food contaminants, such as pesticides, can only be done using equipment that is: expensive to buy, expensive to operate, immobile, requires skilled personnel, and does not supply immediate results. The food industry, from farmers, producers, handlers, regulators and retailers to consumers, is in need of a better solution.INSPECTO is an innovative startup company aiming to revolutionize the process by producing an accurate, portable, affordable, quick and automatic device for the detection of chemicals on food produce, both liquid and solid.
View the full content here
via Core77
An Accurate and Automatic Device for the Detection of Chemicals on Food Produce
Percona Live 2017: Designing your SaaS Database for Scale with Postgres
The Percona Live Open Source Data Conference 2017 day one is rolling right along, and we’re already in the afternoon sessions. In this blog, we’ll look at Citus Data’s presentation on how to design your SaaS database to scale with Postgres.
If you’re building a SaaS application, you probably already have the notion of tenancy built in your data model. Typically, most information relates to tenants/customers/accounts and your database tables capture this natural relation. With smaller amounts of data, it’s easy to throw more hardware at the problem and scale up your database. As these tables grow, however, you need to think about ways to scale your multi-tenant database across dozens or hundreds of machines. In this talk, Citus Data’s Lukas Fittl and Ozgun Erdogan (CTO) talked about the motivations behind scaling your SaaS (multi-tenant) database and several heuristics they found helpful in deciding when to scale.
They then described three design patterns that are common in scaling SaaS databases:
- Create one database per tenant
- Create one schema per tenant
- Have all tenants share the same table(s).
Next, they highlighted the tradeoffs involved with each design pattern and focused on one pattern that scales to hundreds of thousands of tenants. They also shared an example architecture from the industry that describes this pattern in more detail. Lastly, they talked about key PostgreSQL properties, such as semi-structured data types, that make building multi-tenant applications easy.
After the talk, Lukas and Ozgun were kind enough to speak with me about their session. Check it out below:
Don’t miss any of tomorrow’s session. See Wednesday’s (4/26) full schedule here.
via MySQL Performance Blog
Percona Live 2017: Designing your SaaS Database for Scale with Postgres
PHOTOS: Ikea has furniture on the floor, product on the shelves
The allen wrenches are cranking away at Ikea.
The Swedish mega retailer’s Columbus store at 1900 Ikea Way off Polaris Parkway remains on track for its June 7 opening. I was invited to the site Tuesday to get a peek at the progress.
Interior walls that set the consumer path through the showroom are up and work is underway on all of the departments and rooms shoppers will amble through in a few short weeks.
Check out the slideshow to see how the store is coming along.
It isn’t just display…
via Columbus Business News – Local Columbus News | Business First of Columbus
PHOTOS: Ikea has furniture on the floor, product on the shelves
President Trump’s First 100 Days
Everyone observing politics seems to agree on two things about a president’s first 100 days in office:
1. 100 days is a meaningless, arbitrary marker for a president’s performance that is likely to be more misleading than useful.
and…
2. Let’s treat it like it is important! Reeeeeeee!
The thing that fascinates me the most about this situation is that the so-called “pro-science” people are giving Trump low grades for his first 100 days.
Allow me to connect some dots.
In science, you don’t have much of an experiment unless you have a control case for comparison. For example, you can’t know if a drug helped with a particular disease unless you study the people who didn’t take the drug at the same time as those who did.
But the pro-science people forget this concept when thinking about politics. Where is the control case for Trump’s first 100 days?
Is it George Washington’s first 100 days?
Is it Jimmy Carter’s first 100 days?
And which prior president came to office in 2017 with identical problems and the most polarized political environment in history?
And just how long is it supposed to take to revise Obamacare? Do we compare it to the time Abe Lincoln repealed and replaced Obamacare? Or how about the time those other presidents repealed and replaced Obamacare in the year 2017?
I saw an article in Politico that is too dumb to link to, saying it is objectively true that Trump has had a bad first 100 days. This is a perfect example of what I call the “two movies on one screen effect.” I’m almost certain that many Trump supporters would say these facts are objectively true too:
Economic confidence is up.
Trump signed a bunch of executive orders. You might not like them, but that’s more about you, not about his job performance.
China is putting the screws on North Korea (finally)
Trump erased the “puppet of Putin” charge by prudent application of Tomahawk missiles. That’s an accomplishment, even if you don’t like it.
Trump erased the “Trump is Hitler” hallucination that the Clinton side spray-painted onto him during the election. (That’s a big deal.)
Trump got a qualified Supreme Court judge, albeit the hard way.
Healthcare is moving along briskly from the first plan that was terrible to something that is approaching feasible. That’s progress, not failure.
Tax reform will probably be slower than we want, but most observers expect something good to come of it.
International relations look fine. The only awkward relationship is with Putin, and that’s the awkward relationship Trump’s detractors want.
Illegal immigration is way down because of Trump’s persuasion.
Now let’s look at the things President Trump did wrong in his first 100 days:
You can criticize Trump’s actions against women’s reproductive rights, both on the topic of Planned Parenthood funding and his Supreme Court pick. But calling those things failures or successes depends on your political views, not on Trump’s job performance.
I think you could make an objective case against Trump for putting economics above the environment. But you’d have to ignore the fact that a stronger economy almost always puts you in a better position to keep the environment clean. (Trump says that.) You don’t see clean air and water in poor countries.
President Trump reversed a bunch of campaign statements from impractical positions to more practical ones. Is that failure?
President Trump said a bunch of things that did not pass the fact-checking, surprising literally no one. And as usual, none of it mattered in any way except that it made us focus on whatever topic he wanted us to focus on.
President Trump’s staff and advisors are reportedly doing a lot of in-fighting for influence. But that sounds more like a healthy situation than a Trump-is-dictator situation. It would be worse if there were no differences of opinion in the group.
President Trump has been slow to fill lots of government positions. But has any of that mattered to your life? I haven’t noticed, personally. Was the Secretary of Whatever supposed to come over and mow my lawn?
President Trump did not release his tax returns, so we imagine there are problems there.
President Trump incorrectly claimed that his staff had been “wiretapped.” It turns out that they were only legally surveilled in an indirect way. Which only sounds different to his critics.
Generally speaking, the criticisms of President Trump’s first 100 days (and in general) are based on imaginary stuff:
Imagined problems on his tax returns.
Imagined blackmail by Russia.
Imagined poor performance based on imagining a control case of another imaginary president doing the same job at the same time, but doing it faster.
Imaginary belief that doing things you prefer he not do is similar to not being competent.
Imagined staff problems that are bigger than they are.
Imagined nuclear holocaust that happens because of Trump’s imaginary insanity.
Imagined problems caused by his ignoring of facts that don’t matter.
Imagined future climate calamity. (They could be right, but for now it is imaginary because complex models have a bad track record.)
—
You might enjoy reading my book because it performed better than all the imaginary books I am comparing it to.
I’m also on…
Twitter (includes Periscope): @scottadamssays
YouTube: At this link.
Instagram: ScottAdams925
Facebook Official Page: http://ift.tt/2pcqe3Y
Open Carry Muslim Posts Video with Weapons, F-Bombs at Christian Event ~ VIDEO
By Dean Weingarten
Arizona – -(Ammoland.com)- An American Muslim who open and concealed carries weapons got into trouble for a facebook live video.
He filmed and posted the video outside of a Christian event that some called “anti-Muslim”. The event occurred on April 9th, 2017.
Ehad Abdulmutta Jaber bought tickets for the event and was wearing the T-shirt pictured above. The Shirt says:
- I am an American
- I am a Muslim
- I open carry
- I concealed carry
- I am only dangerous
- If you are stupid.
Ehad entered the event wearing the shirt and openly carrying a holstered pistol. He was concealed carrying another pistol in an ankle holster. One account said he was filming the event, but he was only there for a few minutes.
Ehad was approached by a security guard and asked to leave, as firearms were prohibited at the venue. By all accounts, Ehad was asked to leave politely, and he politely left. It was after he left the venue and was inside his van in the parking lot, that he made a serious error.
He posted a live facebook video of himself, speaking of the event. Here are links to the video. I found the dailymail link easier to view, it is not a reverse image.
Ehad has First and Second Amendment rights. He says that he is an American citizen who has lived in Sioux Falls for 25 years. The T-Shirt is clearly a political statement.
The video may have been a bridge too far.
In the video, Ehad says that he was at the event. He is upset, and uses considerable profanity.
He says “And now if you really want to be scared, be scared,” he then briefly displays four semi-auto pistols, an AR-15 type rifle, and an AK type firearm that might be either a pistol or a rifle. He shows that he has ammunition. He says “be terrified”. Up to this point, the video may be taken as sarcasm.
A Police officer said that Jaber was not arrested at the rally. The officer is quoted as saying that there was no direct threat.
“He had a lot of guns with him, but he wasn’t breaking any laws. He didn’t threaten anybody directly, he didn’t threaten any groups of people anything like that and it’s not illegal to carry guns or have guns with you,” says Officer Sam Clemens of the Sioux Falls Police Department.
Police say Jaber does have open carry and concealed carry permits. They also spoke with him, so did the FBI. Police say the information was sent to the Lincoln County State’s Attorney’s Office and no charges will be made.
“You have to have some type of specific threat or manner, just having a gun just because it alarms people doesn’t constitute a threat. That doesn’t mean you are going to harm people,” says Clemens.
But Jaber’s last statement on the video may make a significant difference. His last sentence was “F*ck all ya all.”
I have written, read, and participated in open carry and Second Amendment events over considerable parts of the country. I have some sympathy for Ehad Jaber. Posting a video in the parking lot of an event that you are protesting, showing a number of legal weapons, while telling people to be scared, to be terrified, is extremely unusual and provocative.
Then to say “F*ck all ya all.” is over the line. I have never seen anyone at any of the events I attended or wrote about, or read about, tell people to be scared and terrified, as they handled weapons, or to make the F-bomb threat. Those are dozens of events over the years.
I could follow the sarcasm up to the last F-bomb. Then it became ambiguous.
After a little study, the Lincoln County AG made the decision to arrest Jaber and charge him with one count of a terrorist threat. From argusleader.com:
A man who authorities say brought weapons to an anti-Islam event earlier this month has been arrested on charges that he made a terrorist threat, according to a release from the South Dakota Attorney General.
Ehab Abdulmutta Jaber, 45, was arrested Friday and charged with one count of terrorist threat, despite an earlier indication from Sioux Falls police that the man would face no charges.
When Jaber was arrested, a search was made of his residence. Law enforcement reports that they found methamphetamine.
A SWAT team was dispatched along with local police, Forster said, but once they arrived, Jaber was taken into custody in a “standard operation.”
During a search of Jaber’s residence, the release said, law enforcement seized firearms as well as methamphetamine.
The methamphetamine find seems fortuitous for law enforcement; but it might explain the rant and poor choice of words in the facebook video.
To look at this objectively, consider if the religions were reversed. Suppose a Christian had worn the shirt with “Christian” instead of “Muslim” to a Muslim event. Suppose a Christian had made the facebook video. My experience is that the Christian would quickly have been arrested.
That is why you do not see such activity at other open carry events. There are many open carry events that you can see on the Internet. The participants are polite to the police, as was Ehab. They do not go to a van in the parking lot of an event they are protesting, and then post a video that can easily be taken as threatening.
I wish Ehad well, but fear he has made a mistake that will haunt him for the rest of his life. When you are politically active for both the First and Second Amendments, there is no room for foolish bravado.
©2017 by Dean Weingarten: Permission to share is granted when this notice and link are included.
About Dean Weingarten:
Dean Weingarten has been a peace officer, a military officer, was on the University of Wisconsin Pistol Team for four years, and was first certified to teach firearms safety in 1973. He taught the Arizona concealed carry course for fifteen years until the goal of constitutional carry was attained. He has degrees in meteorology and mining engineering, and recently retired from the Department of Defense after a 30 year career in Army Research, Development, Testing, and Evaluation.
This post Open Carry Muslim Posts Video with Weapons, F-Bombs at Christian Event ~ VIDEO appeared first on AmmoLand.com Shooting Sports News .
via AmmoLand.com Shooting Sports News
Open Carry Muslim Posts Video with Weapons, F-Bombs at Christian Event ~ VIDEO