MariaDB is an open source relational database management system (RDBMS) developed as an alternative to MySQL. Galera cluster is used for scalability and reliability in MariaDB. MariaDB provides a visual development environment that allows users to create and customize their databases and resources.
Sign in
On your first visit to the site, you will be presented with the login/signup screen.
When your instance is first created, an account is created for you with the email you chose. You can get the password for this account by going to your Elestio dashboard and clicking on the "Show Password" button.
Enter your email, name and password and click the "Sign in" button
Databases
Databases are containers that organize and store collections of related data. They provide a structured way to store, manage, and retrieve information. A database in MariaDB consists of tables, which are composed of rows and columns. Each table represents a specific entity or concept, and the columns define the attributes or properties of that entity. You can create, modify, and manage databases in MariaDB using the database management tools provided by the MariaDB server. This allows you to organize and maintain your data in a structured and efficient manner. You can add database name and click on the "Create" button to create a new database.
SQL Query Runner
The SQL Query Runner in MariaDB is a tool that allows you to execute SQL queries against your MariaDB database. It provides an interface for writing and running queries, viewing query results, and managing your database. You can use the SQL Query Runner to perform various operations such as selecting data, inserting records, updating data, deleting records, and more. It is a tool for interacting with your database and performing data manipulation tasks.
Status
Status in MariaDB are statistical information about the database and its objects. This information includes details about the size of the database, and other performance related metrics. Status can be useful for monitoring the health and performance of your database, identifying bottlenecks, and optimizing query execution. You can view the status of your database using the status section provided by the MariaDB server. This allows you to monitor and analyze the performance of your database and take appropriate actions to improve its efficiency. This status includes network traffic, memory usage, and other performance related metrics.
Replication
Replication in MariaDB allows you to create and maintain multiple copies of a database on different servers. It enables you to distribute the workload across multiple servers and provides high availability and fault tolerance. With replication, changes made to the primary database are automatically replicated to the replica databases, ensuring data consistency. This can be useful for scaling your application, improving performance, and ensuring data redundancy and disaster recovery.
Managing Settings
Settings in MariaDB are the configuration options that can be customized to modify the behavior and functionality of the MariaDB server. These settings include parameters such as database connection settings, memory allocation, etc. By adjusting these settings, you can optimize the performance, security, and scalability of your MariaDB database server to meet your specific requirements. Users can setup two-factor authentication, change the password, and manage the access and permissions of your database. You can import and export the database that can be useful for integrating your database with other systems or for updating and synchronizing data from external sources.
