It was a long time ago so I won’t write about the conference (it was good as always), but at least I share the slides of my talk here.
via Planet MySQL
Percona live Dublin – Migratin and living on RDS/Aurora
Just another WordPress site
It was a long time ago so I won’t write about the conference (it was good as always), but at least I share the slides of my talk here.
via Planet MySQL
Percona live Dublin – Migratin and living on RDS/Aurora
If cops have the ability and opportunity to record a traffic stop, should it be held against them when they don’t? Arguments have been made to that effect for a few years now. Dashcams have been in wide use for at least a couple of decades. Law enforcement agencies all over the US are issuing body cameras to officers. But it seems whenever something questionable happens, footage is nowhere to be found, or what there is of it is almost useless.
Unfortunately, years of discussion by (mainly) defense lawyers hasn’t resulted in policy changes. Worse, it hasn’t budged the judicial needle much. In rare cases, the absence of footage is used against officers, but in those cases, it mainly seems to be because efforts were made to destroy footage already captured.
In this case [PDF] reviewed by the Sixth Circuit Appeals Court, no effort was made post facto to destroy footage. Instead, an officer proactively prevented footage from being created by disabling the dashcam recording the traffic stop. (via FourthAmendment.com)
The defendant made a few different arguments for suppression of evidence obtained via a search of his vehicle. Citing Rodriguez, he claimed the wait for the K9 unit unnecessarily prolonged the traffic stop. The appeals court disagreed, saying its interpretation of the Supreme Court’s decision gives officers about 20 minutes to freely violate citizens’ rights.
Defendant next argues that the search violated the Fourth Amendment because the officers extended the stop beyond the time required to investigate the traffic violation in order to conduct a canine sniff. The district court determined that the delay was not excessive, relying upon United States v. Collazo, 818 F.3d 247, 257-58 (6th Cir. 2016), in which we countenanced a traffic stop that exceeded twenty-one minutes based on the totality of the circumstances. Here, the district court observed that the canine unit appeared within ten minutes of the stop, the car’s paperwork, which was a rental, did not include any of the passengers as authorized drivers, and the GPS information indicated that defendant had been out-of-state, which was prohibited by the terms of his parole. While these factors might individually have an innocent explanation, the court found that “from a law enforcement perspective all that adds up . . . to a reasonable suspicion for an extension, which . . . wasn’t very long anyway.”
This completely ignores Supreme Court precedent, which made it clear it wasn’t the length of the rights violation, but rather the violation itself. Once the purpose of the traffic stop has been achieved, any fishing expeditions by law enforcement past that point are Constitutional violations, whether it’s five minutes, ten minutes, or a half hour. A holding like this makes it that much easier for officers to slow roll traffic stops so they can run a drug dog around a car they stopped for a lane change violation. That’s what appears to have happened here and both courts (district, appellate) said this is fine.
Trooper Boven returned to his cruiser after collecting everyone’s identification and ran the information through two law enforcement databases to check for outstanding warrants and to confirm that Mercedes Hunt was a valid driver. Defendant contends that Trooper Boven entered the information slowly in order to prolong the traffic stop until the canine unit arrived, which it did shortly after he finished processing the licenses.
In this case, there was plenty to be reasonably suspicious about, hence the call for the K9 unit. But once the K9 unit arrived something strange happened. The officer turned off his dashcam, ostensibly to "protect" the confidentiality of an informant.
Once Deputy Osbun arrived, Trooper Boven explained the situation to him to “keep him in the loop” and for officer safety. He also turned off the dashboard camera. According to his testimony, he did so to prevent information about the confidential informant from coming to light in case the stop revealed no drugs. After speaking with Deputy Osbun, however, Trooper Boven apparently forgot to restart the dashboard camera and, as a result, there is no footage of the search of the car. In total, twenty minutes elapsed before the camera was restarted.
The defendant challenged this, stating the missing footage prevented him from directly challenging the supposed probable cause generated by the dog’s nose. And there were sufficient reasons on record to warrant doing so.
Defendant contends that the lack of a visual record of the search undermines his ability to challenge the legitimacy of the canine alert to narcotics. First, there are no records maintained of the dog’s prior performance in the field. Second, Deputy Osbun recalled up to six false alerts at the suppression hearing, which defendant contends is a significant number given that dogs are deployed only when the presence of drugs is suspected. Third, the lack of dashboard camera footage makes it nearly impossible for defendant to challenge whether Deputy Osbun’s interaction with the dog may have influenced its subsequent alert. Finally, defendant characterizes the missing video footage as “spoliation” for which the government must be held responsible.
The district court, however, didn’t view this as spoliation of evidence. For the most part, the legal argument is sound. You can’t ruin evidence that doesn’t exist. The problem is that if you can prevent such evidence from ever existing, you can probably get your questionable actions excused by the courts.
The Appeals Court affirms the lower court’s decision. While the totality of the circumstances makes this a less-than-ideal test case, the fact remains too much slack is being cut by the courts. The camera could have been left on. Any concerns the trooper had about his informant’s confidentiality could have been addressed by the department. They could have been presented to the court prior to turning over the footage in case redactions were warranted. But shutting off a camera during a stop — especially a pretextual stop where an officer deliberately slowed down his ticket-writing duties to bring a drug dog to the scene — should be treated as a failure to preserve evidence by law enforcement.
In this case, the Sixth Circuit does double damage: it ignores the issues raised by cops disabling cameras during traffic stops, and gives officers in its jurisdiction 20 minutes in which to violate rights (and the Supreme Court’s Rodriguez decision) without fear of reprisal.
Permalink | Comments | Email This Story
via Techdirt
Cop Shuts Off Dashcam During Drug Dog Sniff. Appeals Court: This Is Fine.
The highly-anticipated demand letter written on behalf of a former Uber employee, which has become central to the unfolding drama that is the Waymo v. Uber trade secrets lawsuit, was publicly released on Friday afternoon.
As previewed in earlier court hearings, the “Jacobs Letter” outlines in detailed terms the questionable and possibly illegal behavior that former Uber security official Richard Jacobs and his former colleagues engaged in during his 11-month tenure at the company.
This letter, which was only recently shared with lawyers involved in the lawsuit and the judge overseeing the case, ultimately led to federal prosecutors opening a criminal investigation into Uber, which is still ongoing.
Waymo v. Uber began back in February, when Waymo sued Uber and accused one of its own former employees of stealing 14,000 files shortly before he left Waymo. The former employee, Anthony Levandowski, went on to found a company that was quickly acquired by Uber. Levandowski refused to comply with his employer’s demands during the course of this case and has since been fired. Uber has denied that it benefited in any way from Levandowski’s actions.
The outcome of the case will likely determine which company will end up ahead in the cutthroat and rapidly-growing autonomous vehicle sector.
Among other explosive claims, the Jacobs Letter specifically says that two named high-level Uber employees, including Craig Clark, a since-fired Uber lawyer and Mat Henley, who still works at Uber and recently testified in court, orchestrated this scheme.
The men “led Uber’s efforts to evade current and future discovery requests, court orders, and government investigations in violation of state and federal law as well as ethical rules governing the legal profession. Clark devised training and provided advice intended to impede, obstruct, or influence the investigation of several ongoing lawsuits against Uber and in relation to or contemplation of further matters within the jurisdiction of the United States.”
The letter also contains detailed allegations of abuse of the attorney-client privilege. At one point Clark allegedly ordered that “double secret A/C priv” (short for “double-secret attorney-client privilege”) be written on a document as a way to shield it from being disclosed in ongoing or future lawsuits.
This, as many lawyers on Twitter noted, is not a real legal term.
If you invoke double-secret attorney-client privilege, it cancels the first privilege out. Little known in-house secret. https://t.co/sOZh9lDKrU
— Feliz Navi-JJ (@J_Dot_J) December 15, 2017
In addition, the Jacobs letter describes what it calls “illegal wiretapping” of a phone call discussing an internal report of sexual harassment. Earlier this year, Susan Fowler, a former Uber engineer, came forward with her experience of such abuse, which ultimately lead to the ouster of then-CEO Travis Kalanick.
Another section of the letter describes the use of a “new technical capability” by “CIA-trained case officers” that Uber contracted with. In 2016, these people allegedly “collected mobile-phone metadata either directly through signal-intercept equipment, hacked mobile devices, or through the mobile network itself. The information eventually shared with Jacobs and others included call logs, with time and date of communications, communicants’ phone numbers, call durations, and the identification of the mobile phone subscribers. The subsequent link-analysis of this metadata occurred on U.S. soil.”
The 37-page demand letter, which was filed by a Minnesota attorney on Jacobs’ behalf, was essentially a warning that Jacobs may sue the company.
Rather than go to court over his claims, Uber ended up paying Jacobs $4.5 million, and his lawyer, Clayton Halunen, $3 million.
In a recent court hearing, Angela Padilla, Uber’s deputy general counsel, testified that this letter was “extortionate,” but noted that going to court would have cost the company far more. (Halunen has not responded to Ars’ request for comment.)
In another court filing submitted on Friday, outside court-appointed advisor Special Master John Cooper determined that this Jacobs Letter should have been made available to Waymo much earlier as part of the civil discovery process.
The revelation of the letter’s existence, which only became known late last month, resulted in the trial being postponed a second time.
The trial is now scheduled for early February 2018 in San Francisco, just blocks from Uber headquarters at 1455 Market St.
via Ars Technica
New letter: Top Uber officials engaged in illegal wiretapping, shady spycraft
The tools we typically use for managing personal projects have a major drawback. To-do lists
To-Do List App Showdown: Any.do vs Todoist vs Wunderlist
To-Do List App Showdown: Any.do vs Todoist vs Wunderlist
Some to-do list apps stand head and shoulders above the rest. But how do they compare and which one is best for you? We’ll help you find out.
Read More
and their variations (like Kanban boards
How to Manage Tasks Using Japanese Kanban Technique
How to Manage Tasks Using Japanese Kanban Technique
Kanban is a Japanese recipe for getting things done. It’s an organization technique originally developed for Toyota’s production line. We show you how you can implement it for yourself or in your team.
Read More
) are fine to track what should be done and (maybe) who should do it. But they aren’t as good at planning out the when. This is the domain of business-oriented tools, such as the Waterfall project management approach.
One of the primary reasons companies use a set of tools and processes to manage their projects is for profitability. Once management decides a particular project will add value to the business, there is a cost for every hour that project isn’t finished. As individuals, however, it’s very easy to let personal projects slide. We’re sick, or too tired, or work is too busy, or there are too many cat videos on the internet. Part of the discipline of project management is not only to drive projects to completion, but also to set them up initially so they finish in an acceptable time frame.
In this article, we’ll look at how you can use business tools to keep yourself on track and get your projects done.
There are a couple of important tenents of project management you’ll need to learn:
Given a desired end goal, the first step in most projects is to break that goal down into achievable tasks. For example, if you’re looking to spin up a WordPress blog your high-level might include writing some content, designing a logo, and WordPress installation/deployment to your server. Creating a work breakdown structure (WBS) involves dividing and sub-dividing them until you’re left with tasks that are easy for someone to look at, understand, and execute.
The actual WBS for this simple project might look like this:
The smaller the tasks, the better. For example, the “write content for posts” items could be further split out one per post. Making them smaller not only allows you to see progress sooner. It also provides flexibility in shuffling them around to meet a target date. You should also have a concept of what needs to be completed before something else can begin
6 Project Management Tips You Can Use to Organize Your Life
6 Project Management Tips You Can Use to Organize Your Life
Project Management is the profession of getting things done. Our tips will help you apply a project manager’s perspective, skills, and tools to organize your own life.
Read More
, known as predecessors or dependencies.
For example, your designer can’t produce the draft of your logo until after you’ve selected her. So the outline of your project now looks like this:
Now that you know what needs to be done, you need to figure out who will do it and when. To assign a task to someone, you’ll first need to be sure they can do it at all (e.g. don’t assign 3.5 to your graphic designer). But you also need to know how much they’re available in general, as well as when. This is called resource management. It starts with understanding how many hours a day someone is available, then tracking that availability against the work you assign.
For example, you may have a day job. At your 9-to-5, you’re available probably eight hours a day. But for your personal projects, you may block off an hour or two
Time Blocking — The Secret Weapon For Better Focus
Time Blocking — The Secret Weapon For Better Focus
Are you looking for a more efficient way to organise your work-days? Try Time Blocking. This time management tactic can help keep you on track while keeping distractions, procrastination, and unproductive multitasking at bay.
Read More
at night. This means you have a weekly capacity of: (2 * 5) = 10 hours a week (go on, take the weekends off… you deserve it). This means a given task that a person working full-time at it could complete in one day will take you four working days. Calculating things according to capacity will tell you how long your projects will really take.
We’re calling this “Optimized Planning,” because creating the WBS is in fact also planning. But what you may find is you’ll make the initial plan for the “best case scenario.” There will be one and only one task going on at any one time (easy to manage), and they all fall neatly one after another. But this is rarely how projects work in practice. During this phase you’ll adjust the structure and assignments in the project depending on:
What you’ll likely find is that some parts of the project grow in duration, and you’ll seek out ways to shorten others. Now that you have an idea of what you should be putting into your project plan, let’s take a look at how to actually do it.
Before the step-by-step, a quick word in defense of project management tools. I’ve heard something like the following many times, when suggesting or tasking someone to learn one of these apps:
There is a reason Gantt charts (which have been around for over a century) are still in use today — and why they’re so popular in Waterfall project management. They are the best single view to visualize your timeline, its status, and individual task assignments, especially if you’re using Waterfall project management.
Calendars don’t give you a one-shot view of your project. Linear to-do lists rarely account for dependencies, and no other tool helps to auto-update start and finish dates like Gantt-based applications.
What many people get wrong about these apps is how they use them. But we’ll show you how to do things the easy way. We’ll be using ProjectLibre for our Waterfall model example project, although the steps should work almost identically in anything that provides an interactive Gantt chart
Need a Gantt Chart Template for Excel or PowerPoint? Here Are 10 Unique Options
Need a Gantt Chart Template for Excel or PowerPoint? Here Are 10 Unique Options
You don’t need Microsoft Project to track progress. These Gantt chart templates for Excel and PowerPoint will help you manage your project just as well.
Read More
(desktop, mobile, web, even Excel files).
Installing ProjectLibre is as simple as downloading the latest release (1.7 at the time of writing) and running the EXE installer (Windows), dragging the DMG to your Applications folder (Mac), or installing the RPM or DEB package via your preferred method (Linux).
Once you’re installed, fire ProjectLibre up and select the Create Project option. It will give you a dialog to enter some preliminary information like name and a start date.
The first step is to create your WBS. Start jotting all the tasks you know about down anywhere: email message, plain text file, Word Processor document, OneNote. Whatever you’re comfortable with while brainstorming is fine. Now, open ProjectLibre to the Gantt view, and paste the text into the cells at left that resemble a spreadsheet.
Many people’s first mistake is using these apps in a point and click fashion. Don’t. Treat the left side of the screen exactly like spreadsheets and use keyboard shortcuts
35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & Mac
35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & Mac
Keyboard shortcuts can save you a lot of time! Use these Microsoft Excel shortcuts to speed up working with spreadsheets on Windows and Mac.
Read More
: arrow buttons to move around, F2 to edit, and Enter to commit.
The only additional things you’ll need to know are the keystrokes to indent (Ctrl + . (period) for ProjectLibre, although it’s Tab in MS Project) and outdent (Ctrl + , (comma) in ProjectLibre, Shift + Tab in Project) tasks. This part works just like an outline in Word. It allows you to quickly create the various phases and tasks (which are bottom-level entries) in your plan.
Next, put in your Predecessors (i.e. A must finish before B can start). Here again, use arrow keys and Enter/Tab for quick entry. Finally, add Work, or the amount of time you think each item will take.
You’ll notice two things happen when you start adjusting the WBS. Firstly, lines that become “parent” items are converted to phases, meaning they finish when all their child tasks are complete. Second, as you add predecessors, you’ll notice the start and end dates are automatically adjusted. While it may still seem like a big undertaking, watch the following for an example of how quick and easy this can be. (The time to create this plan was just over three minutes. The only part not shown below was typing in the prior tasks.)
Although you entered Work for each task, you’ll notice their Durations all show something like “.25 days?” including the question mark.
This is because the app assumes each will be performed within an eight-hour day. But this can be affected by other factors including resource capacity. Your capacity.
For this project, I’m assuming I’ll be available for a couple of hours a day. Based on an eight-hour day, this equates to 25 percent capacity (if I was available full time, this would be 100 percent). When I enter my name as the resource for each task, I’ll be adding “[25%]” after it, which is ProjectLibre’s notation for capacity. Watch in the short screencast below what happens to the “Duration” column as I assign these tasks to myself. Taking into account my capacity, ProjectLibre has increased the duration of each task fourfold.
Now I can see that while the project is only a little over 80 hours long, it will actually take about five weeks to complete.
This is one of the advantages of the Waterfall methodology: it shows you more realistic timelines.
But don’t fret! There are a couple of adjustments we can make to dial that date back.
Once all your resources are entered, you have a chance to step back and examine your plan. For example, you can see that the Visual Design and Logo Draft tasks aren’t assigned to me. This is because I’m a terrible artist, and if I tried to do this myself it wouldn’t go well. But it also means that while some talented artist will be working on these tasks, I can work on something else in the meantime.
We’d set the initial version of our plan in a strictly linear way: each task was started when the one before it ended, and likewise with phases. But let’s adjust the predecessors such that phases aren’t dependent, and remove the ones for the tasks I won’t be doing. Note how it moves the parts of the timeline around.
Now we’ve scaled the project down by about a week. Considering I’m doing the bulk of the work, this isn’t too shabby. We could probably do better yet by moving the Creative section first, and working on content while that logo is in production.
With your own projects, it’s all too easy to just pull out a calendar
How to Sync Your Google Calendar With Your To-Do List
How to Sync Your Google Calendar With Your To-Do List
In organizing your life, two tools are indispensable: your calendar and your to-do list. But most task management solutions keep these two things separate. We’ll show you how to combine them.
Read More
, pick a couple of dates, and go on your merry way.
Using lightweight tools like OneNote (how to use OneNote for project management
How You Can Use Microsoft OneNote for Project Management
How You Can Use Microsoft OneNote for Project Management
OneNote is the ideal collaboration tool for managing simple projects in small teams. And it’s completely free. See how OneNote can help your projects take off!
Read More
) or Trello (how to use Trello for project management
A Guide to Trello for Life and Project Management
A Guide to Trello for Life and Project Management
Trello can help you get organized. It’s a free tool to manage any kind of project. Read this guide to understand its basic structure, the navigation, and how Trello can be useful to you.
Read More
) gets you a little closer to the mark, as they at least account for who is doing what.
But going through this exercise in something like ProjectLibre forces you to think about how much time you actually have to dedicate to it, what bottlenecks exist, and places where you may want some help. It also helps to break your projects down into manageable pieces to make sure you’re making progress. While you may think a tool like ProjectLibre was overkill, hopefully, we’ve shown how easy it can be.
Do you typically just wing it when it comes to your pet projects? Or do you use a system like Waterfall project management? Let us know how you “self-project-manage” below in the comments!
via MakeUseOf.com
Use the Waterfall Project Management Method to Organize Your Life
Build Your Own AR-15 Rifle Parts & Components, Check List:
USA – -(Ammoland.com)- Recently AmmoLand News, Aero Precision and Brownells had gun writer Tom Mchale build out one of Aero’s DIY Custom Rifle Builder Kits. You can read the article series here at the following links.
This page is the supporting Tools List and Part List for that build. While we chose the Aero AR15 Builder Set, (not everyone likes arctic camo) you could pick any number of AR 15 rifle parts kits and use the below list of components and all the same gunsmith tools to complete your AR rifle build’s upper and lower receivers.
**Click on the product names below to purchase online.
These essential gunsmith tools will make your AR rifle build a whole lot more fun and make many gunsmithing tasks much more precise and clean. All these tools will prove useful for years to come as you build out more cool rifles.
Need more detailed AR15 rifle assembly instructions or to return to the build page, click here and check out the companion article, “Build Your Own AR-15 Rifle from an Aero Precision AR Builders Kit.”
This post Check List: Tools & Rifle Parts to Build Your Own AR-15 Rifle two appeared first on AmmoLand.com .
via AmmoLand.com
Check List: Tools & Rifle Parts to Build Your Own AR-15 Rifle two
Wildlife photographer Tibor Kércz would spend a few nights each year camped out in a tent near a tree, hoping to capture photos of little owls and their nestlings. But just before nightfall on one fateful evening, three of the birds flew out onto a short branch. They landed and tried stabilizing themselves… but the owlet on the end began to fall.
“So I started to shoot in the right moment,” he told Gizmodo in a Facebook message. That series of photos won him the 2017 Comedy Wildlife Photography Awards.
Advertisement
The awards are meant to highlight whimsical, “possibly unpretentious” photography of wild animals doing funny things, according to their website. Some of the silliest images from past contests have gone viral, and this year’s certainly have the potential to do the same. Ultimately, the founders’ main goal is conservation.
“Well… you are now obviously going to go to your office, home, pub, club, or wherever and talk about the dire need for us all to be conservationists in our own little way,” the competition’s founders write on their website. The contest is affiliated with the Born Free Foundation wildlife conservation charity. But Kércz likes how it gives humans the chance to see animals in a more relatable light.
“It is a great initiative and [gives us the] chance to show people how funny and lovable these cute creatures are, like we are,” he said.
Advertisement
The contest received over 3,500 submissions, which were required to have been taken by the photographer, not of a pet or domesticated animal, and without being digitally manipulated. Also, term number 16 of the website’s Terms and Conditions is “16. You must think Bohemian Rhapsody one of the greatest pieces of popular music ever written, just kidding. No seriously….” So yeah.
Anyway, here are the pictures:
It’s a fart joke.
[via Comedy Wildlife Photo Awards]
via Gizmodo
Behold The Most Hilarious Wildlife Photos of 2017
While investigating alternatives to migrate to Google Cloud SQL, I encountered a lack of support for external masters. However, it’s possible to overcome this limitation by replicating into Google Cloud SQL using Tungsten replicator.
Cloud SQL is Google’s database-as-a-service solution, similar to RDS for Amazon Web Services. You can get a fully managed database in only a few clicks (or API calls). At the time of writing this, the only supported databases are MySQL and Postgres.
Google offers two different options for MySQL deployments.
1st generation instances:
2nd generation instances:
There are some limitations that are common to both flavors:
From the above, it is quite obvious most production deployments would want to use 2nd gen instances.
The problem is there is no migration path that doesn’t involve stopping application activity to be able to take a dump of the data, due to the fact that external masters are not supported on 2nd gen instances.
So how do we migrate our database to Google Cloud SQL while keeping downtime as low as possible?
The answer is to use Tungsten Replicator, so that replication is completely external to the database.
Note that since we only need the replicator, the FOSS version available on Github is enough for our purposes. There is no need to buy Tungsten commercial version, which includes the cluster functionality and official support.
We will need to install two different Tungsten processes: One will attach to the source database to read transactions from the binary logs, while the second will apply those transactions to the Cloud SQL instance.
This is what it looks like:
The first thing you will need is a place to install the replicator. I suggest to provision a dedicated instance (instance-1 in the diagram) in the same zone as your Cloud SQL instance.
At minimum you would want an n1-standard-1 size, as Tungsten does consume its fair share of memory.
Tungsten needs some packages (do check out the complete requirements list here) so let’s go ahead and install them:
apt-get install ruby default-jre
Now we need a database user for Tungsten on the source and target databases:
GRANT ALL ON *.* TO tungsten@'%' IDENTIFIED BY 'secret';
It is usually a good idea to have a dedicated OS user as well:
useradd -m -d /opt/continuent tungsten
Get the replicator package from GitHub and extract the contents as tungsten OS user:
wget http://ift.tt/2krtebg
tar zxf tungsten-replicator-5.2.1.tar.gz
Prepare the Tungsten config files on instance-1 as follows. instance-1 is the server where Tungsten will run from, and instance-2 is the server that has the source database.
Process that will read from MySQLvi /etc/tungsten/tungsten-mysqlreader.ini
[defaults] replication-user=tungsten replication-password=secret skip-validation-check=MySQLUnsupportedDataTypesCheck skip-validation-check=MySQLPermissionsCheck skip-validation-check=MySQLMyISAMCheck [mysqlreader] install-directory=/opt/continuent/mysqlreader master=instance-1 members=instance-1 datasource-host=instance-2 datasource-user=tungsten datasource-password=secret
Process that will write to Cloud SQLvi /etc/tungsten/tungsten-writetocloudsql.ini
[defaults] replication-user=tungsten replication-password=secret [writetocloudsql] datasource-type=mysql install-directory=/opt/continuent/writetocloudsql master=instance-1 members=instance-1 topology=master-slave datasource-host=cloudsql_ip_address datasource-user=tungsten datasource-password=secret privileged-slave=false skip-validation-check=InstallerMasterSlaveCheck skip-validation-check=MySQLPermissionsCheck skip-validation-check=MySQLBinaryLogsEnabledCheck rmi-port=10002 master-thl-port=2112 master-thl-host=instance-1 thl-port=2113
Note the use of privileged-slave=false and the various validation checks that need to be skipped for the applier process. That allows us to get past the SUPER requirement and the other Cloud SQL limitations.
Since we are running both extractor and applier processes on the same instance, we need to manually specify the ports on the second process so that there are no conflicts.
Now we are ready to install the replicators, by running the following as tungsten OS user:
cd tungsten-replicator-5.2.1/tools
tpm install
At this point you would start the reader process using trepctl online command to start capturing events from the source instance, and use something like mysqldump to dump & load your dataset into a Google Cloud SQL instance. Make sure you have the binlog coordinates of that dump available.
Once the Cloud SQL instance is properly seeded, we would start the applier process from the appropriate position e.g.
/opt/continuent/writetocloudsql/tungsten/tungsten-replicator/bin/trepctl online -from-event 'mysql-bin.000011:0000000000002552;0'
Checking the status of each process:
tungsten@instance-1:~$ /opt/continuent/mysqlreader/tungsten/tungsten-replicator/bin/trepctl status
Processing status command...
NAME VALUE
---- -----
appliedLastEventId : mysql-bin.000007:0000000000000520;112
appliedLastSeqno : 1
appliedLatency : 0.355
autoRecoveryEnabled : false
autoRecoveryTotal : 0
channels : 1
clusterName : mysqlreader
currentEventId : mysql-bin.000007:0000000000000520
currentTimeMillis : 1511354659857
dataServerHost : instance-2
extensions :
host : instance-2
latestEpochNumber : 0
masterConnectUri : thl://localhost:/
masterListenUri : thl://instance-1:2112/
maximumStoredSeqNo : 1
minimumStoredSeqNo : 0
offlineRequests : NONE
pendingError : NONE
pendingErrorCode : NONE
ndingErrorEventId : NONE
pendingErrorSeqno : -1
pendingExceptionMessage: NONE
pipelineSource : jdbc:mysql:thin://instance-2:3306/tungsten_mysqlreader?noPrepStmtCache=true
relativeLatency : 3.857
resourcePrecedence : 99
rmiPort : 10000
role : master
seqnoType : java.lang.Long
serviceName : mysqlreader
serviceType : local
simpleServiceName : mysqlreader
siteName : default
sourceId : instance-2
state : ONLINE
timeInStateSeconds : 72.806
timezone : GMT
transitioningTo :
uptimeSeconds : 74.46
useSSLConnection : false
version : Tungsten Replicator 5.2.1
Finished status command...
tungsten@instance-1:/etc/tungsten$ /opt/continuent/writetocloudsql/tungsten/tungsten-replicator/bin/trepctl status
Processing status command...
NAME VALUE
---- -----
appliedLastEventId : NONE
appliedLastSeqno : -1
appliedLatency : -1.0
autoRecoveryEnabled : false
autoRecoveryTotal : 0
channels : -1
clusterName : writetocloudsql
currentEventId : NONE
currentTimeMillis : 1510939133227
dataServerHost : cloudsql
extensions :
host : cloudsql
latestEpochNumber : -1
masterConnectUri : thl://localhost:/
masterListenUri : thl://instance-1:2113/
maximumStoredSeqNo : -1
minimumStoredSeqNo : -1
offlineRequests : NONE
pendingError : Replicator configuration failed
pendingErrorCode : NONE
pendingErrorEventId : NONE
pendingErrorSeqno : -1
pendingExceptionMessage: Unable to translate property value: key=serverId value = 3555962359
pipelineSource : UNKNOWN
relativeLatency : -1.0
resourcePrecedence : 99
rmiPort : 10002
role : master
seqnoType : java.lang.Long
serviceName : writetocloudsql
serviceType : unknown
simpleServiceName : writetocloudsql
siteName : default
sourceId : 35.184.133.21
state : OFFLINE:ERROR
timeInStateSeconds : 431.65
timezone : GMT
transitioningTo :
uptimeSeconds : 433.596
useSSLConnection : false
version : Tungsten Replicator 5.2.1
Finished status command...
I’ve discovered there is a bug with Tungsten 5.2, where high values of server-id parameter prevent replicator from working. CloudSQL sets very high server-ids by default, and this cannot be modified by a user.
I have already reported this to Continuent so hopefully they will come up with a way to fix this soon.
In the meantime the only way to get past this is to open a ticket with Google support, and have them modify the server-id on Cloud SQL instance for you.
Cloud SQL is a very interesting platform for those wanting a fully managed database solution.
Until 2nd gen instances have the ability to replicate from an external master, replicating into Google Cloud SQL using Tungsten after the initial load is one valid alternative. By doing so, you can keep data in sync until you are ready to do the cutover to the new platform.
via Planet MySQL
Replicating in Google Cloud SQL using Tungsten
There’s going to come a time where every shooter has to change out the barrel of their AR-15 or AR-10. For some, it’s because they’ve squeezed off a few too many 6.5 Creedmoor rounds at the range, while others are just looking for an upgrade to keep their accuracy razor-sharp.
Whatever your reason for changing the barrel to your AR, understand one thing: your barrel isn’t something that you want to cut corners on.
If this is your first time replacing the barrel to your AR, or if you’ve finally decided to build an AR from the ground-up, make sure to check out the barrel section to our AR-15 guide before you get started. It has all the information you need to level you up from noob status. Take a look at it even if you’re building an AR-10, as some of the general information regarding barrels is the same between platforms.
Now that we’ve got that out of the way, let’s take a look at some of the best manufacturers for AR barrels.
Established in 2012, Faxon Firearms is a new up-and-comer in the industry. But don’t mistake their newcomer status as inexperience. Faxon barrels have been a fan favorite over the past few years because of their accuracy, durability, and lightweight design.
You can find Faxon’s barrels chambered for a number of different cartridges commonly used with the AR-15, but the most common ones you’ll encounter are the:
They also make 9mm barrels for your pistol-caliber carbines as well.
Faxon makes a number of different lengths, so finding the right barrel to fit your unique specifications shouldn’t be a problem. Let’s take a look at one of their more popular barrels.
Faxon’s Pencil Barrels are a line of lightweight barrels that come in a number of different sizes. The most popular of the group tends to be the 16” mid-length barrel, which has a .625” low-profile gas block and weighs a total of 1.2lbs.
16” Pencil Barrel by Faxon (5.56 NATO)
One of the best things about Pencil Barrels is that they’re affordable and average between $150 and $170 depending on the length. They’re made with the standard 4150 steel used on all mil-spec barrels, but you have the option of choosing a match-grade 416R stainless steel barrel instead, as long as you’re okay with the sticker price doubling.
Regardless of which barrel material you decide to go with, your Faxon Pencil Barrel will come with a QPQ nitride finishing that keeps it protected from corrosion and common wear-and-tear.
The great thing about Faxon barrels is that you get an affordable price tag and a high-quality barrel. For this reason, it’s important to make the distinction between being a bargain and being cheap – because the Pencil Barrel is anything but cheap.
You’ll find that this barrel can withstand heavy use without wearing own and sacrificing accuracy. If you’re someone who likes to put their AR-15 to work consistently, you won’t be disappointed. And if you’re still not sold, take a look at our comprehensive review of the 14.5” Pencil Barrel and decide for yourself.
Ballistic Advantage is a well-known company that specializes in match-grade barrels and replacement barrels for your AR-15 build.
What’s cool about BA barrels is that the company doesn’t take a one-size-fits-all approach to barrel design. Most barrels belong to one of the following series: Modern, Performance, or Premium. Each series is designed to fulfill a specific need for the shooter, while also giving them the chance to stick to their price range or only pay for features that they actually need. They also come in a number of different lengths, starting at pistol and going all the way up to a 20” rifle length.
One of the chief gripes that people had about Ballistic Advantage was that they didn’t make barrels for the increasingly popular 6.5 Grendel round. Fortunately, they’ve recently remedied that and now support Grendel and .22 Nosler rounds, along with all of the usual AR-15 suspects –including the 9x19mm pistol-caliber carbine.
With that out of the way, let’s take a look at some of the best AR barrels Ballistic Advantage has to offer.
The Modern Series is Ballistic Advantage’s baseline barrel series. They’re going to run you anywhere between $140 and $185 depending on the barrel length. And for AR-15 pistols, a Modern Series barrel will set you back about $115.
Ballistic Advantage 16” Modern Series Unthreaded Barrel for the 5.56
Despite being the company’s cheapest option, the Modern Series is perfect for the basic shooter who’s looking for longevity and decent accuracy, but doesn’t need to worry about the demands of competitive shooting.
The barrels are made from 4150 Chrome Molybdenum Vanadium and are given a protective QPQ finish. They also give the barrel extension and barrel separately, in order to prevent the extensions from loosening over time due to heat.
The Performance Series are a little more expensive, ranging between $200 and $250 depending on the length of the barrel. With Performance Series barrels, you get the same quality that comes with the Modern series, along with a nickel boron-coated extension. The benefit of this is that you get further protection against corrosion, rust, and wear caused from abrasive agents.
Ballistic Advantage 16” AR-15 Performance Series barrel for the 5.45 Russian
Unlike the Modern Series, the end of every performance barrels has a recessed 11-degree target crown. Not only does this give the barrel an atheistic boost, it also helps to protect the crown from damage that could affect the bullet’s spin.
Ballistic Advantage’s premium series barrels aren’t cheap by any stretch of the imagination, but they are constructed with a superior craftsmanship that sets then a notch above your average barrel manufacturer. You can expect a Premium Series barrel to run you anywhere between $300 to $400, depending on the length and its specifications.
Ballistic Advantage 18” AR-10 Premium Series barrel for the 6.5 Creedmoor
You can find the Premium Series barrels available for the .223 Wylde, .300 BLK, .308 Win, and 6.5 Creedmoor for your AR-15 and AR-10 builds. Like the Performance Series, every premium barrel has the same 11-degree target crown. But what sets this series apart is the barrel material, 416R Stainless Steel, which was chosen specifically to maximize precision and accuracy.
With the Premium Series, you have the option between choosing a fluted or non-fluted design. And most barrels come threaded, although there are a few unthreaded variants in each of the three series.
Christensen Arms was founded by aerospace engineer, Roland Christensen who envisioned a new way to build superior firearms. The company has a two-decade long reputation of developing some of the finest rifle parts and fully-assembled gun builds around.
Christensen is also the first company to develop the carbon fiber barrel, which tend to trump other barrels in pretty much every way except price.
And boy do they cost more – approximately double the price tag of your finest steel barrel, to be exact. Still, your carbon fiber barrel delivers better accuracy, durability, and barrel life than other barrels on the market, all while being significantly lighter in weight.
Let’s look at a couple carbon fiber barrels for your AR build.
Christensen Arms’ AR-10 Carbon Fiber Barrel
The benefits of this barrel are pretty straightforward. Its carbon fiber design means that you get better accuracy and durability than you would with a 4150 or 4140 steel barrel, and the match-grade 416R stainless steel barrel lining ensures that precision and accuracy is delivered with every shot.
The barrel comes with a threaded muzzle, gives a twist ratio of 1:10”, and weighs under two pounds.
It’s pretty much the same as the AR-10 variant. However, unlike the AR-10, you have more options to choose from when purchasing this carbon fiber barrel.
Christensen Arms AR-15 Carbon Fiber Barrel
It comes chambered for the following calibers:
If you’re looking for a good, lightweight barrel that can carry you through competitive shooting and hunting, Christensen’s carbon fiber AR-15 barrel is a pretty solid choice.
Odin Works is another good company that specializes in making parts for your AR-15 and AR-10 builds.
When it comes to barrels, Odin specializes in high-quality 416R Stainless Steel barrels which have been designed with the sole purpose of providing maximum accuracy. They offer a number of different barrels ranging between $300 and $450 in varying lengths.
In fact, Odin Works is so confident that their barrels are a peg above the rest that they guarantee sub-MOA shooting at 100 yards away.
Here are some of their more popular barrels:
This stainless steel AR-10 barrel is pricier and therefore not ideal for the budget hobbits. But if you are looking to splurge on a match-grade barrel that promises superior accuracy, but you don’t want to drop the extra 150 bucks on a carbon fiber barrel, then look no further.
The barrel comes with a gas tube which has been extended by 2” in order to deliver smoother shooting with high pressure cartridges.
Odin Works 6.5mm Creedmoor 22” Rifle Barrel
Because the 6.5 Creedmoor barrel is fairly long and has an XL gas tube, you can expect it to be a little heavier than others (about 3 ½ pounds), but it’s definitely a must-have for anyone who values accuracy over anything else.
Other features of the barrel include: 1:8” twist rate and 5/8-24 threading.
The 6.5 Grendel is becoming one of the more popular cartridges for the AR-15, and for good reason. It’s accurate, powerful, and not nearly as harsh on the barrel as some of the other heavy hitters out there. With that in mind, it’s never a bad idea to maximize your accuracy with a high-quality 6.5 Grendel barrel like the one from Odin Works.
Like all of Odin Works’ barrels, the 18” Grendel barrel is made from a superior 416R stainless steel in order to guarantee accuracy and precision with every shot. It weighs just under 2 ½ pounds and comes with an intermediate gas tube.
That should do it for my list of favorite AR barrel manufacturers. If you’re shooting with someone else that you swear by, feel free to let us know what you’re working with.
And if you’re new to the AR modding and would like to learn more about upgrading your rifle, take a look at our list of favorite AR-15 upgrades.
And as always, happy shooting.
The post Looking for the Best AR Barrels? Check Out These Manufacturers appeared first on Pew Pew Tactical.
via Pew Pew Tactical
Looking for the Best AR Barrels? Check Out These Manufacturers
After weeks of rumors, the deal is done — Disney will buy up large chunks of Rupert Murdoch’s Fox media empire for $52 billion. The list of what it won’t take is shorter: the Fox News cable channel, broadcast networks and Fox Sports, which are expected to spin off as their own business. The Disney conglomerate adds the Fox movie and TV studios (including big-name franchises like X-Men, Avatar, Alien and The Simpsons), majority control of Hulu, FX cable networks and $13.7 billion in debt. On top of that, Fox is attempting to acquire the parts of UK’s Sky that it doesn’t already own, and if that’s successful then Disney will get it too.
While possible implications for the Marvel Cinematic Universe will come to any comic book movie fan’s mind first — yes, Deadpool and the Fantastic Four are included — this purchase is all about Disney’s place in a changing TV landscape. As cord-cutting has increased and subscribers have shifted away from mainstays like ESPN, Disney is bulking up and preparing to launch its own streaming service in 2019 — which now has a much larger library to pull from.
Developing…
Source: Disney
via Engadget
Disney buys Fox’s studios and cable TV channels for $52 billion
Just in time for Hanukkah, Christmas, and the New Year — our Maker Skill Builder Humble Bundle offers up to $227 worth of killer content for just $20.
Running through Dec. 27 and, as always, supporting the Maker Education Initiative, the final Humble of the year has two mystery books that will be “unlocked” on Wednesday, Dec. 20, and features two brand-new Jumpstarting books written specifically for this event.
Our Humble-only Jumpstarting ebook series provides a quick three-part avenue for makers to swiftly glean topical knowledge. Each book starts with instructions on how to install or initialize the hardware or software needed to reach the all-important “Hello, World” stage. The second project builds on the first to use more of the hardware or software’s capabilities. The final build expands the user’s knowledge into lesser-know aspects of the topic.
All Jumpstarting projects are specifically devised for makers — they provide hands-on, real-world experience in making the hardware or software do what you want it to do.
With this Humble Bundle, we launch Jumpstarting C and Jumpstarting JavaScript, two great tutorials for getting up to speed on these languages well before the resolutions wear off. And there’s nowhere else to get them but here!
Humble Bundles are uniquely gift-able. Set your price, make your purchase, click the gift link, and boom, your holiday shopping is done. Plus: you’ve given to charity. You can grab a discount on a print or digital subscription to Make: magazine too!
Here’s what we’ve got set up for you, and here’s how it goes. We sincerely hope that you love it.
Woodworking for Young Makers Full-color cartoons and drawings lead kids through the steps needed for making a wizard wand, a sanding block, a charging station for your phone or tablet, and a sturdy box with a hidden compartment.
Getting Started with Soldering Just released, this essential book guides makers through the fundamentals of soldering, explains the tools and materials, demonstrates proper techniques, and shows how to fix mistakes or broken connections.
Make: Magazine Volume 55 DIY Robots Build a 3D-printed balancing bot, assemble a Strandbeest-style walker with LEGO, and learn programming with robots. You’ll also find the right robot kit for your needs with our handy overview of what is on the market today.
Minecraft for Makers The only Minecraft book just for Makers! Build real-world versions of familiar objects from the game, like blocks, jack o’lanterns, and mobs. Begin with simple crafting projects, move up to projects with electronics and LEDs, and advance to programmable Arduino projects.
Easy Electronics Best-selling author Charles Platt, whose Make: Electronics books have literally sold millions of copies, introduces the easiest book possibly ever written on the topic. Brilliantly clear graphics take you step by step through 12 basic projects, none of which should take more than half an hour. Using alligator clips to connect components, you will see and hear immediate results. We’re really excited about this one!
mBots for Makers This brand new book is for non-technical parents, kids, and teachers who want to start with a robust robotics platform and then take it to the next level. The heart of the mBot, the mCore, is a powerful Arduino-based microcontroller that can do many things without soldering or breadboarding.
Make: Magazine Volume 57 All Hands on Boards Compare specs for more than 80 brand-new boards in our ever-growing boards guide to choose the right one for your next project. Plus, you’ll find more than 15 hands-on projects! Featuring Limor “Lady Ada” Fried!
Getting Started with the micro:bit Learn how to program with Python and make things with the new board from the BBC. You’ll learn about sensors, Bluetooth communications, IoT, and embedded operating systems.
Getting Started with 3D Carving Learn the basics of 3D drawing from the founder of Inventables and get free online Easel software. Go step-by-step through five beginner projects you can build yourself, and discover aspirational projects from brilliant makers in the 3D carving community.
Modern Leatherwork for Makers Take leather crafting into the 21st century with a guide that marries traditional skills to the latest CNC and 3D printing technologies. This book is perfect for makers new to leatherworking, as well as experienced leatherworkers who want to understand how to integrate new digital fabrication tools into their workbench.
Make: Magazine Volume 58 The Community Issue Explore different ways to tackle large scale projects that are much bigger than one person can handle alone. Get the scoop on how a team of engineers built the giant robot Megabot, learn to build your own autonomous R/C car, and so much more.
Jumpstarting C A Humble exclusive prepared just for this deal and not available anywhere else. This short ebook gets you coding with C in three easy steps.
Jumpstarting JavaScript A Humble exclusive prepared just for this deal and not available anywhere else. This short ebook gets you started with JavaScript in three easy steps.
Zero to Maker, Second Edition The newly revised best-seller by Open ROV co-founder David Lang, this book is for everyone who dreams of becoming a successful maker-entrepreneur. It not only satisfies the aspirational aspect but shows newcomers to the maker movement exactly how to join in.
Design for CNC A manifesto for designing globally and manufacturing locally. Written by the founders of the architecture, design, and research firm Filson and Rohrbacher, this book takes you through the basics of CNC fabrication, the design process, production, and construction of your own furniture designs.
Be alert for the mid-promo adds, to be unlocked on Wednesday, Dec. 20, at 11amPST. They’re super secret, so all we can say is: So much brand-new Arduino goodness! Check back.
via MAKE Magazine
Nab This Humble Bundle Deal of Skill Building Maker Books