Tag: MariaDB

Feed: MemSQL Blog. Author: Rick Negrin. There is a trend in industry which says that modern applications need to be built on top of one or more special-purpose databases. That every application benefits from using the best-of-breed technology for each requirement. And that the plethora of special-purpose options available from certain cloud providers is reasonable to manage. That’s all BUNK. The reality is that navigating the choices, figuring out how to use them effectively, and dealing with the ETL and inevitable data sprawl, is so difficult that the pain far outweighs any technical advantage you might get. In the vast ... Read More

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: Puppet.com Blog RSS Feed. Author: ; One of the best ways to ensure good, solid security on systems across your organization is to establish baselines defining a minimum set of standards for access, firewalls and services. Puppet can help you define, build, and maintain those configuration management baselines in a straightforward way that’s just not possible when working at scale.In this blog post, I cover a few basic steps you can take with Puppet to improve your security by building in some basic assertions about the state of your servers. We'll start with defining manifests that limit access to ... Read More

Feed: Clustrix Blog. Author: Shane Johnson. In the twenties, the 2020s that is, what separates a modern application from the others?A modern application runs in the cloud (of course!) and enriches standard transactions with real-time analytics to create an insightful experience. This should come as no surprise. As customers, we continuously expect more from businesses when it comes to the value of interacting with them online. To address modern application requirements, today’s database needs both smart transactions and a cloud-native architecture. Smart transactions What’s a smart transaction you say? Let’s start with a few examples. Displaying a day’s flights is ... Read More

Feed: Clustrix Blog. Author: MariaDB Documentation Team. MariaDB Platform X4 provides a single database stack that delivers cloud-native storage and smart transactions on a single platform. Platform X4 incorporates MariaDB Enterprise Server 10.4, MariaDB MaxScale 2.4, and MariaDB ColumnStore 1.4.MariaDB Enterprise Server, currently version 10.4.11-5, is a 100% Open Source modern SQL database that extends the capabilities of the widely-deployed MariaDB Community Server with advanced enterprise-focused features, optimized builds, and a predictable release schedule. Available: Deployment instructions MariaDB ColumnStore, a columnar storage engine has long been available as a custom fork of MariaDB Server, delivering analytical processing (OLAP) capabilities, and ... Read More

Feed: Planet MySQL; Author: Ahmed Bouchefra; Receive new Django tutorials. Receive new Python tutorials. Django 3 is released with full async support! In this tutorial, we'll see by example how to create a CRUD application from scratch and step by step. We'll see how to configure a MySQL database, enable the admin interface, and create the django views. We'll be using Bootstrap 4 for styling. You'll learn how to: Implement CRUD operations, Configure and access a MySQL database, Create django views, templates and urls, Style the UI with Bootstrap 4 Django 3 Features Django 3 comes with many new features ... Read More

Feed: Planet MySQL; Author: Severalnines; The management of database performance is an area that businesses when administrators often find themselves contributing more time to than they expected. Monitoring and reacting to the production database performance issues is one of the most critical tasks within a database administrator job. It is an ongoing process that requires constant care. Application and underlying databases usually evolve with time; grow in size, number of users, workload, schema changes that come with code changes. Long-running queries are seldom inevitable in a MySQL database. In some circumstances, a long-running query may be a harmful event. If ... 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: Planet MySQL; Author: Ahmed Bouchefra; Receive new Django tutorials. Receive new Python tutorials. Django 3 is released with full async support! In this tutorial series, you'll learn about Django 3 by creating a CRUD example application with database, admin access, and REST API views. We'll be using MySQL as the database system. Throughout this beginner's tutorial for Django 3, we are going to learn to build web applications with Python and Django. This tutorial assumes no prior experience with Django, so we'll be covering the basic concepts and elements of the Django framework by emphasizing essential theory with practice ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; MySQL obviously got many things right, otherwise, it would not be the World’s Most Popular Open Source Database (according to DB-Engines). Sometimes, however, I run into some decisions or behaviors which are just plain bad designs. Many such designs have a lot of historical reasoning behind them and maybe they are still here because not enough resources are allocated to cleaning up technical debt.I’m passionate about observability, especially when it comes to understanding system performance. One of the most important pieces of data to understand MySQL Performance is understanding its latches contention (mutexes, ... Read More