Category: MySQL & MariaDB

Feed: Planet MySQL; Author: Michael McLaughlin; Six years ago I wrote a common lookup post to illustrate the effectiveness of things used throughout your applications. Now, I’m updating my student image with a more complete solution to show how to avoid update anomalies. In the prior post, I used a while loop in PHP, like the following: do { ... } while($stmt->next_result()); Using PHP Version 7.3.8 and MySQL 8.0.16, that now raises the following error message: Strict Standards: mysqli_stmt::next_result(): There is no next result set. Please, call mysqli_stmt_more_results()/mysqli_stmt::more_results() to check whether to call this function/method in /var/www/html/app/library.inc on line 81 ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; Somebody didn’t like the MySQLi Update Query example on the tutorialspoint.com website because it use the procedure mysqli_query style. Here’s a simple example of using the object-oriented method version. More or less, instead of query it uses the more intuitive execute() method. The update_member function contains the logic and below it is a call to the test the function. It relies on a MySQLCredentials.inc file that contains the hostname, user name, password, and database name. You can create create member table, like my example in MySQL 8, or any other table in your MySQL ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona announces the release of from the website or install PT-1696: the new pt-pg-summary tool supports PostgreSQL data collection in a way similar to other PT summary tools. The following is a fragment of the report that the tool produces:PT-1741: Migration to a new MongoDB driver was done.PT-1344: pt-online-schema-change failed to detect hostnames with a specified port numberPT-1630: pt-table-checksum had a regression which prevented it from working with Galera clusterPT-1709: pt-upgrade generated “Use of uninitialized value in concatenation (.) or string” error in case of invalid MySQL packetsPT-1728: pt-table-checksum failed to scan small tables that ... Read More

Feed: Planet MySQL; Author: Alena Subotina; .NET Core 3 .NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework. Since then .NET Core has been drastically improved. .NET Core 2.0 has a significant part of Full .NET Framework features and includes new functionality and significant performance optimizations.This year, a new .NET Core 3 is coming. It is currently available as .NET Core 3.0 Preview 9, and despite its preview status, Microsoft officially recommends it to full production use. Besides, Microsoft sends some signals that the development of Full ... Read More

Feed: Planet MySQL; Author: Simon Mudd; If you use replication with MySQL, if you need a backup, if you need a spare copy of a system for testing and for many other reasons you need a way to make a copy of your MySQL system. In the past you could make a copy in various ways: using a cold file system copy with MySQL first shutdownusing MySQL Enterprise Backup, Xtrabackup from Percona or MariaBackup (an Xtrabackup fork). These work against an online running server. However, they required special binaries to run on the source in addition to the traditional mysqld.copying ... Read More

Feed: Planet MySQL; Author: Andrew Grimo; In MySQL 8.0.17 there have been a lot of updates to the MySQL set of offerings. We’ve introduced Cloning into InnoDB Cluster 8.0.17, advances with the MySQL-Router in 8.0.17 and MySQL continues to expand its collection of automation managed features. When Group Replication was first introduced in MySQL 5.7.17, there was considerably less to manage right away compared to a “3-member Async replication setup w/auto-failover“.  Auto-failover tooling requires a lot of thought, determination and coding.  With the advent of Group Replication, MySQL’s users can put aside all that work and let MySQL Server’s Group ... Read More

Feed: Planet MySQL; Author: Continuent; Overview The Skinny In this blog post, we explore the correct way to implement bi-directional Tungsten Replication between AWS Aurora and Tungsten Clustering for MySQL databases. Background The Story When we are approached by a prospect interested in using our solutions, we are proud of our pre-sales process by which that we engage at a very deep technical level to ensure the we provide the best possible solution to meet with the prospect’s requirements. This involves an in-depth hands-on POC, in addition to the significant time and effort we spend building and testing the solution ... Read More

Feed: Planet MySQL; Author: Krunal Lathiya; Laravel 6 CRUD Example | Laravel 6 Tutorial For Beginners is today’s topic. We can upgrade your Laravel’s 6 version by going to this link. Laravel 6 continues the improvements made in Laravel 5.8 by introducing the following features. Semantic versioning Compatibility with Laravel Vapor, Improved authorization responses, Job middleware, Lazy collections, Sub-query improvements, The extraction of frontend scaffolding to the laravel/ui Composer package Content Overview #Server Requirements For Laravel 6 See the following server requirements to run Laravel 6. PHP >= 7.2.0 BCMath PHP Extension Ctype PHP Extension JSON PHP Extension Mbstring PHP Extension ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Contents Generic Backup Process with Storage Snapshots The BACKUP STAGE commands are a set of commands to make it possible to make an efficient external backup tool. These commands could even be used by tools that perform backups by taking a snapshot of a file system, SAN, or some other kind of storage device. Generic Backup Process with Storage Snapshots A tool that backs up MariaDB by taking a snapshot of a file system, SAN, or some other kind of storage device could use each BACKUP STAGE command in the following way: ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The BACKUP STAGE commands are a set of commands to make it possible to make an efficient external backup tool. How Mariabackup uses these commands depends on whether you are using the version that is bundled with MariaDB Community Server or the version that is bundled with MariaDB Enterprise Server. Mariabackup and BACKUP STAGE Commands in MariaDB Community Server The version of Mariabackup that is bundled with MariaDB Community Server does not yet use the BACKUP STAGE commands in an efficient way. In that version, instead of executing the FLUSH TABLES WITH ... Read More