» » LinuxCBT MariaDB 5 - mdb5x

Information of news
  • Author: BaDshaH
  • Date: 3-11-2015, 10:17
3-11-2015, 10:17

LinuxCBT MariaDB 5 - mdb5x

Category: Tutorials

MariaDB Installation
Introduction to MariaDB5x
Explore topology | target systems
Install MariaDB on targets
Highlight important directories | files
Contrast with MySQL
Identify key MariaDB clients
Terminal Monitor Shell Client
Explore Terminal Monitor interface
Explore defaults
Escape to and use SHELL as needed
Secure installation

MariaDB Client
Identify primary client
Use client to connect to MariaDB targets
Execute SQL queries as needed
Interact interactively | non-interactively

Secure Client
Implement secure connectivity with SSH
Ensure client | server communications are secure
Contrast connection options
Perform queries as needed
Confirm equal functionality
Enable TLS security
Force TLS | SSL connectivity
Contrast both secure methods

GUI Management | PHPMyAdmin
Obtain and install latest PHPMyAdmin Web Management Tool
Secure connection with TLS
Test connectivity using multiple users
Explore the rich PHPMyAdmin Interface
Import data via GUI interface

Data Dump
Explain available options
Connect and dump data to flat files
Import | Export dumped data
Dump DBs | Tables selectively
Encrypt dumped data

Data Import
Format data for import
Perform SHELL-based imports
Compare imported structures
Debug malformations
Tie imports to specific tables
Evaluate performance

Miscellaneous Queries
Identify system stats
Identify available users
Enumerate processes
Find various LOG data
JOIN as needed

Discuss performance enhancements
Discuss current limitations
Implement indexes on key columns
Evaluate performance improvements
Import large sets
Compare post-index performance
Use Aria storage engine for Full-Text Index support

Find use-cases for Views
Implement as desired
Compare required queries

I recommends Buy premimum account for High speed+parallel downloads!




Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

free html hit counter