Category: MySQL & MariaDB

Feed: AWS Partner Network (APN) Blog. Author: Sanjay Nighojkar. By Suraj Nathani, Sr. Solutions Architect at Mactores CognitionBy Anil Patel, Data Engineer at Mactores CognitionBy Sanjay Nighojkar, Manager, Partner Solutions Architect at AWSSeagate Technology is a United States-based data storage company with worldwide manufacturing facilities that generate huge amounts of manufacturing and testing data. With petabytes of data accumulated over 20 years, and more being generated each day, it was imperative for Seagate to have systems in place to ensure the cost of collecting, storing, and processing data did not exceed their return on investment (ROI). Seagate’s on-premises big data ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; This is a three-part blog series. Be on the lookout for parts two and three in the coming days.There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems have to deal with these days. This series focuses on dealing with the unexpected high traffic event as it is happening.There are also a lot of things you can do proactively, which we covered in “Prepare Your Databases for High Traffic on ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; We recently released an experimental version of percona-dbaas command-line tool with the goal of significantly simplifying the deployment of database instances in Kubernetes.We have Kubernetes Operators for Percona XtraDB Cluster and Percona Server for MongoDB, which provide great flexibility, but they also come with the complexity of managing configuration and deployment files, so we wanted to make it even simpler to deploy database instances. We found it hard enough to get a MySQL instance up and running in Kubernetes, and then a whole different process to get MongoDB up, and we thought it ... Read More

Feed: Planet MySQL; Author: Continuent; In this blog post, we talk about the basic function and features of the Tungsten Connector.The Tungsten Connector is an intelligent MySQL proxy that provides key high-availability and read-scaling features. This includes the ability to route MySQL queries by inspecting them in-flight. Connector Basics Understanding the Two Key Features The most important function of the Connector is failover handling. When the cluster detects a failed master because the MySQL server port is no longer reachable, the Connectors are signaled and traffic is re-routed to the newly-elected Master node. Next is the ability to route MySQL ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have had the ability to block queries using mysql_query_rules table matching a group of queries using reg exp like a blacklist. Check out a previous blog for how to config “ProxySQL Firewalling” using the mysql_query_rules table.You can improve a whitelist using the mysql_query_rules table, but it is difficult if you have hundreds of queries.ProxySQL 2.0.9 introduces two new tables for the firewall whitelist algorithm: Admin> SELECT name AS tables FROM main.sqlite_master WHERE type='table' AND ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; My previous post related on how to install WordPress on Oracle Cloud seemed to be very popular. To continue the exploration of OCI, today we will install Drupal. This time, even if it’s possible to use the Free Trier like in the WordPress post, I will use a pay account to have the possibility to split the Web Server and the Database into two different subnets. Both instances will have their own subnet and only the Webserver will be reachable directly from the Internet. MySQL will be installed on a private subnet that could ... Read More

Feed: Planet MySQL; Author: Continuent; For this next ‘multi-master MySQL’ blog in our Continuent MySQL Use Case series, we’re focusing on Financial Services Saas providers.Often referred to as the number one open source database in the cloud, and a leading SaaS database, MySQL enables SaaS vendors to be competitive because it provides cost-effective data security and privacy, performance, and availability amongst other things, which are of particular importance for a SaaS business. As per our previous multi-master MySQL use case blog (for e-commerce sites), multi-master replication for MySQL typically means that a user can write to any master node knowing ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical settings that anyone can implement – with no guesswork required.Depending on the version of MySQL you are running, some of the default values used in this post may differ from your install, but the premise is still largely the ... Read More

Feed: Planet MySQL; Author: FromDual; On StackExchange for Database Administrators I recently have seen a question which attracted my interest.The question puzzled me a bit because the answer seems too easy. Further the question was not so clear. An all theses factors smell dangerous... About time - was, is and will be How can I find out if the database "was" shutdown slowly? This is quite easy: Look into your MySQL Error Log and there you will find a log sequence similar to the following: 2020-03-30T08:03:36.928017Z 0 [System] [MY-010910] [Server] /home/mysql/product/mysql-8.0.19-linux-glibc2.12-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.19) MySQL Community Server - GPL.Ups! ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . There are several ways to move data between SQL Server and MariaDB. Here we will discuss them and we will highlight some caveats. Moving Data Definition from SQL Server to MariaDB To copy an SQL Server data structures to MariaDB, one has to: Generate a CSV file from SQL Server data. Modify the syntax so that it works in MariaDB. Run the file in MariaDB. Variables That Affect DDL Statements DDL statements are affected by some server system variables. sql_mode determines the behavior of some SQL statements and expressions, including how strict ... Read More