Maria Mysql Database

Introduction

MariaDB Server is one of the world’s most popular open source relational databases and is available in the standard repositories of all major Linux distributions.
This page intends to show you where to find the documentation.

phpMyAdmin is (as the name says) written in PHP and uses MySQL.
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
phpMyAdmin supports a wide range of operations on MySQL and MariaDB.
Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
Besides this, we also need people skilled in HTML, JavaScript and CSS, as these are all parts that make our user interface. Mbr>You don't have to be an expert in all these areas - even knowing only one of them, you can still provide substantial help in creating or debugging some features.

ToC MariaDB-Documentation

The following list is a Table of Content (ToC) for the Maria Database Documentation.

Using MariaDB Server

• https://mariadb.com/kb/en/sql-statements-structure
  • SQL Statements & Structure, SQL statements, structure, and rules.
• https://mariadb.com/kb/en/built-in-functions
  • Built-in Functions, Functions and procedures in MariaDB.
• https://mariadb.com/kb/en/clients-utilities
  • Clients & Utilities, Client and utility programs for MariaDB.

MariaDB Administration

• https://mariadb.com/kb/en/getting-installing-and-upgrading-mariadb
  • Getting, Installing, and Upgrading MariaDB, Getting, installing, and upgrading MariaDB Server and related software.
• https://mariadb.com/kb/en/user-server-security
  • User & Server Security, Creating users, granting privileges, and encryption.
• https://mariadb.com/kb/en/backing-up-and-restoring-databases
  • Backing Up and Restoring Databases, Tools and methods for backing up and restoring databases.
• https://mariadb.com/kb/en/server-monitoring-logs
  • Server Monitoring & Logs, Monitoring MariaDB Server and enabling and using logs.
• https://mariadb.com/kb/en/partitioning-tables
  • Partitioning Tables, Splitting huge tables into multiple table files.
• https://mariadb.com/kb/en/mariadb-audit-plugin
  • MariaDB Audit Plugin, Logging user activity with the MariaDB Audit Plugin.
• https://mariadb.com/kb/en/variables-and-modes
  • Variables and Modes, Server variables and SQL modes.
• https://mariadb.com/kb/en/copying-tables-between-different-mariadb-databases-and-mariadb-servers
  • Copying Tables Between Different MariaDB Databases and MariaDB Servers, Copy table files.

High Availability & Performance Tuning

• https://mariadb.com/kb/en/standard-replication
  • MariaDB Replication, Documentation on standard primary and replica replication.
• https://mariadb.com/kb/en/galera-cluster
  • MariaDB Galera Cluster, MariaDB Galera Cluster is a virtually synchronous multi-master cluster.
• https://mariadb.com/kb/en/optimization-and-tuning
  • Optimization and Tuning, Using indexes, writing better queries and adjusting variables for better performance.
• https://mariadb.com/kb/en/connection-redirection-mechanism-in-the-mariadb-clientserver-protocol/
  • Connection Redirection Mechanism in the MariaDB Client/Server Protocol, Connection Redirection Mechanism in the MariaDB Client/Server Protocol.
• https://mariadb.com/kb/en/multi-master-in-maria-db
  • Question: Multi Master in maria db, Can we configure Multi Master in Maria Db. I have testing three node A, B, ...
• https://mariadb.com/kb/en/multi-master-replication-and-deadlock-detection-in-galera-with-mariadbs
  • Question: Multi master replication and deadlock detection in Galera with Mariadbs, Hi, We have multi master Galera replication setup where three master maria...

Columns, Storage Engines, and Plugins

• https://mariadb.com/kb/en/data-types
  • Data Types, Data types for columns in MariaDB tables.
• https://mariadb.com/kb/en/character-sets
  • Character Sets and Collations, Setting character set and collation for a language.
• https://mariadb.com/kb/en/storage-engines
  • Storage Engines, Various storage engines available for MariaDB.
• https://mariadb.com/kb/en/plugins
  • Plugins, Documentation on MariaDB Server plugins.

Programming & Customizing MariaDB

• https://mariadb.com/kb/en/programmatic-compound-statements
  • Programmatic & Compound Statements, Compound SQL statements for stored routines and in general.
• https://mariadb.com/kb/en/stored-routines
  • Stored Routines, Stored procedures and functions.
• https://mariadb.com/kb/en/triggers-events
  • Triggers & Events, Creating triggers and scheduled events within MariaDB.
• https://mariadb.com/kb/en/views
  • Views, Stored queries for generating a virtual table.
• https://mariadb.com/kb/en/user-defined-functions
  • User-Defined Functions, Extending MariaDB with custom functions.
• https://mariadb.com/kb/en/assertion
  • Question: assertion, how to create assertion in mariadb?

Other MariaDB Server Documentation Articles

• https://mariadb.com/kb/en/mariadb-platform-x3
  • MariaDB Platform X3, MariaDB Platform X3 integrates MariaDB Server, MariaDB ColumnStore, and Mar...

Docu Links

• Mariadb.com, Maria Database Documentation
• dbadmin One, dbadmin.one.com], PHP-Admin Documentation
• phpmyadm.net, Webinterface for MySQL and MariaDB.
• github, phpmyadmin