Tag: MySQL

Feed: Planet MySQL; Author: Marco; I think that very often we are so focus in analyzing internals, or specific behaviours/situations/anomalies that we tend to forget the simple things. It happened to me that last week a couple of customers raise the same question:  "How ProxySQL manage the default schema, or the ones declared inside a FROM/JOIN?"I was a bit surprise because I was given that for granted, and my first thought was, 'well read the documentation', but then I realize we do not have a clear section in the documentation about this. Given that and also because I realize I ... Read More

Feed: Planet MySQL; Author: Marco; This article is the spin-off of the article How ProxySQL deal with schema (and schemaname) 1 How ProxySQL differes from MySQL in managing explicit default schema declaration? does it respect the -D or USE MySQL and ProxySQL will behave the same when passing the default schema, setting it as default. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 MySQL mysql -uuallworld -ptest -h192.168.1.107 -P 3306 -D test select database(); ... Read More

Feed: Planet PostgreSQL. Today is one year since I started working seriously on pg_chameleon.With this commit I changed the project's license to the 2 clause BSD and the project's scope, evolving the project into a MySQL to PostgreSQL replica system.Initially this change was just a try. I needed to synchronise the data between MySQL and PostgreSQL and at that time the only option I had it was to use the MySQL foreign data wrapper, eventually to copy the data locally every now and then. However, because the previous implementation relied on a MySQL replica this approach approach wasn't really feasible.If ... Read More

Feed: Planet MySQL; Author: Peter Gulutzan; MySQL has thrown away the mysql.proc table for version 8.0 Development Releases. The best explanation that I've seen is the one that Dmitry Lenev gave at a conference last October. To summarize it: mysql.proc and its ilk are non-transactional, redundancy is bad, and MySQL can fix some known bugs by moving over to information_schema tables backed by InnoDB. Of course I approve for a separate reason: mysql.proc is non-standard and therefore it is a mistake. On the other hand, programmers that have invested some time in using mysql.proc will have some trouble changing them ... Read More

Feed: Planet MySQL; Author: Severalnines; Galera Cluster is a true multi-master cluster solution for MySQL and MariaDB, based on synchronous replication. Galera Cluster is easy-to-use, provides high-availability, as well as scalability for certain workloads. ClusterControl provides advanced deployment, management, monitoring, and scaling functionality to get your Galera clusters up-and-running using proven methodologies. Here are just some of the great resources we’ve developed for Galera Cluster over the last few years... Tutorials Galera Cluster for MySQL Galera allows applications to read and write from any MySQL Server. Galera enables synchronous replication for InnoDB, creating a true multi-master cluster of MySQL servers ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. We recently announced public preview availability of Azure Database for PostgreSQL and MySQL in West and Central India. PostgreSQL and MySQL are ubiquitous names in the world of open source relational databases, as these database engines have been widely embraced by developers in recent years. Microsoft’s Azure cloud is a first-class platform for open source technology that allows you to bring the tools you love, along with the skills you already have, and deploy any application. The availability of Azure Database for MySQL and PostgreSQL services in India provides app developers the ... Read More

Feed: Planet MySQL; Author: Shahriyar Rzayev; This post is about simple usage of mysqlx module i.e X Plugin with latest Connector/Python DMR.The version of Python Connector is 8.0.4. Installing: wget https://dev.mysql.com/get/Downloads/Connector-Python/mysql-connector-python-8.0.4-0.1.dmr.el7.x86_64.rpm sudo yum install mysql-connector-python-8.0.4-0.1.dmr.el7.x86_64.rpm Sample Python code: # Connecting to MySQL and working with a Session import mysqlx # Connect to a dedicated MySQL server session = mysqlx.get_session({ 'host': 'localhost', 'port': 33060, 'user': 'bakux', 'password': 'Baku12345', 'ssl-mode': mysqlx.SSLMode.DISABLED }) schema = session.get_schema('generated_columns_test') # Create 'my_collection' in schema schema.create_collection('my_collection') # Get 'my_collection' from schema collection = schema.get_collection('my_collection') assert(True == collection.exists_in_database()) # You can also add multiple documents at once collection.add({'_id': ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I do not care much about MySQL 8.0.x at the moment, as it's far from being GA and is work in progress. It is not yet used by customers whom I have to support. But I know about many interesting changes and improvements there that, eventually, are going to influence all main forks and kinds of MySQL. So, it would not be wise to ignore MySQL 8.0.c entirely even for me.For this post I decided to briefly check what community reported bugs were fixed in the recent release, 8.0.2, based on release notes. For ... Read More

Feed: CDH – Cloudera Engineering Blog. Author: Justin Kestelyn. Cloudera Enterprise 5.8 includes the latest release of Hue (3.10), the web UI that makes Apache Hadoop easier to use. As part of Cloudera’s continuing investments in user experience and productivity, Cloudera Enterprise 5.8 includes a new release of Hue that makes several common tasks much easier. In the remainder of this post, we’ll provide a summary of the main improvements. (Hue 3.10 is also available for a quick try in one click on demo.gethue.com.) New SQL Editor Hue’s new code editor is a single-page app that is much simpler to use ... Read More

Feed: Microsoft Azure Blog. Author: Sunil Kamath. We’re excited to announce the public preview availability of Azure Database for MySQL and Azure Database for PostgreSQL in India data centers (Central and West India). The availability of Azure Database for MySQL and PostgreSQL services in India provides app developers the ability to choose from an even wider number of geographies, and deploy their favorite database on Azure, without the complexity of managing and administering the databases. The Azure Database for MySQL and PostgreSQL, built using community edition of MySQL and PostgreSQL database offers built-in high availability, security and scaling on the ... Read More