Watch Stephen Strange Become Doctor Strange in the First Trailer

Here it is, the first trailer for Doctor Strange. We see the accident that ends his medical career and hear him get a rousing pep talk from Tilda Swinton’s Ancient One. Life just gets better and better for him, doesn’t it?

We’ll obviously have more information once we have time to comb through every frame, but for now we’ll just say it’s not totally shocking that so much of this trailer comes from the beginning of the movie, since they just finished filming a week and a half ago. Once you know that, the fact that any of the effects were ready for this trailer is even more impressive.

via Gizmodo
Watch Stephen Strange Become Doctor Strange in the First Trailer

10 Hidden Secrets in Star Wars: The Force Awakens

10 Hidden Secrets in Star Wars: The Force Awakens

As one of the most beloved franchises of all time, The Force Awakens was scrutinized to a degree usually reserved for Pynchon novels by grad students (a treatment Rogue One is already getting as well). As a result, there’s a lot we now know about even the most minute details from the film, and Screen Rant points out ten of the best in a new video.

Much like Jesse Pinkman from Breaking Bad, Poe Dameron was originally supposed to die early on in The Force Awakens. Oscar Isaacs managed to convince JJ Abrams to have the character stick around—and become a fan-favorite, as well as the source of a great deal of slash fiction. Likewise, Luke and Maz both had expanded roles in earlier drafts of the film, but their screen time was cut so that audiences could feel more attachment to the new heroes.

What shocked me—shocked me even more than learning that Kylo Ren’s weird helmet ashtray might be the remains of his victims—was realizing there’s a pretty glaring inconsistency in the film: C3PO’s arm! For most of the film, 3PO has a new matte red arm that’s pretty easy to notice against an all-gold body. It doesn’t look so hot. And in his final scene, the droid’s gold arm is restored. As it turns out, C3PO’s actor—Anthony Daniels—was no fan of the red arm either, and he and Abrams struck this exact compromise.

Watch below for even more interesting tidbits about the film’s backstory. Or don’t, if you’re some kind of traitor.

SPLOID is delicious brain candy. Follow us on Facebook, Twitter, and YouTube.

via Gizmodo
10 Hidden Secrets in Star Wars: The Force Awakens

What to Look for in OS X Crash Reporter When Diagnosing a Crash

What to Look for in OS X Crash Reporter When Diagnosing a Crash

Crash reports are nearly impossible for most of us to understand, but that doesn’t mean you can’t make sense of them. Over on MacIssues, they point to a few things to look for in those crash reports on OS X so you can actually figure out the problem.

Obviously, there’s no single way to diagnose a problem, but there are some key words to look for. For example, “Abort” is a good term to search for to see why a crash happened, and from there you can pinpoint what the issue might be. Perhaps more important is the “Application Specific Information” section of a crash report, which is where you’ll get a slightly more specific diagnosis. In the MacIssues example, they found that a cache file was the culprit behind the crash, so it was pretty easy to troubleshoot the problem from there. If you have a program on OS X that’s crashing a lot and you simply can’t wait for the developer to respond to troubleshooting emails, being able to read that crash report is a useful skill. Head over to MacIssues for a nice overview of what you’ll want to look for.

Using the OS X crash reporter to diagnose a program failure | MacIssues


via Lifehacker
What to Look for in OS X Crash Reporter When Diagnosing a Crash

Artificial Intelligence Sheds New Light on the Origins of the Bible

Artificial Intelligence Sheds New Light on the Origins of the Bible
Inked inscriptions from the fortress of Arad, located in southern Judah. Image: Michael Cordonsky / Tel Aviv University / Israel Antiquities Authority

Twenty six hundred years ago, a band of Judahite soldiers kept watch on their kingdom’s southern border in the final days before Jerusalem was sacked by Nebuchadnezzar. They left behind numerous inscriptions—and now, a groundbreaking digital analysis has revealed how many writers penned them. The research and innovative technology behind it stand to teach us about the origins of the Bible itself.

“It’s well understood that the Bible was not composed in real time but was probably written and edited later,” Arie Shaus, a mathematician at Tel Aviv University told Gizmodo. “The question is, when exactly?”

Shaus is one of several mathematicians and archaeologists trying to broach that question in a radical manner: by using machine learning tools to determine how many people were literate in ancient times. Their first major analysis, which appears today in the Proceedings of the National Academies of Sciences, suggests that the ability to read and write was widespread throughout the Kingdom of Judah, setting the stage for the compilation of Biblical texts.

Although parts of this conclusion remain controversial, the technology behind the study could revolutionize our understanding of literacy and education in Biblical times.

Most scholars agree that the earliest Biblical texts—including the Book of Joshua, Judges, and the two Books of Kings—took shape during what’s known as the late First Temple Period, before Jerusalem fell to the Babylonian king in 586 BCE. But the circumstances surrounding the writing of these texts, including when they were first penned and by how many authors, remain unclear. Curiously enough, texts that have nothing to do with the Bible may shed light on the matter.

Artificial Intelligence Sheds New Light on the Origins of the Bible
Aerial view of the Tel arad fortress, where the inscriptions used in the present study originated. Image: Wikimedia

For instance, during this time period people wrote a wide variety of information down on ceramic pottery shards called ostraca. “These texts are very mundane in nature,” Shaus said, citing military commands and supply orders as some of the more popular topics of discussion.

Aside from how much wine Judahite soldiers required, however, there’s another layer of information we can extract from ostraca: how many people knew how to write. That’s exactly what Shaus and his colleagues did, analyzing a group of 16 well-preserved ceramic shards from a remote military fortress located near the southern border of Judah. Most of these ostraca date to around 600 BCE, practically the eve of the kingdom’s fall.

The first step of this analysis involved the researchers using novel image processing tools to restore characters that had been partially rubbed away. They then developed machine learning algorithms that could compare and contrast the shape of the ancient Hebrew characters in order to identify statistically distinct handwritings. In principle, this is similar to the algorithms tech companies use for digital signature detection.

“Handwriting analysis is a big area that’s seen a lot of research in recent years,” Shaus said. “Nevertheless, we had to develop our own tools and this was quite challenging. The medium is very deteriorated and so is the writing.”

Eventually, the team devised a handwriting recognition tool that worked beautifully on modern Hebrew, and they decided to put it to the test on ancient inscriptions. All in all, their analysis revealed at least six different authors behind the 16 ostraca. Examining the contents of the text itself, the researchers concluded that these authors spanned the entire military chain of command. “The commander down to the lowest water master could all communicate in writing,” Shaus said. “This was an extremely surprising result.”

It’s a result that the researchers say points to a “proliferation of literacy” throughout Judahite society by 600 BCE, implying that the educational infrastructure to support Bible writing almost certainly existed.

But not everyone is comfortable with all aspects of this conclusion.

“This is a highly innovative and important study,” Christopher Rollston, an expert on archaeology and Bible studies at George Washington University told Gizmodo, noting that there’s ample archaeological evidence portions of the Bible were written as early as 800 BCE. But who was really able to write at that time?

“I think that literacy was confined to elites, basically scribes, high military officials, and priests,” Rollston said, adding that by the late First Temple Period, it’s possible reading and writing had spread to more of this upper class.

Perhaps the most important aspect of Shaus’ work is the introduction of sophisticated image recognition technology to the study of ancient texts. The Tel Aviv research group is keen to share their tools for reconstructing letters and deciphering handwriting with other archaeologists. By applying these methods more broadly, we might be able to hone in on when, where, and by whom history’s most enduring book was first written down.

“We’re bringing new evidence to the game,” Shaus said. “Now, we’ll see what else comes out.”

via Gizmodo
Artificial Intelligence Sheds New Light on the Origins of the Bible

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

So, the Rogue One trailer hit the web earlier this week, and it looks awesome. There’s all the hallmarks of the original trilogy, on a war footing, and that means plenty of Original trilogy stormtroopers.

We’ve already spent some time poring over it frame by frame, but I want to look closely at one thing: the armor those troopers are wearing, and what it means for anyone looking to construct a replica costume from the film.

From a costuming and armor perspective, Rogue One is going to be pretty exciting, because the original Stormtrooper armor is an iconic element of the Star Wars universe. For those of us who own Stormtrooper armor already (as opposed to armor from The Force Awakens or The Clone Wars), it’s giving it a new lease on life, especially in front of a generation that’s only seen The Force Awakens.

So, if you’ve built stormtrooper armor in the past, or if you followed my Stormtrooper build this past winter, you might have approached the trailer a little differently, at least on the third or fourth viewings. I wanted to take a close look at the stormtroopers used in this film to see how much they’ve changed since we last saw them on the big screen in 1983.

Stormtrooper armor changes in each Star Wars film: A New Hope troopers have grey frowns and trapezoidal handplates. Empire Strikes Back troopers have curved handplates, black frowns. Return of the Jedi troopers featured new helmet molds, trim around the chest plate, and a couple of other minor differences – all differences that came down to the production design of each film.

When we saw the first pictures from Rogue One in August of last year, we could tell that these troopers would have some small differences. Now that we have our first look at them, we can start to parse out what those differences are.

And, there are differences.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Here’s our first glimpse of the troopers, and we can see that they’re pretty much similar to the ones that we see in A New Hope. The helmet sports the same grey frown, and most of the parts look pretty similar. You can see that the napping trooper’s handplate is trapezoidal, which matches ANH’s troopers.

This makes sense, because the film takes place just before that film, and logically, the troopers would carry over a similar appearance.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Here’s the next shot, with Jyn Erso beating the crap out of an unlucky squad. Take a look at the guy on the ground, and you’ll see some interesting things with his set of armor. Undoubtably, these are ‘stunt’ suits, designed for on-screen action, as opposed to ‘hero’ suits, used for closeups.

There’s two things that I noticed from here:

  1. Looking at the guy on the ground, you can see that his right thigh isn’t completely closed up – there’s either no fasteners or Velcro keeping it shut.
  2. On the same trooper, you can see a shiny black connector holding the chest and back plate together.

The lack of connectors on the legs makes a bit of sense: the original stormtroopers were haphazardly put together, and if you look closely in ANH, you can see tape holding them shut, or just free floating.

The chest thing is new, though. Some costumers use elastic to hold those two parts together in early stormtrooper costumes, but it’s become far less common in recent years.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

The next shot gives us a good look at the back of the armor, and you can pick out a couple of big differences. The kidney plate looks like it’s composed of more than one piece, like they have a plastic plate holding two sides together. The original was molded like that, but this looks like it’s a completely different part. (This is sort of how the TFA armor was assembled)

The other interesting thing here? It looks like the belts aren’t made of canvas, but of the same plastic that makes up the armor. That’s a pretty big change. An early fan sculpted kit known as FX Armor had extra strips of plastic that costumers used for belts – it was riveted to the belt’s front piece and connected with Vecro in in the back. This looks like it could be a similar setup. It makes a certain amount of sense: canvas sags a bit, and if you don’t match the color correctly, it looks strange. If your troopers are moving around a lot, you probably want that as solid as possible.

Other details: the mold on the back plate is sharp, better than some of the fan kits that I’ve seen. The shoulder straps look like they’re firmly connected from front to back plates, which is a minor (but again, completely logical change from the originals), while the details on the detonator look a bit more pronounced.

You can also see that the backs of the thighs are still splitting open on both of those troopers.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Poor troopers. There’s not much to see here, other than to see just what these actors were put through in the film. You certainly don’t want someone’s armor flying off on set.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

One interesting thing here is the knees on the guy in the air: there’s a lot of black showing. Either this guy is a bit taller, or they’ve given them a bit more space to move around.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Now, here’s our first good glimpse of the front. One thing I haven’t noticed in ANY of these pictures is a holster, even though they’re carrying the usual E-11 blaster or a much larger rifle.

This shot shows off some more detail. Look again at the knees of that guy in front: there’s a good amount of space there, and on the left knee, the sniper plate is really far down, which leads me to think that these suits are designed for quite a bit more movement than we’ve seen troopers require in the past. Wearing this armor is tough for movement: if you don’t build your suit right, it’s hard to bend your knees and arms.

The belt boxes also look different – they look longer, and placed a bit further away from the front than the original troopers. There’s also a weird line on the side (which we’ll see clearer in a bit.)

The cool thing about this picture? Variant trooper! During the Clone Wars tv series, Clone variants were a dime a dozen when it came to weird helmets and colors, and it looks like that’s extending over a bit to these guys on the tank: They’ve got a grey or blueish paint over their shoulders, and they’ve got a thing on their forehead. I’m sure we’ll get a better view of them when the toys start coming out.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Here’s another variant: an officer of some sort, looking much like one of the Sand troopers. He’s got a canvas-covered backpack with an antenna sticking out the back.

Also, a shout out to the Rebel Legion: they’re going to have a field day with all the new pilots and rebel officers coming in this movie. We in the 501st particularly like the ‘captured pilot’ look.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures
Screencapture: Sean Walsh

Back to the troopers – the guy with the red pauldron also has a canvas pack. The original sandtroopers just had plastic backbacks cobbled together from – I kid you not – tupperware.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Quick shot of the troopers running, which is probably why the armor’s designed the way it is: for movement. The trooper armor from ANH/ESB/ROTJ are notoriously hard to run or sit down in.

Also, there’s a glimpse of that tan trooper that is new. It’s hard to make out any detail (although a picture of the helmet surfaced a while ago), but they look quite a bit like Scout Troopers.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Here’s where we get our first really good look at the sides of this trooper. There’s some real differences here.

Where the Abs and Kidney plates are two separate parts in the original troopers, there’s either something connecting the two together, or the abs plate is one part that wraps around the actor. I’m not quite sure what to make of that line – it’s either something that’s holding up the belt, or its a seam (which is a weird one). We’ll have to wait until we get another, closer look to understand how that comes together.

It also looks like the butt plate on the trooper closest to us is a separate part from the kidney plate.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Another angle from that scene, and you can see a really thick connector between the back and abs plate. You can also see that the belt connects on the side, and that it really looks like it’s plastic. I’m also really thinking that that back kidney plate is more than one part.

This also gives us a good look at the shoulder straps in the back: There’s a triangle-ish thing connecting them which is completely new.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

The trailer also gave us a good glimpse of the new special-ops type troopers. New helmet (which we’ve seen), but also some looks at the armor. They seem to have some sort of black pauldron and an ammo pack on their shoulders.

So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

Back in February, I posted up a picture of what had been purported to be the new armor for these guys, which was basically the new helmet on top of regular, black stormtrooper armor. Now that we have a good look here, we can see that that’s certainly not the case. Every piece that I can see is really different: the shoulders, upper arms and forearms. To me, it looks really similar to the Republic Commando armor from the old video game.

Plus, they’ve got some some wicked looking guns. Again, we’ll likely get a really good look when the toys start to come out, and in other trailers.

So, what’s to make of all this, other than analyzing the trailer frame by frame again? There’s a couple of takeaways for costumers here.

  1. The film has the original stormtroopers, but like the other films, there’s differences – quite a few of them. For groups like the 501st, this means that there’ll likely be a separate set of requirements for approval of the Rogue One-accurate troopers, and you can’t essentially change out a couple of pieces – there’s a whole bunch of new parts that costumers will need to make. Most people won’t honestly notice this, but it’s an interesting challenge for costumers to try and build based on the images that we have.
  2. Why would costumers opt for a Rogue One-accurate trooper? Partially for bragging rights, especially this early in the game, but there’s a really practical reason: they look like they’re a bit more attuned to movement, and if constructed right, they’d be more comfortable to wear for hours at a time.
  3. The film’s production team has paid some attention to these differences – the frowns and handplates line up with their counterparts in ANH, which is a nice detail to see. They also haven’t just dragged suits from the archives, recasted them and set them out for filming. (Sort of like what they did for the extra scenes in the Special Editions) – these look like newly designed suits.
  4. There’s a bunch of variants: this is in line with Empire Strikes Back and Return of the Jedi, and it’s likely going to be a boon for toy manufacturers. (New action figures!) But, it’s a new variation for costumers to sculpt and construct on their own, which is always exciting to see.
  5. From the film perspective, the suits seem to be designed to stand up to some intense stunts. This is telling in a couple of ways: we’ve seen them get blasted a bit in the trailer, but compared to the Original Trilogy, it looks like they’ll get shot up or blown up quite a bit more. This fits with the fact that this looks more like a war film than a regular saga film.

For costumers like me and members of the 501st Legion, these troopers is another change that we can take a look into and deconstruct to make ourselves. The costuming community prides itself on going super accurate, and this represents a couple of new challenges to figure out. I have mixed feelings on the super accurate depictions, but I think that knowing the differences and looking at the different costumes with that level of detail only helps the final product.

With companies such as ANOVOS selling off-the-shelf kits, stormtrooper armor is getting really easy to purchase, and you’re going to see more of them at conventions and the like.

Is this enough to start building an RO Trooper? Maybe, but there’s still not a whole lot to go on. This is also just the first trailer for a movie coming out months from now: there’ll be plenty of other trailers to pore over before it hits theaters, and we’ll likely learn some other new things from those.

One thing is for sure: anyone who’s picked up a Stormtrooper kit will have a lot of fun on opening night at their local movie theater.

via Gizmodo
So You Want To Join The Empire: What We Learned About Those Rogue One Troopers in 13 Pictures

MySQL Data at Rest Encryption

This blog post will discuss the issues and solutions for MySQL Data at Rest encryption.
Data at Rest Encryption is not only a good-to-have feature, but it is also a requirement for HIPAA, PCI and other regulations.
There are three major ways to solve data encryption at rest:
Full-disk encryption
Database-level (table) encryption
Application-level encryption, where data is encrypted before being inserted into the database
I consider full disk encryption to be the weakest method, as it only protects from someone physically removing the disks from the server. Application-level encryption, on the other hand, is the best: it is the most flexible method with almost no overhead, and it also solves data in-flight encryption. Unfortunately, it is not always possible to change the application code to support application-level encryption, so database-level encryption can be a valuable alternative. Sergei Golubchik, Chief Architect at MariaDB, outlined the pluses and minuses of database level encryption during his
Sergei Golubchik, Chief Architect at MariaDB, outlined the pluses and minuses of database level encryption during his session at Percona Live Amsterdam:
Pros
Full power of DBMS is available
Full power of DBMS is availableEasy to implement
Easy to implementOnly database can see the data
Only databases can see the dataPer-table encryption, per-table keys, performance
Per-table encryption, per-table keys, performanceCannot be done per-user
Cons
Cannot be done per-user
Does not protect against malicious root user
Data at Rest Encryption: Database-Level Options
Currently, there are two options for data at rest encryption at the database level:
MariaDB 10.1.3+ support encryption (using Google patch)
MySQL 5.7.11+ (and Percona Server 5.7.11) has InnoDB tablespace level encryption
MariaDB’s implementation is different from MySQL 5.7.11. MySQL 5.7.11 only encrypts InnoDB tablespace(s), while MariaDB has an option to encrypt undo/redo logs, binary logs/relay logs, etc. However, there are some limitations (especially together with Galera Cluster):
No key rotation in the open source plugin version (MySQL 5.7.11 has a key rotation)
mysqlbinlog does not work with encrypted binlogs (bug reported)
Percona XtraBackup does not work, so we are limited to RSYNC as SST method for Galera Cluster, which is a blocking method (one node will not be available for writes during the SST). The latest Percona XtraBackup works with MySQL 5.7.11 tablespace encryption
The following data is not encrypted (bug reported)
Galera gcache + Galera replication data
General log / slow query log
Database level encryption also has its weakness:
Root and MySQL users can read the keyring file, which defeats the purpose. However, it is possible to place a key on the mounted drive and unmount it when MySQL starts (that can be scripted). The downside of this is that if MySQL crashes, it will not be restarted automatically without human intervention.
Both MariaDB version and MySQL version only encrypt data when writing to disk – data is not encrypted in RAM, so a root user can potentially attach to MySQL with gdb/strace or other tools and read the server memory. In addition, with gdb it is possible to change the root user password structure and then use mysqldump to copy data. Another potential method is to kill MySQL and start it with skip-grant-tables. However, if the key is unmounted (i.e., on USB drive), MySQL will either not start or will not be able to read the encrypted tablespace.
MariaDB Encryption Example
To enable the full level encryption we can add the following options to my.cnf:[mysqld]
plugin-load-add=file_key_management.so
file_key_management_filekey = FILE:/mount/keys/mysql.key
file-key-management-filename = /mount/keys/mysql.enc
innodb-encrypt-tables = ON
innodb-encrypt-log = 1
innodb-encryption-threads=1
encrypt-tmp-disk-tables=1
encrypt-tmp-files=1
encrypt-binlog=1
file_key_management_encryption_algorithm = AES_CTRAfter starting MariaDB with those settings, it will start encrypting the database in the background. The file_key_management plugin is used; unfortunately, it does not support key rotation. The actual keys are encrypted with:# openssl enc -aes-256-cbc -md sha1 -k <key> -in keys.txt -out mysql.encThe encryption <key> is placed in /mount/keys/mysql.key.
After starting MySQL, we can unmount the “/mount/key” partition. In this case, the key will not be available and a potential hacker will not be able to restart MySQL with “–skip-grant-tables” option (without passwords). However, it also prevents normal restarts, especially SSTs (cluster full sync).
Additional notes:
Encryption will affect the compression ratio, especially for the physical backups (logical backups, i.e. mysqldump does not matter as the data retrieved is not encrypted). If your original compressed backup size was only 10% of the database size, it will not be the case for the encrypted tables.
Data is not encrypted in flight and will not be encrypted on the replication slaves unless you enable the same options on the slaves. The encryption is also local to the server, so when encryption was just enabled on a server some tables may not be encrypted yet (but will be eventually)
To check which tables are encrypted, use the Information Schema INNODB_TABLESPACES_ENCRYPTION table, which contains encryption information. To find all tables that are encrypted, use this query:
select * from information_schema.INNODB_TABLESPACES_ENCRYPTION where ENCRYPTION_SCHEME=1
MySQL 5.7 Encryption Example
To enable encryption, add the following option to my.cnf:[mysqld]
early-plugin-load=keyring_file.so
keyring_file_data=/mount/mysql-keyring/keyringAgain, after starting MySQL we can unmount the “/mount/mysql-keyring/” partition.
To start encrypting the tables, we will need to run alter table table_name encryption=’Y’ , as MySQL will not encrypt tables by default.
The latest Percona Xtrabackup also supports encryption, and can backup encrypted tables.
To find all encrypted tablespaces in MySQL/Percona Server 5.7.11, we can use information_schema.INNODB_SYS_TABLESPACES and the flag field. For example, to find normally encrypted tables, use the following query:mysql> select * from information_schema.INNODB_SYS_TABLESPACES where flag = 8225G
*************************** 1. row ***************************
SPACE: 4688
NAME: test/t1
FLAG: 8225
FILE_FORMAT: Barracuda
ROW_FORMAT: Dynamic
PAGE_SIZE: 16384
ZIP_PAGE_SIZE: 0
SPACE_TYPE: Single
FS_BLOCK_SIZE: 4096
FILE_SIZE: 98304
ALLOCATED_SIZE: 98304
*************************** 2. row ***************************
SPACE: 4697
NAME: sbtest/sbtest1_enc
FLAG: 8225
FILE_FORMAT: Barracuda
ROW_FORMAT: Dynamic
PAGE_SIZE: 16384
ZIP_PAGE_SIZE: 0
SPACE_TYPE: Single
FS_BLOCK_SIZE: 4096
FILE_SIZE: 255852544
ALLOCATED_SIZE: 255856640
2 rows in set (0.00 sec)You can also use this query instead: select * from information_schema.tables where CREATE_OPTIONS like ‘%ENCRYPTION="Y"%’;.
Performance overhead
This is a debatable topic, especially for the MariaDB implementation when everything is configured to be encrypted. During my tests I’ve seen ~10% of overhead for the standalone MySQL instance, and ~20% with Galera Cluster.
The MySQL 5.7/Percona Server 5.7 tablespace-level encryption shows an extremely low overhead, however, that needs to be tested in different conditions.
Conclusion
Even with all the above limitations, database-level encryption can be a better option than the filesystem-level encryption if the application can not be changed. However, it is a new feature (especially MySQL 5.7.11 version) and I expect a number of bugs here.
via Planet MySQL
MySQL Data at Rest Encryption

Tennessee Man Builds His Own Gigabit Network Thanks To State’s Protectionist Broadband Law

We’ve noted how Tennessee is one of twenty states that has passed state laws, quite literally written by companies like AT&T, prohibiting towns and cities from wiring themselves with broadband — even if nobody else will. When the FCC announced it would be taking aim at these protectionist broadband laws last year, Tennessee politicians threw a hissy fit, suing the FCC for "violating states rights." That incumbent ISPs are being allowed to write awful state law that’s hampering a generation of business development in the state? Not apparently much of a concern.

As an unsurprising result, Tennessee remains one of the least connected broadband states in the nation, and state residents have increasingly been giving beholden state politicians an earful. Those who can, like Tennessee developer John "Thunder" Thornton, have started taking matters into their own hands and building their own gigabit networks. To do so, Thorton had to get the aid of a power cooperative in Alabama, a state that has a slightly less restrictive municipal broadband law in place:

"Unable to gain high-speed broadband at what he deemed an affordable price from AT&T or Charter Communications and limited from service extensions from EPB’s ultra-fast Internet in Chattanooga, Thornton created his own Internet service provider last year. The private developer spent more than $400,000 to build his own fiber network and link it with a power cooperative in Stevenson, Ala., where fast broadband is available."

According to Thorton, the money he spent to wire his hilltop development cost a third of what AT&T was charging:

"Thornton said when he approached AT&T about providing Gig service to Jasper Highlands he was quoted a price of $1.3 million to serve his mountaintop development — more than three times what it ended up costing Thornton to build his own network connected to Alabama.

"Our costs are much less, but then I don’t have to pay for 27 lobbyists in Nashville like AT&T does," Thornton quipped.

So yeah, Tennessee lawmakers have done such a bang up job letting AT&T write awful state telecommunications law, state residents are being forced to spend their own money to get broadband at a relatively sane price. Sadly, most of the people that can’t get decent broadband can’t afford to go Thorton’s route. And while you’d think the cacophony of complaints from Tennessee residents would be enough to get some movement in the state legislature after a decade, all recent efforts to overturn the state’s protectionist law have gone nowhere.

Tennessee’s law prevents a popular Chattanooga-based utility-run ISP, EPB, from expanding its up to 10 Gbps offerings into any more markets. But attempts to repeal the law earlier this year went nowhere after mammoth pressure from incumbent ISP lobbyists. When that didn’t work, one lawmaker tried to pass a compromise bill that would have allowed EPB to expand into just one neighboring county. That proposal was shot down as well, one of the dissenting votes being that of Rep. Patsy Hazlewood, a former AT&T executive.

That leaves the FCC as the best, current option in getting some of these miserable laws overturned.

As it stands, the FCC is arguing that Section 706 of the Telecommunications Act allows it to preempt state laws that conflict with the agency’s Congressional mandate to guarantee "reasonable and timely" broadband deployment. While there’s twenty such laws, the FCC is currently trying to overturn just two: in Tennessee and North Carolina; the hope being the legal precedent then rolls downhill. But both states have taken the FCC to court, bravely defending their right to take campaign contributions — in exchange for protecting incumbent broadband providers from necessary and inevitable evolution.

Permalink | Comments | Email This Story


via Techdirt.
Tennessee Man Builds His Own Gigabit Network Thanks To State’s Protectionist Broadband Law