Tag: MariaDB

Feed: Planet MySQL; Author: Valeriy Kravchuk; Back in April I was preparing for vacations that my wife and I planned to spend in UK. Among other things planned I wanted to visit a customer's office in London and discuss few MySQL and MariaDB related topics, let's call them "stories". I tried to prepare myself for the discussion and collected a list of known active bugs (what else could I do as MySQL entomologist) for each of them. Surely live discussion was not suitable to share lists of bugs (and for some "stories" they were long), so I promised to share ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . In the event that you are using the Linux-based operating system Debian or any of its direct derivatives and would like to compile MariaDB from source code, you can do so using the MariaDB source repository for the release that interests you. For Ubuntu and its derivatives, see Building on Ubuntu. Before you begin, install the software-properties-common and devscripts packages: $ sudo apt-get install software-properties-common devscripts Installing Build Dependencies MariaDB requires a number of packages to compile from source. Fortunately, you can use the MariaDB repositories to retrieve the necessary code for ... Read More

Feed: Planet MySQL; Author: MyDBOPS; In this blog, we will see the very basic thing “I” of “ACID” and an important property of Transaction ie., “ISOLATION” The isolation defines the way in which the MySQL server (InnoDB) separates each transaction from other concurrent running transaction in the server and also ensures that the transactions are processed in a reliable way. If transactions are not isolated then one transaction could modify the data that another transaction is reading hence creating data inconsistency. Isolation levels determine how isolated the transactions are from each other. MySQL supports all four the isolation levels that SQL-Standard defines.The ... Read More

Feed: Planet MySQL; Author: HowToForge; Pimcore is a free and open-source enterprise content management system written in PHP language and uses MySQL/MariaDB for databases. It is fast, flexible, and designer and developer-friendly that allow us to manage and share all of our digital assets across any channel. Pimcore comes with an easy to use administrative backend interface for managing data and system configuration. Pimcore is fully flexible and editable, so you can personalize the site as per your needs. In this tutorial, we will be going to learn how to install Pimcore CMS on Ubuntu 18.04 (Bionic Beaver). Prerequisites A ... Read More

Feed: Planet MySQL; Author: Yves Trudeau; Yves Trudeau | June 21, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Security PREVIOUS POST Why do I spend time blogging about security frameworks? Because, although there are some resources available on the Web, none apply to Percona XtraDB Cluster (PXC) directly. Actually, I rarely encounter a MySQL setup where SELinux is enforced and never when Percona XtraDB Cluster (PXC) or another Galera replication implementation is used. As we’ll see, there are good reasons for that. I originally thought this post would be a simple “how to” but it ended up with a push request to ... Read More

Feed: Planet MySQL; Author: Alena Subotina; We would like to take this moment to thank the Oracle company for continuous development of the popular MySQL database! As you all might know, Oracle has recently released  MySQL Server, v8.0. In its turn, Devart decided to get a move on and release the new dbForge Studio for MySQL, 8.0! Support for MySQL Server 8.0 dbForge Studio for MySQL provides full support for all features of MySQL Server, v.8.0. Thus, you can connect, manage, develop, and administer MySQL databases on the latest server version straight in your favorite MySQL tool! Connectivity Support for ... Read More

Feed: Planet MySQL; Author: Severalnines; As we saw in the first part of this blog, a strongly consistent database cluster like Galera does not play well with container orchestration tools like Kubernetes or Swarm. We showed you how to deploy Galera and configure process management for Docker, so you retain full control of the behaviour.  This blog post is the continuation of that, we are going to look into operation and maintenance of the cluster. To recap some of the main points from the part 1 of this blog, we deployed a three-node Galera cluster, with ProxySQL and Keepalived on ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Rick Golba | June 20, 2018 |  Posted In: Amazon RDS, AWS, Cloud and MySQL, Cloud and NoSQL, MariaDB, MongoDB, MySQL, PostgreSQL PREVIOUS POST Serverless is a new buzzword in the database industry. Even though it gets tossed around often, there is some confusion about what it really means and how it really works. Serverless architectures rely on third-party Backend as a Service (BaaS) services. They can also include custom code that is run in managed, ephemeral containers on a Functions as a Service (FaaS) platform. In comparison to traditional Platform as a Service (PaaS) server ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Additional Dependency Packages exist for 1.1.5, so make sure you install those based on the "Preparing for ColumnStore Installation" Guide. Note: Columnstore.xml modifications you manually made are not automatically carried forward on an upgrade. These modifications will need to be incorporated back into .XML once the upgrade has occurred. The previous configuration file will be saved as /usr/local/mariadb/columnstore/etc/Columnstore.xml.rpmsave. If you have specified a root database password (which is good practice), then you must configure a .my.cnf file with user credentials for the upgrade process to use. Create a .my.cnf file in the ... Read More

Feed: Planet MySQL; Author: Severalnines; RDS is a Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations in comparison to running MySQL directly on Elastic Compute Cloud (EC2). But RDS is a convenient service, as long as you can live with the instances and configurations that it offers. Amazon RDS currently supports various MySQL and MariaDB versions as well as the, MySQL-compatible Amazon Aurora DB engine. It does support replication, but as you may expect from a predefined web console, there are some limitations. Amazon ... Read More