Tag: CentOS

Feed: Percona Database Performance Blog. Author: Jervin Real. Jervin Real  | September 19, 2017 |  Posted In: MySQL, ProxySQL, Security, SSL PREVIOUS POST In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance. When deploying MySQL with SSL, the main concern is that the initial handshake causes significant overhead if you are not using connection pools (i.e., mysqlnd-mux with PHP, mysql.connector.pooling in Python, etc.). Closing and making new connections over and over can greatly impact on your total query response time. A customer and colleague recently educated me that although you can improve SSL encryption/decryption performance with the AES-NI ... Read More

Feed: Planet MySQL; Author: René Cannaò; ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license!But not only! In today's release, ProxySQL 1.4.3, the most important feature is surely the support for ClickHouse as a backend!Clients can still connect to ProxySQL using the MySQL Protocol, and ProxySQL will query ClickHouse.Because of this, the above statement needs to be edited: ProxySQL doesn't support only MySQL! Support for ClickHouse is available only in packages for Ubuntu 16, Debian 9, CentOS 7, and Fedora 24, where the package name includes clickhouse.It is possible to download it here.ClickHouse ... Read More

Feed: Cloud – Cloudera Engineering Blog. Author: Cy Jervis. This article shows how to build and publish a customized Docker image for usage as an engine in Cloudera Data Science Workbench. Such an image or engine customization gives you the benefit of being able to work with your favorite tool chain inside the web based application. Motivation: Cloudera Data Science Workbench (CDSW) enables data scientists to use their favorite tools such as R, Python, or Scala based libraries out of the box in an isolated secure sandbox environment. In a previous blog post I have shown an Apache Maven based ... Read More

Feed: Percona Database Performance Blog. Author: Agustín. Agustín  | September 12, 2017 |  Posted In: Insight for DBAs, MariaDB, MySQL PREVIOUS POST In this post, we will discuss how to search code with the help of cscope. Let’s begin by checking its description and capabilities (quoting directly from http://cscope.sourceforge.net/): Cscope is a developer’s tool for browsing source code. Allows searching code for: all references to a symbol global definitions functions called by a function functions calling a function text string regular expression pattern a file files including a file Curses based (text screen) An information database is generated for faster searches and ... Read More

Feed: Microsoft Azure Blog. Author: Alessandro Segala. Node.js is arguably one of the most popular technologies in use on the cloud. Many devs all over the world have embraced this platform which, according to the 2017 survey by the Node.js Foundation, is being enjoyed by those who create back-end, front-end, mobile, and even desktop apps. At Microsoft, we are investing heavily in Node.js and JavaScript, which are first class citizens on Azure and across many other products. Whether you are a full-stack, a DevOps specialist, an architect or simply playing around with Node.js, these are seven of the (many) reasons ... Read More

Feed: Percona Database Performance Blog. Author: George O. Lorch III. George O. Lorch III  | September 6, 2017 |  Posted In: Events and Announcements, MyRocks, MySQL PREVIOUS POST Percona, in collaboration with Facebook, is proud to announce the first experimental release of MyRocks in Percona Server for MySQL 5.7, with packages. Back in October of 2016, Peter Zaitsev announced that we were going to port MyRocks from Facebook MySQL to Percona Server for MySQL. Then in April 2017, Vadim Tkachenko announced the availability of experimental builds of Percona Server for MySQL with the MyRocks storage engine. Now in September 2017, we are ... Read More

Feed: Planet PostgreSQL. I have been posting about different types of FDWs available with Postgres distribution by BigSQL. Recently one of our customer had a reqirement of bridging their SQLServer database with Postgres. Postgres by BigSQL is already equiped with it. Here is how we can set it up in simple, easy steps. Step 1. Install FreeTDS in your Operating system Tabular Data Stream is the data exchange protocol / format used in SQL Server and Sybase and FreeTDS is a opensource project which impliments the TDS accross all operating systems. Most of the linux distributions made it available in ... Read More

Feed: Percona Database Performance Blog. Author: Alexey Zhebel. Alexey Zhebel  | August 31, 2017 |  Posted In: Events and Announcements, MyRocks, MySQL, Percona Server, Percona Software, TokuDB PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.19-17 on August 31, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.7.19, and including all the bug fixes in it, Percona Server for MySQL 5.7.19-17 is now the current GA release in the Percona Server for MySQL 5.7 series. Percona Server for ... Read More

Feed: Hadoop Dev. Author: JessicaLeeYau. Announcing the immediate availability of Big SQL v5.0.1 – maintenance release Big SQL, a SQL engine on Hadoop, has been making strides with the fast-evolving open source ecosystem. The core capabilities of Big SQL focusses on federation, SQL compatibility, scalability, performance, and of course enterprise security, making it a desirable query engine to seek insights from disparate data sources including Hadoop. We announced Big SQL v5.0 in July, 2017 following our partnership announcement with Hortonworks. Following that, we now announce the release of Big SQL v5.0.1 which focuses on  consumability  (support for – Zeppelin notebook, ... Read More

Feed: Percona Database Performance Blog. Author: Alexey Zhebel. Alexey Zhebel  | August 25, 2017 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.6.37-82.2 on August 25, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.6.37, and including all the bug fixes in it, Percona Server for MySQL 5.6.37-82.2 is now the current GA release in the Percona Server for MySQL 5.6 series. Percona Server for MySQL ... Read More