Tag: MySQL

Feed: Planet MySQL; Author: Percona Community; Francisco Miguel Biete Banon  | December 13, 2019 |  Posted In: Intermediate Level, MySQL, Percona Server for MySQLDatabase administrators are responsible for maintaining the privacy and integrity of data. When the data contains confidential information, your company has a legal obligation to ensure that privacy is maintained. Even so, being able to access the information contained in that dataset, for example for testing or reporting purposes, has great value so what to do? MySQL Enterprise Edition offers data masking and de-identification, so I decided to contribute similar functionality to Percona Server for MySQL. In this post, ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; With Puppet we build infrastructures, piece by piece, manifest after manifest. We control how nodes are configured, what services they provide, how they are checked. We manage where web applications stay and sometimes how they are built, tested, and deployed. Puppet has a lot of knowledge about our systems. Every catalog we receive is an unique source of data that is exactly what brings our servers to the desired state. The more information we provide in our manifests about the system, the more we can things we can do with it. Puppi tries ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; DEPRECATION NOTICE: This article is no longer relevant and exists for historical purposes only. The Ruby DSL was an experimental project that added the ability to write Puppet code in pure Ruby. It was never widely adopted and was eventually completely removed in Puppet 4.0. The new Ruby DSL for Puppet (available in 2.6.0 and later) has introduced lots of interesting new ways you can articulate Puppet code.  One of the more interesting new ways is the ability to mix and match Ruby code with the Puppet Ruby DSL.  I'm going to show ... Read More

Feed: DB-Engines.com Blog. Author: Paul Andlinger. Blog > Postby Paul Andlinger, 12 December 2019Tags: Amazon Aurora, Amazon DynamoDB, Amazon Redshift, DBaaS, Firebase Realtime Database, Google BigQuery, Google Cloud Firestore, Microsoft Azure DocumentDB, Microsoft Azure Search, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DatabaseCloud-based database management systems are continuously increasing in popularity. We analyze the trends and show the big players. About three years ago we were writing about the popularity of cloud-based DBMS’s. At that time the popularity of those systems just had increased to 1.6% of the overall popularity of all DBMS’s. We think it is time to ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL and PHP is a love story that started long time ago. However the love story with MySQL 8.0 was a bit slower to start… but don’t worry it rules now ! The support of MySQL 8.0’s new default authentication method in PHP took some time and was added in PHP 7.2.8 but removed in PHP 7.2.11. Now it’s fully supported in PHP 7.4 ! If you have installed PHP 7.4, you can see that the new plugin auth_plugin_caching_sha2_passwordis now available: # php -i | grep "Loaded plugins|PHP Version " | tail -n2 PHP ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; Introduction In this article, we are going to see how a CROSS JOIN works, and we will also make use of this SQL join type to build a poker card game. Database table model For our poker card game application, we have created the ranks and suits database tables: The ranks table defines the ranking of cards, as well as the name and symbol used for each card rank: | name | symbol | rank_value | |-------|--------|------------| | Ace | A | 14 | | King | K | 13 | | Queen | ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; In my road trip of the Open Source projects using MySQL, after having tested WordPress, Drupal and Joomla, let’s try to install Magento using MySQL 8.0 ! In Magento’s manual, we can see that the project requires MySQL 5.6 and supports 5.7.x since versoin 2.1.2. In my test, I will use Magento 2.3.3, the latest stable when writing this article. The manual stipulates that we should use ROW based replication but not GTID because Magento 2 is using CREATE TEMPORARY TABLE inside transactions. In fact, this limitation doesn’t exist anymore since MySQL 8.0.13. From ... Read More

Feed: The Connector by Workato. Author: Katharine Marais; Founded in 2013, Fundbox is a market-leading B2B payments and credit network designed to facilitate and accelerate B2B commerce at scale,. With Fundbox, sellers (of all sizes) can quickly increase average order volumes (AOV) and improve close rates by offering more competitive net terms and payment plans to their SMB buyers. With heavy investments in machine learning and the ability to quickly analyze transactional data, Fundbox is reimagining B2B payments and credit products in new category-defining ways.. Fundbox’s novel approach involves making data-driven decisions, rather than business owner information that traditional banks ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; To avoid infinite replication loops MySQL doesn’t allow you to have log_slave_updates and replicate-same-server-id. When using GTIDs that may lead to something not expected that you may not be aware of. In this scenario, we have 2 MySQL servers using GTID. The sever uuid part of the GTID has been modified in the illustration to make it more clear. Both servers have log_slave_updates enabled too: So far nothing unusual. So let’s write data on the master (MySQL A): We can see that this first transaction is identified by its GTID where the uuid matches ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB architecture is partly different from the architecture of traditional DBMSs, like SQL Server. Here we will examine the main components that a new MariaDB DBA needs to know. We will also discuss a bit of history, because this may help understand MariaDB philosophy and certain design choices. This section is an overview of the most important components. More information is included in specific section of this migration guide, or in other pages of the MariaDB KnowledgeBase (see the links scattered over the text). Storage engines MariaDB was born from the source ... Read More