Tag: testing

Feed: Planet MySQL; Author: Michael McLaughlin; Encountered a problem while running the RODBC library from the R prompt as the root user, as follows: > install.packages('RODBC') It failed with the following library dependency: checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package ‘RODBC’ * removing ‘/usr/lib64/R/library/RODBC’   The downloaded source packages are in ‘/tmp/RtmpdT1gay/downloaded_packages’ Updating HTML index of packages in '.Library' Making 'packages.html' ... done Warning message: ... Read More

Feed: Planet MySQL; Author: Tony Darnell; MySQL Enterprise Edition Database Firewall – Control and Monitor SQL Statement Executions April 23, 2018 Leave a comment As of MySQL 5.6.24, MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall (it runs within the mysql database process) that enables database administrators to permit or deny SQL statement execution based on matching against whitelists of accepted statement patterns. This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload characteristics. Each MySQL account registered with the firewall has its own ... Read More

Feed: AWS Compute Blog. Author: Tara Van Unen. This post courtesy of Massimiliano Angelino, AWS Solutions ArchitectDifferent enterprise systems—ERP, CRM, BI, HR, etc.—need to exchange information but normally cannot do that natively because they are from different vendors. Enterprises have tried multiple ways to integrate heterogeneous systems, generally referred to as enterprise application integration (EAI). Modern EAI systems are based on a message-oriented middleware (MoM), also known as enterprise service bus (ESB). An ESB provides data communication via a message bus, on top of which it also provides components to orchestrate, route, translate, and monitor the data exchange. Communication with the ... Read More

Feed: Planet MySQL; Author: Giuseppe Maxia; When maintainng any piece of software, we usually deal with two kind of actions:bug fixing, new features. bugs and featuresA bug happens when there is an error in the software, which does not behave according to the documentation or the specifications. In short, it's a breech of contract between the software maintainer and the users. The promise, i.e. the software API that was published at every major version, is broken, and the software must be reconciled with the expectations and fixed, so that it behaves again as the documentation says. When we fix a ... Read More

Feed: AWS Big Data Blog. AWS Glue is an increasingly popular way to develop serverless ETL (extract, transform, and load) applications for big data and data lake workloads. Organizations that transform their ETL applications to cloud-based, serverless ETL architectures need a seamless, end-to-end continuous integration and continuous delivery (CI/CD) pipeline: from source code, to build, to deployment, to product delivery. Having a good CI/CD pipeline can help your organization discover bugs before they reach production and deliver updates more frequently. It can also help developers write quality code and automate the ETL job release management process, mitigate risk, and more.AWS ... Read More

Feed: Planet big data. Author: admin. BrightPlanet provides terabytes of data for various analytic projects across many industries. Our role is to locate open-source web data, harvest the relevant information, curate the data into semi-structured content, and provide a stream of data feeding directly into analytic engines, data visualizations, or reports. In this blog series, we are going to be diving into our techniques and process that we bring to each project.In our previous post named “We harvest a lot of websites for our clients, but how do we know which sites to harvest in the first place?”, we talked ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I stopped reviewing MySQL Release Notes for quite a some time, but major GA releases of MySQL do not happen often, so I decided to make an exception and write about some bugs from Community users fixed in MySQL 8.0.11 GA.I'll start with good news about MySQL 8.0.11 GA! You can get sources at GitHub, and I had no problems to build on Fedora 27 on my good old QuadCore box, using the following cmake command line: [openxs@fc23 mysql-server]$ cmake . -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/home/openxs/boost -DENABLE_DOWNLOADS=1 -DWITH_UNIT_TESTS=OFF -DCMAKE_INSTALL_PREFIX=/home/openxs/dbs/8.0...[openxs@fc23 mysql-server]$ time make -j ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; I am now in an airport, waiting for one of the four flights that will bring me to Percona Live Santa Clara 2018.  This is a good time to write some details about my tutorial on parallel replication.  But before talking about Percona Live, I will share thoughts on MySQL/MariaDB bugs that caught my attention in the last weeks/months (Valeriy: you clearly have an influence on me). MySQL/MariaDB bugs Bug#69223 (Give a warning on CREATE TABLE without PRIMARY KEY by Daniël van Eeden) was brought back to my attention by Daniël publishing an audit plugin for that ... Read More

Feed: AWS Compute Blog. Author: Chris Munns. This post courtesy of George Mao, AWS Senior Serverless Specialist – Solutions ArchitectAWS Lambda and AWS CodeDeploy recently made it possible to automatically shift incoming traffic between two function versions based on a preconfigured rollout strategy. This new feature allows you to gradually shift traffic to the new function. If there are any issues with the new code, you can quickly rollback and control the impact to your application. Previously, you had to manually move 100% of traffic from the old version to the new version. Now, you can have CodeDeploy automatically execute ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; We proudly announce General Availability of MySQL 8.0. Download now! MySQL 8.0 is an extremely exciting new version of the world’s most popular open source database with improvements across the board. Some key enhancements include: SQL Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms. JSON Extended syntax, new functions, improved sorting, and partial updates. With JSON table functions you can use the SQL machinery for JSON data. GIS Geography support. Spatial Reference Systems (SRS), as well as SRS aware spatial datatypes,  spatial ... Read More