Category: MySQL & MariaDB

Feed: Planet MySQL; Author: MyDBOPS; It is very important for every DBA’s to backup their data frequently so that they can recover data if any problems occur such as Hardware failure, System crashes, Human mistakes. There are several ways to backup MySQL data. They are 1) Physical Backup 2) Logical Backup Physical Backup:               It is also called Raw Backup. It copies the directories and its files that has database contents. Logical Backup:             It is also called Text Backup. It converts all the available rows into single/multiple inserts and also contains create statements to create databases, tables, triggers and so on, ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; On this article, I will show you how to migrate your wordpress database from the MariaDB on CentOS to the real MySQL. Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more powerful (new redo log design, less contention, extreme scale out of InnoDB, …), better operation management (SQL Roles, instant add columns), many (but really many!) replication enhancements and native group replication… and finally many ... Read More

Feed: Planet MySQL; Author: MariaDB; The MariaDB Foundation is pleased to announce the availability of MariaDB 10.2.23, the latest stable release in the MariaDB 10.2 series, and MariaDB Connector/J 2.4.1, the latest stable release in the MariaDB Connector/J 2.4 series. See the release notes and changelogs for details. Download MariaDB 10.2.23 Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/J 2.4.1 Release Notes Changelog About MariaDB Connector/J Contributors to MariaDB 10.2.23 Alexander Barkov (MariaDB Corporation)Alexey Botchkov (MariaDB Corporation)Chris Calender (MariaDB Corporation)Daniel Bartholomew (MariaDB Corporation)Daniel Black (IBM)Elena Stepanova (MariaDB Corporation)Eugene Kosov (Tempesta)Galina Shalygina ... Read More

Feed: Planet MySQL; Author: The Pythian Group; When designing a highly-available MySQL architecture, having a proxy to route the traffic to the appropriate instances is crucial to achieve transparent (or almost) failovers/switchovers. ProxySQL, a popular open source, SQL-level proxy is a great choice for this, and even though an experimental clustering feature is available, we could follow a simpler active-passive approach too, based on Common Address Redundancy Protocol (CARP), which will also provide a highly available IP for the applications to connect. Solution overview As mentioned before, this setup relies on a shared IP configured through CARP on the two ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST If you are using Galera replication, you know that schema changes may be a serious problem. With its current implementation, there is no way even a simple ALTER will be unobtrusive for live production traffic. It is a fact that with the default TOI alter method, Percona XtraDB Cluster (PXC) cluster suspends writes in order to execute the ALTER in the same order on all nodes. For factual data structure changes, we have to adapt to the limitations, and either plan for a maintenance window, or use pt-online-schema-change, where interruptions should ... Read More

Feed: Planet MySQL; Author: Tony Darnell; Adding a replicated MySQL database instance using a Group Replication server as the source March 25, 2019 Leave a comment You say you want a Replication? One of the best features of MySQL is the ability to use MySQL‘s built-in database replication feature to automatically replicate data from one server (source/master) to another (slave/replica). Group Replication was added in MySQL 5.7 as a way to provide a high-availability solution using a new variation of MySQL replication. (In some earlier posts, I explained how to setup Group Replication using three MySQL database servers and how to ... Read More

Feed: Planet MySQL; Author: Scotch.io; On almost every website, you're going to watch to share your Social Media accounts for visitors to follow. In this article, we are going to create a Social Follow component in React! Table of Contents For a deeper dive, check out Using Font Awesome 5 with React! TLDR Create a react app, include Font Awesome libraries, and use the social icons. Check out the finished product. To get started, we are going to use Create React App which is a great tool for scaffolding React applications. For reference, I am going to be doing this ... Read More

Feed: Planet MySQL; Author: Ahmed Bouchefra; Laravel 5.8 is recently released with many improvements so we'll be learning, throughout this tutorial how to create an example CRUD application from scratch. The application we'll be building is a simple CRM with a MySQL database. You can see this Upgrade Guide for instructions on how to upgrade an existing web application from Laravel 5.7 to Laravel 5.8 Tutorial Prerequisites This tutorial has some prerequisites You have at least PHP 7.1.3 installed on your development machine, Working experience of PHP. The OpenSSL, PDO, Mbstring, Tokenizer, XML, Ctype, JSON and BCMath PHP extensions installed ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This upgrade also applies to 1.2.0 Alpha to 1.2.3 GA upgrades Changes in 1.2.1 and later Non-distributed is the default distribution mode in postConfigure The default distribution mode has changed from 'distributed' to 'non-distributed'. During an upgrade, however, the default is to use the distribution mode used in the original installation. The options '-d' and '-n' can always be used to override the default. Non-root user sudo setup Root-level permissions are no longer required to install or upgrade ColumnStore for some types of installations. Installations requiring some level of sudo access, and ... Read More

Feed: Planet MySQL; Author: Ahmed Bouchefra; In this tutorial, you'll learn how to easily add a complete authentication system to your Django application with login, logout and password change and reset functionalities. We'll be using Django with a MySQL database. We'll also be using django-crispy-forms and Bootstrap 4 for styling the application UI. Prerequisites Let's start with the prerequisites for this tutorial. In order to follow the tutorial step by step, you'll need a few requirements, such as: Basic knowledge of Python, Working knowledge of Django (django-admin.py and manage.py), A recent version of Python 3 installed on your system (the ... Read More