Tag: SQL

Feed: Clustrix Blog. Author: Anders Karlsson. Spider is a storage engine for MariaDB Platform that allows you to build distributed databases from a standard MariaDB setup. The technology is not per se complicated, although the implementation is. This blog will explain how the Spider storage engine works, what it does and will also show some of the use cases.MariaDB Storage Engines Before we look at the Spider storage engine, let’s have a quick look at the Storage Engine concept. A storage engine is the implementation of code that manages the low level of data access in MariaDB. The storage engine ... Read More

Feed: Planet MySQL; Author: Severalnines; In the previous blog we showed you how to set up an environment in Amazon AWS EC2 that consists of a Percona Server 8.0 Replication Cluster (in Master - Slave topology). We deployed ProxySQL and we configured our application (Sysbench).  We also used ClusterControl to make the deployment easier, faster and more stable. This is the environment we ended up with... This is how it looks in ClusterControl: In this blog post we are going to review the requirements and show you how, in this setup, you can seamlessly perform master switches. Seamless Master Switch ... Read More

Feed: Planet MySQL; Author: The Pythian Group; In this post, we will explore one approach to MySQL high availability with ProxySQL, Consul and Orchestrator. This is a follow up to my previous post about a similar architecture but using HAProxy instead. I’ve re-used some of the content from that post so that you don’t have to go read through that one, and have everything you need in here. Let’s briefly go over each piece of the puzzle: – ProxySQL is in charge of connecting the application to the appropriate backend (reader or writer). It can be installed on each application ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Sometimes conventional wisdom isn't so conventional, or common. As a case-in-point DBAs may believe that the STREAMS pool is reserved strictly for streams processes. That isn't the case as other Oracle utilities, such as Data Pump and GoldenGate, use that pool. Of course opting to use dynamic management will automatically allocate the required memory when a demand is made, however that memory must come from somewhere. Oracle will 'steal' what it needs from the buffer cache, and it won't be replaced immediately. Let's look at an example proving this, using Data Pump ... Read More

Feed: Planet PostgreSQL. 18 Nov 2019 The OGR FDW now pushes spatial filters down to remote data sources! Whuuuut?!?!? The Basics OK, first, “OGR” is a subcomponent of the GDAL toolkit that allows generic access to dozens of different geospatial file formats. The OGR part handles the “vector” data (points, lines and polygons) and the GDAL part handles the “raster” data (imagery, elevation grids). Second, “FDW” is a “foreign data wrapper”, an extension API for PostgreSQL that allows developers to connect non-database information to the database and present it in the form of a table. The simplest FDWs, like the ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Vincent Granville. Monday newsletter published by Data Science Central. Previous editions can be found here. The contribution flagged with a + is our selection for the picture of the week. To subscribe, follow this link.   Featured Resources and Technical Contributions  Parametric and Non Parametric Bootstrap, Traditional Parametric - Comparison in One Picture Omitted Variables in Linear Regressions Data science for managers: Programming languages Dynamics 365 vs. SAP Business One: All You Need to Know Alternatives to the Gradient Descent Algorithm A Comprehensive Guide to Stochastic Gradient Descent Algorithms How to Detect Objects with Deep ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. How does a major technology services company equip itself to compete in the digital age – and provide services so outstanding that they can significantly advance the business prospects of their customers? All while reducing complexity, cutting costs, and tightening SLAs – in some cases, by 10x or more? For one such company, the solution is to deliver real-time, operational analytics with Kafka and MemSQL. In this company, data flowed through several data stores, and from a relational, SQL database, into NoSQL data stores for batch query processing, and back into SQL for BI, ... Read More

Feed: Recent Announcements. The new monitoring dashboard in the new Redshift Console makes it easier for administrators to monitor all of their Redshift clusters from a single page by unifying all relevant information such as availability status, cluster and query performance, events, and alarms. This lets administrators quickly understand activity associated with their workloads. The new console simplifies the management of Redshift clusters by streamlining user experiences and reducing the number of clicks for everyday operations. You can view your queries associated with workload management queues and correlate them with cluster performance.  The new console reduces the time needed to ... Read More

Feed: Recent Announcements. Parameter Store provides secure, centralized storage for your application configuration data. You can use Parameter Store to separate your configuration data from your application code. The new search experience finds all parameters with names containing your search keyword, making it much easier to find parameters. For example, if you have a large number of parameters in your account and you need to find a parameter that has ‘sql’ in its name, you would just type ‘sql’ in the search box. Parameter Store will return you all the parameters that have the string ‘sql’ anywhere in its name ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; I am wary of papers with performance results for too many products.Too many means including results from systems for which you lack expertise. Wary means I have less faith in the comparison even when the ideas in the paper are awesome. I have expertise in MySQL, MongoDB, RocksDB, WiredTiger and InnoDB but even for them I have made and acknowledged ridiculous mistakes.Database configuration is too hard. There are too many options, most of them aren't significant and the approach is bottom-up. I an expert on this -- in addition to years of tuning I ... Read More