MariaDB Interview Preparation Guide

Download PDF

Any released version.

However, MariaDB 5.2.5 and below were all compiled for 32-bit Windows only. These versions of MariaDB will run under 64-bit Windows, but they will run as 32-bit processes.

MariaDB 5.2.6 and above have 64-bit Windows binaries available. 64-bit binaries (and MSI packages) can also be built from the source, as described in Building MariaDB on Windows.

To provide a community developed, stable, and always Free DBMS that is, on the user level, broadly compatible with MySQL.

We strive for interoperability with both our own, and our upstream, communities.

Until MariaDB 5.5, MariaDB was kept up to date with the latest MySQL release from the same branch. For example MariaDB 5.1.47 was up to date with MySQL 5.1.47, and so on.

We did a merge from the main MySQL branch for every new MySQL release or when there was some critical bugfix applied to the main branch.

Since MariaDB 10.0, MariaDB includes backported features from MySQL as well as entirely new features not found anywhere else, but does not necessarily include all MySQL features.

We strive to keep our main trees as free from bugs as possible. It should be reasonably safe to pull from our trees at any time.

If you can't find help in the MariaDB documentation, in many cases the documentation for MySQL can be used. New features of MariaDB are mentioned on the MariaDB versus MySQL page and in greater detail under the MariaDB category.

If you have a question about a feature that is not properly documented or something that is not working as expected, go to the corresponding Knowledge Base page and ask your question there.

You can report and check on bugs which are unique to MariaDB in JIRA. MySQL bugs that also affect MariaDB should also be reported to MySQL.

You can also subscribe to the mailing lists and or join the IRC channel to communicate with MariaDB users and developers.

The MariaDB Corporation offers commercial support for MariaDB and all major MySQL versions (starting from MySQL 3.23).

Following is a list of features of MariaDB:

☛ MariaDB can run on different operating systems and support a wide variety of programming language.
☛ MariaDB follows a standard and popular querying language.
☛ MariaDB provides Galera cluster technology.
☛ MariaDB provides supports for PHP which is the most popular web development language.

LIMIT clause is used with SELECT statement to select a limited number of records from a table. It facilitates you to retrieve records according to your use.

Syntax:
SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT row_count;

MariaDB supports all clauses used in RDBMS. For example:

☛ MariaDB Where Clause
☛ MariaDB Like Clause
☛ MariaDB Order By Clause
☛ MariaDB DISTINCT Clause
☛ MariaDB FROM Clause
☛ Etc.

MariaDB COUNT() aggregate function is used to return the count of an expression.

Syntax:
SELECT COUNT(aggregate_expression)
FROM tables
[WHERE conditions];

MariaDB LEFT OUTER JOIN is used to return all rows from left-hand table specified in the ON condition and only those rows from the other table where the joined condition is satisfied.

LEFT OUTER JOIN is also called LEFT JOIN.

Syntax:
SELECT columns
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column = table2.column;

This will show if they use tools or hack methods.
Normally, replication stops when an error occurs on the slave, so if they force an error that is replicated it would stop the all slaves at the same point in time, an "old school" method to stoping the slaves.

☛ Allow them explain and go into detail about the problem as well as the solution.
☛ Why was it a problem ?
☛ How did you fix it?
☛ Was it a revenue dependent emergency fix?
☛ Did the problem reappear or stay fixed ?