Tag: Page

Feed: Planet MySQL; Author: Calvin Sun; MySQL 8.0.17 is officially released Yesterday. The most talked feature is the clone plugin, which enables the automatic node provisioning from an existing node (a Donor). This also closes the gap between MySQL Group Replication and Galera Cluster on usability.Congrats to MySQL engineering team on the excellent work! Specially expose the visibility of the operations:mysql> SELECT STATE FROM performance_schema.clone_status;+-----------+| STATE     |+-----------+| Completed |+-----------+1 row in set (0.02 sec) mysql> SELECT STAGE, STATE, END_TIME FROM performance_schema.clone_progress;+-----------+-------------+----------------------------+| STAGE     | STATE       | END_TIME                   |+-----------+-------------+----------------------------+| DROP ... Read More

Feed: Blog Post – Corporate – DataStax. Author: Chelsea Navo, Vanguard Lead, Presales Architecture. Enterprises want the best of both worlds, which is why they’re increasingly adopting hybrid and multi-cloud strategies to take advantage of what both public and private cloud providers have to offer and build powerful, modern applications. The hybrid cloud market is expected to grow to $97.64 billion by 2023—quite the uptick from the $44.6 billion the market realized in 2018.  Today, more than 65% of organizations use hybrid cloud environments. Not only does a hybrid cloud infrastructure enable companies to leverage the scalability the public cloud ... Read More

Feed: Planet MySQL; Author: Percona Community; Timur Solodovnikov  | July 23, 2019 |  Posted In: MySQL, Open Source Databases Starting at version MySQL5.6+ by default innodb_file_per_table is enabled and all data is stored in separate tablespaces.It provides some advantages. I will highlight some of them:You can reclaim disk space when truncating or dropping a table stored in a file-per-table tablespace. Truncating or dropping tables stored in the shared system tablespace creates free space internally in the system tablespace data files (ibdata files) which can only be used for new InnoDB data.You can store specific tables on separate storage devices, for I/O optimization, space management, ... Read More

Feed: R-bloggers. Author: Posts on Tychobra. R is great for report generation. Shiny allows us to easily create web apps that generate a variety of reports with R. This post details a demo Shiny app that generates an Excel report, a PowerPoint report, and a PDF report: The full Shiny app source code is available here. Also, we included a more basic Shiny app that generates an Excel report at the end of this post. Follow up posts will include similar simple Shiny apps generating PowerPoint and PDF reports. Here are some screenshots of the Shiny app that generates the ... Read More

Feed: R-bloggers. Author: Andrew Treadway. This post will compare Python’s BeautifulSoup package to R’s rvest package for web scraping. We’ll also talk about additional functionality in rvest (that doesn’t exist in BeautifulSoup) in comparison to a couple of other Python packages (including pandas and RoboBrowser). Getting started BeautifulSoup and rvest both involve creating an object that we can use to parse the HTML from a webpage. However, one immediate difference is that BeautifulSoup is just a web parser, so it doesn’t connect to webpages. rvest, on the other hand, can connect to a webpage and scrape / parse its HTML ... Read More

Feed: SAS Blogs. Author: Khari Villela. Read about the differences in data lakes and data warehouses So, you've decided to build a data lake – great news! Data lakes can be incredibly useful. However, as I explained in my earlier post, it can be challenging to move past over-hyped promises and unrealistic expectations to capture the real value of data lakes. I’m sure you’re eager to get started. But before you jump straight to implementation, keep in mind that it takes a lot of planning and thought to build a data lake that’s more than just a mono-tasking problem solver ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Hello MySQL Connector/NET community, Consistent with our ongoing effort to power MySQL products with the top technologies, we are pleased to announce the latest updates regarding MySQL Connector/NET and .NET Core. And while we move forward, we also want to shape the product to maximize supportability. To achieve these two goals, we will deprecate the support for .NET Core 1.X to align with Microsoft’s end-of-life schedule (EOL May 14, 2019). But it’s not all about bad news, we also want to talk to you about the inclusion of .NET Core 2.2 support in the Connector/NET8.0.17 ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.17 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle’s dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.17. MySQL Shell is an interactive JavaScript, Python and SQL console interface, supporting development and administration for the MySQL Server. It provides APIs implemented in JavaScript and Python that enable you to work with MySQL InnoDB cluster and use MySQL as a document store. The AdminAPI enables ... Read More

Feed: Planet MySQL; Author: Colin Charles; Codership is pleased to announce a new Generally Available (GA) release of Galera Cluster for MySQL 5.6 and 5.7, consisting of MySQL-wsrep 5.6.44-25.26 and MySQL-wsrep 5.7.26-25.18 with a new Galera Replication library 3.27 (release notes, download), implementing wsrep API version 25. This release incorporates all changes into MySQL 5.6.44 (release notes, download) and MySQL 5.7.26 (release notes, download) respectively. Compared to the previous 3.26 release, the Galera Replication library has a few fixes: to prevent a protocol downgrade upon a rolling upgrade and also improvements for GCache page storage on NVMFS devices. One point ... Read More

Feed: James Serra's Blog. Author: James Serra. Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs): Do I need a data lake? Data lake detailsDo I need a relational data warehouse? Is the traditional data warehouse dead?Do I need a cube? The need for having both a DW and cubesWhere do I clean my data? Where should I clean my data?What is the Common Data Model (CDM)? Common ... Read More