Tag: mysql client

Feed: Planet MySQL; Author: Sheeri K. Cabral; In the quest to secure MySQL as well as ease the number of complicated passwords to remember, many organizations are looking into external authentication, especially using LDAP. For free and open source, Percona’s PAM authentication plugin is the standard option. tl;dr is I go through how to compile php-cli for use with auth_pam plugin. BackgroundThere are two plugins that can be used. From the documentation, the two plugins are: Full PAM plugin called auth_pam. This plugin uses dialog.so. It fully supports the PAM protocol with arbitrary communication between client and server. Oracle-compatible PAM ... Read More

Feed: MemSQL Blog. Author: Seth Luersen. Experience teaches us that when loading data into a database, in whatever form ― normalized, denormalized, schema-less, hierarchical, key-value, document, etc ― the devil is always in the data load. For enterprise companies in the real-time economy, every second saved means improved efficiency, productivity, and profitability. Thankfully, MemSQL Cloud makes your enterprise data fast to load and easy to access. You can spin up a cluster in MemSQL Cloud in minutes and load data very quickly using MemSQL Pipelines. MemSQL scales out for fast parallel processing of very large data sets. MemSQL Pipelines deliver ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; MySQL Connector/ODBC 5.3.9, a new version of the ODBC driver forthe MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSIdriver based on the same modern codebase. Please select the driver typeyou need based on the type of your application – Unicode or ANSI.Server-side prepared statements are enabled by default. It is suitablefor use with any MySQL version from 5.5. This is the fourth release of the MySQL ODBC driver conforming to theODBC 3.8 specification. It contains implementations of key 3.8 features,including self-identification as a ODBC 3.8 ... Read More

Feed: Planet MySQL. Author: InsideMySQL.com. Dear MySQL users, MySQL Connector/Python 8.0.4 dmr is the fifth development release of theMySQL Connector Python 8.0 series. This series adds support for the new XDevAPI. The X DevAPI enables application developers to write code thatcombines the strengths of the relational and document models using amodern, NoSQL-like syntax that does not assume previous experiencewriting traditional SQL. To learn more about how to write applications using the X DevAPI, seehttp://dev.mysql.com/doc/x-devapi-userguide/en/. For more information about how the X DevAPI is implemented inMySQL Connector/Python, and its usage, seehttp://dev.mysql.com/doc/dev/connector-python Please note that the X DevAPI requires MySQL Server version ... Read More

Feed: Planet MySQL. Author: InsideMySQL.com. MySQL Connector/Net 8.0.8 is the fifth development release that expands cross-platformsupport to Linux and macOS when using Microsoft’s .NET Core framework. Now, .NETdevelopers can use the X DevAPI with .NET Core and Entity Framework Core (EF Core)1.0 to create server applications that run on Windows, Linux and macOS. We are veryexcited about this change and really look forward to your feedback on it! MySQL Connector/Net 8.0.8 is also the seventh development release of MySQLConnector/Net to add support for the new X DevAPI. The X DevAPI enables applicationdevelopers to write code that combines the strengths of ... Read More

Feed: Planet MySQL. Author: InsideMySQL.com. Dear MySQL users, MySQL Connector/J 8.0.7 Development Release is a development milestonerelease for the 8.0.x series.This release includes the following new features and changes, also describedin more detail onhttps://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-7.html MySQL Connectors and other MySQL client tools and applications nowsynchronize the first digit of their version number with the (highest)MySQL server version they support.This change makes it easy and intuitive to decide which client versionto use for which server version. Connector/J 8.0.7 is the first release to use the new numbering.It is the successor to Connector/J 6.0.6 As always, we recommend that you check the “CHANGES” ... Read More

Feed: Planet MySQL. Author: InsideMySQL.com. Dear MySQL users, MySQL Connector/C++ 8.0.5-dmr is the next development milestone release of the MySQL Connector/C++ 8.0 series (formely 2.0 series). Connector/C++ 8.0 can be used to access MySQL implementing Document Store or in a traditional way, using SQL queries. It allows writing both C++ applications using X DevAPI or plain C applications using XAPI. To learn more about how to write applications using X DevAPI, see “X DevAPI User Guide” https://dev.mysql.com/doc/x-devapi-userguide/en/ and “X DevAPI Reference” at https://dev.mysql.com/doc/dev/connector-cpp/devapi_ref.html For more information about using plain C XAPI see “XAPI Reference” at https://dev.mysql.com/doc/dev/connector-cpp/xapi_ref.html For generic information on ... Read More

Feed: Planet MySQL. Author: InsideMySQL.com. MySQL Connector/Node.js is a new Node.js driver for use with the XDevAPI. This release, v8.0.7 , is the first development release of theMySQL Connector/Node.js 8.0 series. The X DevAPI enables application developers to write code that combinesthe strengths of the relational and document models using a modern,NoSQL-like syntax that does not assume previous experience writingtraditional SQL. MySQL Connector/Node.js can be downloaded through npm (seehttps://www.npmjs.com/package/@mysql/xdevapi for details) or fromhttps://dev.mysql.com/downloads/connector/nodejs/. To learn more about how to write applications using the X DevAPI, seehttp://dev.mysql.com/doc/x-devapi-userguide/en/. For more informationabout how the X DevAPI is implemented in MySQL Connector/Node.js, andits usage, ... Read More

Feed: Planet MySQL. Author: Reggie Burnett. Here at MySQL we are constantly improving both our servers and our client software by making things simple to use and understand.  An area where we want to simplify things is around the version number we use for various MySQL client, connector, and other applications like Workbench, MySQL Enterprise Backup, etc. Basically: We want to make sure our users easily know which version of a connector or client works with which server version(s). We want to deliver support for new server features during the server DMR phase without disrupting the GA versions of the ... Read More

Feed: Percona Database Performance Blog. Author: Krunal Bauskar. Krunal Bauskar  | July 5, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster PREVIOUS POST In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols. Introduction Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire the workload through a PREPARE statement, there are differences between using the MySQL connector API (with binary protocol) and the MySQL ... Read More