Tag: Cache

Feed: Planet MySQL; Author: Tony Darnell; MySQL 8.0 Group Replication – Three-server installation July 13, 2018 Leave a comment MySQL InnoDB Cluster was introduced in MySQL version 5.7. MySQL InnoDB Cluster consists of three parts – Group Replication, MySQL Shell and MySQL Router. MySQL InnoDB Cluster provides a complete high availability solution for MySQL. I am not going to go into the details of InnoDB Cluster and how it works, as there are enough manual pages and blogs to cover these topics. MySQL InnoDB Cluster manual Blog sites: mysqlhighavailability.com and mysqlserverteam.com. Instead, I will be showing you how to install Group ... Read More

Feed: Planet MySQL; Author: MinervaDB; Recently one of our prospective customers asked this question, “We use Amazon RDS for MySQL, Do we still need a MySQL Database Architect / DBA / Engineer? ”  The quick answer is – Yes,  you still need a MySQL DBA to solve problems which Amazon RDS or Amazon Aurora for MySQL cannot solve, We spend almost 6 hours in meeting, helping the customer to understand how cloud Database Infrastructure and Database as a Service (DBaaS) simplifies Database Infrastructure provisioning and rolling-out scalability and high availability solutions faster across multiple locations, This post is about how ... Read More

Feed: What's New. AppSync also now supports HTTP endpoints as data sources, in addition to existing support for DynamoDB, ElasticSearch and Lambda. This enables customers to use their existing backend services that use REST APIs with AppSync to leverage the power of GraphQL interfaces. AWS AppSync also has added support for enhanced GraphQL scalar types such as email addresses, phone numbers, JSON objects, and more. This functionality allows customers to perform validation for common use cases on a per-field level, and results can be passed through and stored inside your data source of choice. In addition to these new schema ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Francisco Bordenave | July 16, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, MySQL, open source databases PREVIOUS POST MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group replication. Now we will go through the second component, MySQL Router.  We will address MySQL Shell in a final instalment of this three-part series. By then, you should have a good overview of the features offeed by MySQL InnoDB Cluster. MySQL ... Read More

Feed: R-bloggers. Author: filip Schouwenaars. The problem pkgdown is an R package that can create a beautifully looking website for your own R package. Built and maintained by Hadley Wickham and his gang of prolific contributors, this package can parse the documentation files and vignettes for your package and builds a website from them with a single command: build_site(). This is what such a pkgdown-generated website looks like in action. The html files that pkgdown generated are stored in a docs folder. If your source code is hosted on GitHub, you just have to commit this folder to GitHub, navigate ... Read More

Feed: Planet MySQL; Author: Severalnines; One of the cool features in Galera is automatic node provisioning and membership control. If a node fails or loses communication, it will be automatically evicted from the cluster and remain unoperational. As long as the majority of nodes are still communicating (Galera calls this PC - primary component), there is a very high chance the failed node would be able to automatically rejoin, resync and resume the replication once the connectivity is back. Generally, all Galera nodes are equal. They hold the same data set and same role as masters, capable of handling read ... Read More

Feed: Hortonworks Blog – Hortonworks. Author: Saumitra Buragohain. We’re excited to announce the long-awaited release of Hortonworks Data Platform 3.0.0. HDP 3.0 is faster, smarter, hybrid, bigger, trusted and real-time database. We encourage you to read our blog that announced HDP 3.0. You can also view our keynote presentation from DataWorks Summit, where we demoed an autonomous car (1/10 scale), trained with HDP 3.0 technologies. We also want to thank  our current and prospective customers and partners for signing up for the HDP 3.0 Early Access and we are encouraged by the huge interest- now, you can use the HDP ... Read More

Feed: AWS Big Data Blog. Exploratory data analysis of genomic datasets using ADAM and Mango with Apache Spark on Amazon EMRAs the cost of genomic sequencing has rapidly decreased, the amount of publicly available genomic data has soared over the past couple of years. New cohorts and studies have produced massive datasets consisting of over 100,000 individuals. Simultaneously, these datasets have been processed to extract genetic variation across populations, producing mass amounts of variation data for each cohort. In this era of big data, tools like Apache Spark have provided a user-friendly platform for batch processing of large datasets. However, ... Read More

Feed: Planet MySQL; Author: HowToForge; Nextcloud is a free (Open Source) Dropbox-like software, a fork of the ownCloud project. Nextcloud is written in PHP and JavaScript, it supports many database systems such as MySQL/MariaDB, PostgreSQL, Oracle Database, and SQLite. In order to keep your files synchronized between Desktop and your own server, Nextcloud provides applications for Windows, Linux, and Mac desktops and a mobile app for Android and iOS. Nextcloud is not just a Dropbox clone, it provides additional features like Calendar, Contacts, Schedule tasks, and streaming media with Ampache etc. In this tutorial, we will show you how to ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; An LSM like RocksDB has much better write and space efficiency than a B-Tree. That means with RocksDB you will use less SSD than with a B-Tree and the SSD will either last longer or you can use lower endurance SSD. But this efficiency comes at a cost. In the worst-case RocksDB might use 2X more CPU/query than a B-Tree, which means that in the worst case QPS with RocksDB might be half of what it is with a B-Tree. In the examples below I show that RocksDB can use ~2X more comparisons per ... Read More