Category: Uncategorized

MySQL 8.0 DBA Certification Exam Now Available

https://ift.tt/31wbkt6

You can now earn your MySQL 8.0 DBA Certification Exam is now available. It is Oracle Exam 1Z0-908 and I was one of the many question writers.  Some of you may remember when I was the head of MySQL Certification and I can assure you this is a very complete test of all your MySQL DBA skills. And it asks very relevant questions and not trivial facts. So anyone taking this exam and earning this certification really knows their MySQL!

So what do you need to know:

Architecture

• Configure client connections to the server
• Understand how MySQL stores data
• Understand how InnoDB stores data and logs
• Configure buffers and caches
• Understand and use the Data Dictionary

Security

• Create user accounts and roles
• Use authentication plug-ins
• Control user and role permissions
• Recognize common security risks
• Secure MySQL server connections
• Provide password and login security
• Secure the MySQL host environment
• Prevent SQL injection attacks
• Encrypt MySQL data
• Configure MySQL Enterprise Firewall

Query Optimization

• Examine how MySQL optimizes queries
• Analyze queries with MySQL Enterprise Monitor
• Create indexes to improve server performance
• Monitor and understand index statistics

High Availability Techniques

• Explain how replication provides high availability and scalability
• Configure replication
• Explain the role of the binary log in replication
• Configure multisource replication
• Explain the role of replication threads
• Monitor and troubleshoot replication
• Describe MySQL InnoDB cluster and Group Replication
• Configure a MySQL InnoDB cluster
• Perform an InnoDB cluster recovery

Server Installation and Configuration

• Install and use the MySQL server and client programs
• Identify the files and folders created during installation
• Start and stop MySQL
• Upgrade MySQL
• Configure MySQL by using options and option files
• Configure MySQL variables
• Launch multiple MySQL servers on the same host

Monitoring and Maintenance

• Configure and view MySQL log files
• Monitor MySQL processes and status
• Configure MySQL Enterprise Audit
• Use MySQL Enterprise Monitor to view activity in MySQL
• Monitor database growth and explain capacity planning
• Troubleshoot problems with locked resources

Backups and Recovery

• Distinguish between the different types of backup
• Implement a backup strategy
• Backup and restore data with MySQL Enterprise Backup
• Use mysqldump and mysqlpump to perform logical backups
• Explain when and how to use raw file backups
• Back up the binary log

You can register for your exam here.

technology

via Planet MySQL https://ift.tt/2iO8Ob8

February 6, 2020 at 06:42PM

How Wine Corks Are Made

https://ift.tt/2ulG2ZN

Link

When you pop open a bottle of wine, it’s easy to forget that its stopper comes from a tree. This footage captured by oenophile Jamie Goode at Portugal’s Cork Supply shows us the labor that goes into cutting pieces of cork tree bark, and punching out individual pieces. We wonder what they do with the leftover bark.

fun

via The Awesomer https://theawesomer.com

February 5, 2020 at 12:30PM

Netflix’s horrible autoplay previews can be turned off

https://ift.tt/2vXj77B

Listen, this week sucks. Last week pretty much sucked, too. Honestly, it’s probably time to just scrap this stupid jerk of a year and give 2021 a go. (Spoiler: That one will suck, too.) But you take your victories where you can get them, and Netflix just handed us a beautiful one for once in our sad, miserable lives.

Autoplay trailers are now optional. That’s it. That’s the news. The short but horrible tyranny of autoplay previews are at an end.

Here, do this now:

1. Click Manage Profiles
2. Choose your profile
3. Untick “Autoplay previews while browsing on all devices.
4. Now live, damnit! Live!

Scroll free, friends. 

technology

via TechCrunch https://techcrunch.com

February 6, 2020 at 03:24PM

Guzzle API Requests With Tests

https://ift.tt/2UoG5i5

In this lesson, Bobby Bouwmann shows us how to use Guzzle to make API requests. He’ll also demonstrate how you might go about testing classes that perform lengthy network calls.

Published on Feb 4th, 2020.

programming

via Laracasts https://ift.tt/1eZ1zac

February 4, 2020 at 01:54PM

React Tutorial

https://ift.tt/38q5RGi

programming

via Laravel News Links https://ift.tt/2dvygAJ

February 4, 2020 at 09:54AM

How to Change the Default Storage Path in Laravel

https://ift.tt/38WQNjv

It would be nice if Laravel provided a configuration entry to control which path is used for user uploaded content, or more generally, application data storage such as files, images, and binary data. In Laravel, this directory is known a the storage path

The helper function storage_path calls the container for a path.storage mapping. By default, Laravel populates this entry in Application.php – This is hard coded to directory relative to your applications root directory.

To change this, we can modify the storage path at runtime with a service provider. In this example, we’re modifying the storage path to /webroot/storage, which is the storage directory recommended for PHP apps hosted on Amezmo, but you may change this to any value.

 <?php namespace App\Providers; use Illuminate\Support\ServiceProvider; // Full path: app/Providers/AppServiceProvider.php class AppServiceProvider extends ServiceProvider { /** * Register any application services. * * @return void */ public function register() { $this->app->instance('path.storage', '/webroot/storage'); } /** * Bootstrap any application services. * * @return void */ public function boot() { // } }  

Now, every call to storage_path will return a path to our customized storage directory.

Why would we want to use the $instance property instead of the app helper function? The first reason is that it would be unnecessary to call app because it is identical to the instance property that we already have direct access to. Our service provider extends ServiceProvider, so we have access to the Application instance and we do not need to construct one by hand.

Another reason is that depending on your IDE, you can get nice autocompletion because of the PHP doc block defined on this property.

programming

via Laravel News Links https://ift.tt/2dvygAJ

February 3, 2020 at 10:25AM

VIDEO: Fox Sports Nails It With ‘Ragged Old Flag’ Super Bowl Commercial

https://ift.tt/37YakQM

When it comes to the 2A community, the NFL fails us more often than not. The NFL employs a perpetual anti-gun stance. Then it allowed the fiasco that was the kneeling Colin Kaepernick. So American patriots feel slighted and marginalized repeatedly by the organization running America’s most popular sport. But Fox Sports, and even the NFL, scored a resounding win, for once, with its Ragged Old Flag commercial on Super Bowl Sunday. So since they fail us so often, we’ll give a shout-out when they finally get one right.

RELATED STORY

WATCH: Marine Veteran Streaks Across Field in US Flag Underwear

Ragged Old Flag Commercial

The spot features the iconic voice of the immortal Johnny Cash. In it he voices his 1974 classic “Ragged Old Flag.” Patriotic to its core, the Ragged Old Flag commercial begins with retired Marine Corps Lance Cpl. Kyle Carpenter, a recipient of the nation’s highest military award, the Medal of Honor. Carpenter received the award for his incredibly heroic actions in Afghanistan in 2010.

From there, the spot honors military and first responders alike. It is at times subtle, at times overt, and patriotic to the core throughout. While the commercial never specifically mentions Kaepernick, his supporters nevertheless took to social media to criticize Fox and the NFL for airing the spot. That alone speaks volume to everything good about the Ragged Old Flag commercial.

However, pro gun patriots immediately recognized just how special the commercial is, and how it spoke to veterans and 2A enthusiasts alike.

Ragged Old Flag by Johnny Cash to start the Super Bowl? Inject it into my veins please pic.twitter.com/267yyG2YOo

— Jackson Mahorney (@jacksonmahorney) February 2, 2020

The post VIDEO: Fox Sports Nails It With ‘Ragged Old Flag’ Super Bowl Commercial appeared first on Tactical Life Gun Magazine: Gun News and Gun Reviews.

guns

via Tactical Life Gun Magazine: Gun News and Gun Reviews https://ift.tt/2i7bVLS

February 3, 2020 at 11:09AM

Laravel Log Reader

https://ift.tt/36TOe0o

The Laravel Log Reader gives you a UI to view all your Laravel log files. You can filter logs by date and type, as well as clear them via the UI.

The post Laravel Log Reader appeared first on Laravel News.

Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

programming

via Laravel News https://ift.tt/14pzU0d

February 3, 2020 at 09:03AM

Comic for February 02, 2020

https://ift.tt/2ROGrN8

fun

via Dilbert Daily Strip http://dilbert.com

February 2, 2020 at 02:31AM

Brownells Giving Away Barrel of Freedom Sunday During Super Barrel II

https://ift.tt/2Oecbcj

Press release . . .

Brownells will give away a barrel full of freedom during the biggest pro football Sunday of the year with its Super Barrel II Weekend extravaganza.

One lucky Brownells fan will bring home the championship-worthy trophy of a barrel full of 13,889 rounds of 5.56mm NATO Hornady Frontier 55-grain M193 ammo.

Starting at 12:01 AM Saturday, February 1, and going through 11:59 PM Sunday, February 2, Super Barrel II contestants can sign up for their chance to win at the Brownells Super Barrel II page.

One lucky winner will be drawn by random and will receive the big red barrel full of ‘Merica valued at $4,239.99.

Containing enough ammo to fill almost 70 standard-length belts for an M249, the barrel weighs more than all but the very biggest football linemen. If all 13,889 cartridges contained inside were laid to end-to-end, they would stretch over 870 yards — almost twice as far as the most passing yards ever in a modern pro football championship game.

To sign up to win the Super Barrel II barrel full of ammo, and to see other amazing products, visit www.brownells.com.

About Brownells

Serious About Firearms Since 1939™, Brownells is the world’s leading source for guns, gun parts and accessories, ammunition, gunsmithing tools and survival gear. With a large selection of both common and hard-to-find items, and an extensive collection of videos, articles, and gun schematics, Brownells is the expert for everything shooting-related. Committed to maintaining our great traditions, Brownells has more, does more and knows more – and guarantees it all, Forever. For more information or to place an order, call 800-741-0015 or visit Brownells.com. Stay up-to-date with Brownells on YouTube, Facebook, Twitter and Instagram