Author: MariaDB Knowledge Database

Feed: MariaDB Knowledge Base Article Feed. Author: . The following is a list of all function differences between MariaDB 10.5 and MySQL 8.0. It is based on functions available in the stable MySQL 8.0.17 and the alpha MariaDB 10.5.0 releases. Present in MariaDB Only Dynamic Columns General CHR LENGTHB VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors. JSON Sequences Window Functions Present in MySQL Only GTID MariaDB and MySQL have differing GTID implementations. GTID_SUBSET GTID_SUBTRACT WAIT_FOR_EXECUTED_GTID_SET WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() Geographic DISTANCE MBRCOVEREDBY ST_BUFFER_STRATEGY ST_DISTANCE_SPHERE ST_GeoHash ST_IsValid ST_LatFromGeoHash ST_LongFromGeoHash ST_PointFromGeoHash ST_SIMPLIFY ST_VALIDATE JSON JSON_OVERLAPS JSON_PRETTY JSON_STORAGE_FREE JSON_STORAGE_SIZE JSON_TABLE ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB has essentially three types of backups: Logical backups (dumps). Hot backups with mariabackup. Incremental backups (binary log). Snapshots. Logical backups Logical backups are usually taken with mysqldump. This will produce the SQL statements needed to recreate MariaDB databases and their data into another server. A dump is the slowest form of backup to restore, because it implies executing all the SQL statements needed to recreate data. However it is also the most flexible, because restoring will work on any MariaDB version. Under certain conditions, MariaDB dumps may also be restored on ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Understanding Accounts and Users MariaDB authorizes access and check permissions on accounts, rather than users. Even if MariaDB supports standard SQL commands like CREATE USER and DROP USER, it is important to remember that it actually works with accounts. An account is specified in the format 'user'@'host'. The quotes are optional and allow to include special characters, like dots. The host part can actually be a pattern, which follows the same syntax used in LIKE comparisons. Patterns are often convenient because they can match several hostnames. Here are some examples. Omitting the ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This page explains how transactions work in MariaDB, and highlights the main differences between MariaDB and SQL Server transactions. Note that XA transactions are handled in a completely different way and are not covered in this page. See XA Transactions. Missing Features These SQL Server features are not available in MariaDB: Autonomous transactions; Distributed transactions. Transactions, Storage Engines and the Binary Log In MariaDB, transactions are optionally implemented by storage engines. The default storage engine, InnoDB, fully supports transactions. Other transactional storage engines include MyRocks and TokuDB. Most storage engines are not ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This page helps to map each SQL Server type to the matching MariaDB type. Numbers In MariaDB numeric types can be declared as SIGNED or UNSIGNED. By default numeric columns are SIGNED, so not specifying either will not break compatibility with SQL Server. For more information see Numeric Data Type Overview. Integer Numbers Real Numbers (approximated) MariaDB supports an alternative syntax: FLOAT(M, D). M is the total number of digits, and D is the number of digits after the decimal point. See also: Floating-point Accuracy. Aliases In SQL Server real is an ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This page contains links and hints to setup MariaDB for testing. The page is designed for SQL Server users, assuming that they are mostly familiar with Windows and they are not familiar with MariaDB. Choosing a MariaDB version As a general rule, for new installations it's better to choose the latest Generally Available version. If you need a feature that is only present in a version that is not yet production ready, and the project will surely not go to production before that version is GA, it could make sense to use ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This event is written into the binary log file for LOAD DATA INFILE events. The event format is similar to a QUERY_EVENT except that it has extra static fields. Event Type = 0x12 Fields Fixed data part: uint The ID of the thread that issued this statement on the master. uint The time in seconds that the statement took to execute. uint The length of the name of the database which was the default database when the statement was executed. This name appears later, in the variable data part. It is necessary ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Some MariaDB features are not available in SQL Server. At a first glance, it is not important to know about those features to migrate from SQL Server to MariaDB. However, this is not the case. Using MariaDB feature that are not in SQL Server allows to obtain more advantages from the migration, getting the most from MariaDB. This page has a list of MariaDB features that are not supported in SQL Server. The list is not exhaustive. Storage engines The sql_mode variable determines in which cases an SQL statements should fail with ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Modern DBMSs implement several advanced features. While an SQL standard exists, the complete feature list is different for every database system. Sometimes different features allow to achieve the same purpose, but with a different logic and different limitations. This is something to keep into account when planning a migration. Some features are implemented by different DBMSs, with a similar logic and similar syntax. But there could be important differences that users should be aware of. This page has a list of SQL Server features that MariaDB implements in a different way, and ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . When planning a migration between different DBMSs, one of the most important aspects to consider is that the new database system will probably miss some features supported by the old one. This is not relevant for all users. The most widely used features are supported by most DBMSs. However, it is important to make a list of unsupported features and check which of them are currently used by applications. In most cases it is possible to implement such features on the application side, or simply stop using them. This page has a ... Read More