Feed: Database Trends and Applications : All Articles. Thales, a provider of cybersecurity and data security solutions, has added new capabilities for its Vormetric Data Security Platform. The new capilities extend data-at-rest security with integrated Docker encryption and access controls, the ability to encrypt and rekey data without having to take applications offline, FIPS certified remote administration and management of data security policies and protections, and the ability to accelerate the deployment of tokenization, static data masking and application encryption.Compliance requirements and best practices increasingly call for organizations to encrypt and control access to sensitive data, while also logging and ... Read More

Feed: Planet PostgreSQL. libpq is getting some improvements in its connection strings to define some properties that are expected from the backend server thanks to the following commit, that will be part of Postgres 10: commit: 721f7bd3cbccaf8c07cad2707826b83f84694832 author: Robert Haas <rhaas@postgresql.org> date: Tue, 29 Nov 2016 12:18:31 -0500 libpq: Add target_session_attrs parameter. Commit 274bb2b3857cc987cfa21d14775cae9b0dababa5 made it possible to specify multiple IPs in a connection string, but that's not good enough for the case where you have a read-write master and a bunch of read-only standbys and want to connect to whichever server is the master at the current time. This ... Read More

Feed: SAS BlogsRSS – SAS Blogs. Author: Robert Allison. Are you ready for the supermoon on December 14? This will actually be the 3rd supermoon in 2016! With these big-looking full moons we're having this year, I got to wondering exactly how big is the moon compared to Earth? This seems like a good question to answer with some SAS graphs!... But before we get started, here's a picture my friend David took of the a supermoon this year. The weather wasn't great, but he managed to get a pretty decent shot! As with most things I'm curious about, I ... Read More

Feed: Planet MySQL. Author: Severalnines. Watch the replay: how to build a stable MySQL Replication environment Thanks to everyone who participated in this week’s webinar on building production-ready MySQL Replication environments. Krzysztof Książek, Senior Support Engineer at Severalnines, shared his top 9 tips on that topic with sanity checks before migrating into MySQL replication setup, operating system configuration, replication, backup, provisioning, performance, schema changes, reporting and disaster recovery. If you'd like to learn how to build a stable environment with MySQL replication, then watch this webinar replay. Watch the replay MySQL on Docker: Deploy a Homogeneous Galera Cluster with etcd ... Read More

Feed: Planet MySQL. Author: GitHub Engineering. GitHub uses MySQL to store its metadata: Issues, Pull Requests, comments, organizations, notifications and so forth. While git repository data does not need MySQL to exist and persist, GitHub’s service does. Authentication, API, and the website itself all require the availability of our MySQL fleet. Our replication topologies span multiple data centers and this poses a challenge not only for availability but also for manageability and operations. Automated failovers We use a classic MySQL master-replicas setup, where the master is the single writer, and replicas are mainly used for read traffic. We expect our ... Read More

Feed: SAS BlogsRSS – SAS Blogs. Author: David Pope. It's that festive time of year again, so you may want to build yourself a fire  and grab a cup of hot chocolate as you prepare for a rousing round of holiday/IT joy. Grab your co-workers and gather around the water cooler while singing along to this post and others from years past like: "Twas the night before big data"; "Rudolf the red-nosed Baysenian network?"; "Big data is coming to town!"; and of course who could forget (you can't, even if you want to!): "The twelve days of big data analytics." ... Read More

Feed: Planet PostgreSQL. Anytime you run a query in Postgres, it needs to compile your SQL into a lower-level plan explaining how exactly to retrieve the data. The more it knows about the tables involved, the smarter the planner can be. To get that information, it gathers statistics about the tables and stores them, predictably enough, in the system table known as pg_statistic. The SQL command ANALYZE is responsible for populating that table. It can be done per-cluster, per-database, per-table, or even per-column. One major pain about analyze is that every table *must* be analyzed after a major upgrade. Whether ... Read More

Feed: Planet MySQL. Author: Codership. IntroductionIf a node leaves the cluster and subsequently rejoins, Galera will internally make sure that the node is brought up to speed with the rest of the cluster. It is important for DBAs that this process completes quickly, so ideally SST is avoided altogether and IST is used. However, when looking at the log, SST is still mentioned even if IST is ultimately chosen, which may cause confusion.In this article, we will describe the entire process of getting a restarted node back to speed with the rest of the cluster and explain the logic behind ... Read More

Feed: SAS BlogsRSS – SAS Blogs. Author: Joyce Norris-Montanari. In the first blog of this four-part series, we discussed traditional data management and how it can apply these principles to our big data platforms. We also discussed how metadata can help bridge the gap of understanding the data as we move to newer technologies. Part 2 will focus on transformation and movement metadata. We move data – no doubt about that. We redundantly store, and transform, to various data stores across the enterprise. WHEW – now that we've gotten that out of the way, let’s talk transformation and movement metadata ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Emmanuelle Rieuf. This article was written by Jason O’Rawe on ODSC. Jason is an ODSC data science team contributor.   Twitter is an indispensable resource for data scientists as well as for the broader data science community. With the right connections, you can use twitter to learn data science, discover new technologies, computational tools and methodologies, and you can contribute to and build a community of data scientists working for the social good. Indeed, we at the ODSC use twitter to spread the word about the great data science speakers and workshops happening conference ... Read More