Category: MySQL & MariaDB

Feed: Planet MySQL; Author: Continuent; Mastering Continuent Clustering series: Tuning for High-Latency Links | Continuent LtdThis website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read MorePrivacy & Cookies Policy Top ... Read More

Feed: Planet MySQL; Author: Severalnines; One of the cool features in Galera is automatic node provisioning and membership control. If a node fails or loses communication, it will be automatically evicted from the cluster and remain unoperational. As long as the majority of nodes are still communicating (Galera calls this PC - primary component), there is a very high chance the failed node would be able to automatically rejoin, resync and resume the replication once the connectivity is back. Generally, all Galera nodes are equal. They hold the same data set and same role as masters, capable of handling read ... Read More

Feed: Planet MySQL; Author: Tony Darnell; Protected: MySQL 8.0 InnoDB Cluster – Three-server installation of MySQL InnoDB Cluster; MySQL Shell, Router and Group Replication July 13, 2018 Enter your password to view comments. This content is password protected. To view it please enter your password below: Password: Advertisements ... Read More

Feed: Planet MySQL; Author: HowToForge; Nextcloud is a free (Open Source) Dropbox-like software, a fork of the ownCloud project. Nextcloud is written in PHP and JavaScript, it supports many database systems such as MySQL/MariaDB, PostgreSQL, Oracle Database, and SQLite. In order to keep your files synchronized between Desktop and your own server, Nextcloud provides applications for Windows, Linux, and Mac desktops and a mobile app for Android and iOS. Nextcloud is not just a Dropbox clone, it provides additional features like Calendar, Contacts, Schedule tasks, and streaming media with Ampache etc. In this tutorial, we will show you how to ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Vadim Tkachenko | July 13, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0, Percona Server for MySQL PREVIOUS POST Recently, Dimitri published the results of measuring MySQL 8.0 on Intel Optane storage device. In this blog post, I wanted to look at this in more detail and explore the performance of MySQL 8, MySQL 5.7 and Percona Server for MySQL using a similar set up. The Intel Optane is a very capable device, so I was puzzled that Dimitri chose MySQL options that are either not safe or not recommended for production workloads. Since we have an ... Read More

Feed: Planet MySQL; Author: Severalnines; Before you attempt to perform any schema changes on your production databases, you should make sure that you have a rock solid rollback plan; and that your change procedure has been successfully tested and validated in a separate environment. At the same time, it’s your responsibility to make sure that the change causes none or the least possible impact acceptable to the business. It’s definitely not an easy task. In this article, we will take a look at how to perform database changes on MySQL and MariaDB in a controlled way. We will talk about ... Read More

Feed: Planet MySQL; Author: Serge Frezefond; Oracle has done a great technical work with MySQL. Specifically a nice job has been done around security. There is one useful feature that exists in Oracle MySQL and that currently does not exist in MariaDB.Oracle MySQL offers the possibility from within the server to generate asymetric key pairs. It is then possible use them from within the MySQL server to encrypt, decrypt or sign data without exiting the MySQL server. This is a great feature. This is defined as a set of UDF (User Defined Function : CREATE FUNCTION asymmetric_decrypt, asymmetric_encrypt, asymmetric_pub_key … ... Read More

Feed: Planet MySQL; Author: Alexander Rubin; Alexander Rubin | July 12, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0 PREVIOUS POST MySQL stored procedures, functions and triggers are tempting constructs for application developers. However, as I discovered, there can be an impact on database performance when using MySQL stored routines. Not being entirely sure of what I was seeing during a customer visit, I set out to create some simple tests to measure the impact of triggers on database performance. The outcome might surprise you. Why stored routines are not optimal performance wise: short version Recently, I worked with a customer to profile ... Read More

Feed: Planet MySQL; Author: Olivier Dasini; In the old days, when we wanted to strengthen our skills the only option was to buy a good book (this one litteraly changed my life, but also this one, this one, …). Nowadays one can find a lot of resources on the Internet, however quality is often poor :(. Fortunately there are still some great people who are brave enough to write new books that will hopefully have an impact on the new generation of women and men (and the current generation as well) who build modern applications with MySQL, the world’s most ... Read More

Feed: Clustrix Blog. Author: Mike Azevedo. As a database vendor whose drop-in MySQL replacement database runs on-premise and on any cloud, we are often asked by our customers to guide them through a MySQL-compatible cloud database cost comparison. For this process, we have learned it is important to compare the total cost of ownership (TCO) of deploying ClustrixDB on different cloud platforms as compared to the MySQL-compatible offerings from the leading cloud vendors, such as AWS, GCP, and Microsoft Azure. We have discovered some hidden hard and soft costs that are important to consider. In this blog, we will share ... Read More