Tag: MariaDB

Feed: Planet MySQL; Author: Monyog; Author: Robert AgarTuning database performance is a complicated task that can be a thorn in the side of the database team. There are many interconnected components and environmental aspects that come under consideration when attempting to optimize the performance of your database systems. A DBA can be hard-pressed to determine where to begin their optimization efforts. An initial investigation may concentrate on the network and hardware on which the database is running. These inquiries may uncover issues that can be easily identified and addressed. It may be a simple matter of adding some disk space ... Read More

Feed: Planet MySQL; Author: Severalnines; Complex, inflexible architectures, redundancy and out-of-date technology, are common problems for companies facing data to cloud migration.  We look to the “clouds,” hoping that we will find there a magic solution to improve operational speed and performance, better workload and scalability, less prone and less complicated architectures. We hope to make our database administrator's life more comfortable. But is it really always a case?  As more enterprises are moving to the cloud, the hybrid model is actually becoming more popular. The hybrid model is seen as a safe model for many businesses.  In fact, it's ... Read More

Feed: Planet MySQL; Author: Percona Community; Geoff Winans  | August 14, 2019 |  Posted In: MariaDB, MySQL, ToolsIn my roles as a DBA at various companies, I generally found the tooling to be quite lacking. Everything from metrics collection, alerting, backup management; they were either missing, incomplete or implemented poorly. DBA-Tools was born from a desire to build backup tools that supported my needs in smaller/non-cloud environments. As BASH is easily the most common shell available out there on systems running MySQL® or MariaDB®, it was an easy choice.How DBA-Tools came to beWhile rebuilding my home-lab two years ago, I decided I ... Read More

Feed: Planet MySQL; Author: FromDual; FromDual has the pleasure to announce the release of the new version 0.9.2 of its popular FromDual Ops Center for MariaDB and MySQL focmm.The FromDual Ops Center for MariaDB and MySQL (focmm) helps DBA's and System Administrators to manage MariaDB and MySQL database farms. Ops Center makes DBA and Admins life easier! The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks. More information about FromDual Ops Center you can find here. Download The new FromDual Ops Center for MariaDB and MySQL (focmm) can be downloaded from ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; ProxySQL 2.0.5, released by ProxySQL, is now available for download in the Percona Repository along with Percona’s proxysql-admin tool.ProxySQL is a high-performance proxy, currently for MySQL and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.This release includes in the wiki format.ProxySQL 2.0.5 ImprovementsPSQLADM-51: Update mysql-server_version variable. The --update-mysql-version command has been added to set the mysql-server_version__ global variable in ProxySQL.  This ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; It's Saturday night. I have a week of vacation ahead that I am going to spend at home, working on things I usually do not have time for. I already did something useful (created a couple of test cases for MariaDB bugs here and there, among other things), so why not to get some fun and continue my previous review of recent interesting MySQL bug report...So, here is the list of 15 more MySQL community bug reports that I've subscribed to back in May and June 2019:Bug #95491 - "The unused wake up in simulator ... Read More

Feed: Planet MySQL; Author: Codership; Through Amazon Web Services (AWS), you can create virtual servers (i.e., instances). You can install database and Galera software on them. In this article, we’ll create three nodes, the minimum recommended for a healthy cluster, and configure them to use Galera Cluster. Incidentally, there is a more detailed version of this article in the Tutorial section of our Library. Assumptions & Preparation We’re assuming you have an AWS account and know the basics of the EC2 (Elastic Compute Cloud) platform. To access the nodes, you’ll need an encryption key. Create a new one specifically for ... Read More

Feed: AWS Big Data Blog. A data lake is a centralized store of a variety of data types for analysis by multiple analytics approaches and groups. Many organizations are moving their data into a data lake. In this post, I explore how you can use AWS Lake Formation to build, secure, and manage data lakes.Traditionally, organizations have kept data in a rigid, single-purpose system, such as an on-premises data warehouse appliance. Similarly, they have analyzed data using a single method, such as predefined BI reports. Moving data between databases or for use with different approaches, like machine learning (ML) or ... Read More

Feed: Planet MySQL; Author: Continuent; Overview The Skinny Part of the power of Tungsten Clustering for MySQL / MariaDB is its intelligent MySQL Proxy, known as the Tungsten Connector. The Tungsten Connector has built-in read-write splitting capabilities, and it is also possible to configure different algorithms which select the appropriate slave (i.e. Round-Robin or Lowest-Latency). The Question Recently, a customer asked us: How do we best share the load between read-only slaves? Currently, there appears to be an imbalance, with most of the read-only queries reaching just one slave. What may we do to improve this situation? This customer noticed ... Read More

Feed: Planet MySQL; Author: HowToForge; Matomo (formerly Piwik) is a free and open-source web analytics application developed by a team of international developers, that runs on a PHP/MySQL webserver. It tracks online visits to one or more websites and displays reports on these visits for analysis. You can think of it as an alternative to Google Analytics. Matomo is an open-source and its code is publicly available on Github. Some of the features it has are - A/B Testing, Heatmaps, Funnels, Tracking and Reporting API, Google AdWords, Facebook Ads, Bing Ads, Cost Per Click (CPC), etc. This tutorial will show you how to install Matomo ... Read More