Tag: mysql client

Feed: Planet MySQL; Author: Severalnines; Requires ClusterControl 1.6 or later. Applies to MySQL based instances/clusters. On some occasions, you might want to run multiple instances of MySQL on a single machine. You might want to give different users access to their own MySQL servers that they manage themselves, or you might want to test a new MySQL release while keeping an existing production setup undisturbed. It is possible to use a different MySQL server binary per instance, or use the same binary for multiple instances (or a combination of the two approaches). For example, you might run a server from ... Read More

Feed: Planet MySQL; Author: rathishDBA; Recently, when I am working on setting up MySQL Enterprise Server, I found, there is too much information available over internet and it was very difficult for a newbie to get what is needed for direct implementation. So, I decided to write a quick reference guide for setting up the server, covering end to end, starting from planning to production to maintenance. This is a first post in that direction, in this post, we will discuss about installing MySQL Enterprise Server on CentOS 7 machine. Note that, the steps are same for both the Enterprise ... Read More

Feed: Planet MySQL; Author: ScaleGrid.io; In this blog post, we review some of the important aspects of configuring and managing SSL in MySQL hosting. These would include the default configuration, disabling SSL, and enabling and enforcing SSL on a MySQL server. Our observations are based on the community version of MySQL 5.7.21. Default SSL Configuration in MySQL By default, MySQL server always installs and enables SSL configuration. However, it is not enforced that clients connect using SSL. Clients can choose to connect with or without SSL as the server allows both types of connections. Let’s see how to verify this ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This is the same plugin that Alex Gorvachev created back in the day. I’ve simply modified it to be compatible with both 12c and 13c versions. I created this in response to a comment on the blog about issues deploying the plugin in OEM 13c. There is also a note in MOS “EM 13c: Adding a MySQL Instance in Enterprise Manager 13c Fails with Error: oracle.sysman.emSDK.agent.client.exception.NoSuchMetricException: the Load metric does not exist (Doc ID 2160785.1)“. This version has been tested with OEM 13cR2 and OEM 12cR3, so it should be working in all ... Read More

Feed: Planet MySQL; Author: Severalnines; ClusterControl’s agentless approach allows sysadmins and DBAs to monitoring their databases without having to install agent software on each monitored system. Monitoring is implemented using a remote data collector that uses the SSH protocol. But first, let’s clarify the scope and meaning of monitoring within our context here. Monitoring comes after data trending - the metrics collection and storing process - which allows the monitoring system to process the collected data to produce justification for tuning, alerting, as well as displaying trending data for reporting. Generally, ClusterControl performs its monitoring, alerting and trending duties by ... Read More

Feed: Planet MySQL; Author: Krunal Lathiya; Get real time updates directly on you device, subscribe now. Subscribe In this tutorial, we will see, How To Connect Nodejs Application To MySQL Database. Node.js can be used in database applications, and one of the most popular databases is MySQL. We have used MongoDB almost time when we choose Node.js as a platform. That is why today’s example is for MySQL. For this first, you need to install MySQL server and then install the mysql package. You can download a free MySQL database at https://www.mysql.com/downloads/. Content Overview Connect Nodejs Application To MySQL Database First, create a node.js project ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Jobin Augustine | August 24, 2018 |  Posted In: MySQL, open source databases, PostgreSQL PREVIOUS POST There are many organizations where front/web-facing applications use MySQL and back end processing uses PostgreSQL®. Any system integration between these applications generally involves the replication—or duplication—of data from system to system. We recently blogged about pg_chameleon which can be used replicate data from MySQL® to PostgreSQL. mysql_fdw can play a key role in eliminating the problem of replicating/duplicating data. In order to eliminate maintaining the same data physically in both postgres and MySQL, we can use mysql_fdw. This allows PostgreSQL to ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Beginning in MariaDB 10.1, Galera Cluster ships with the MariaDB Server. Upgrading a Galera Cluster node is very similar to upgrading a server from MariaDB 10.1 to MariaDB 10.2. For more information on that process as well as incompatibilities between versions, see the Upgrade Guide. Upgrading the Node Galera Cluster supports rolling updates by design. By updating one node at a time, then waiting for it to sync back up with the cluster, you can bring all nodes to the latest version without the penalty of any downtime. Preparing the Server When ... Read More

Feed: Planet PostgreSQL. Jobin Augustine | August 24, 2018 |  Posted In: MySQL, open source databases, PostgreSQL PREVIOUS POST There are many organizations where front/web-facing applications use MySQL and back end processing uses PostgreSQL®. Any system integration between these applications generally involves the replication—or duplication—of data from system to system. We recently blogged about pg_chameleon which can be used replicate data from MySQL® to PostgreSQL. mysql_fdw can play a key role in eliminating the problem of replicating/duplicating data. In order to eliminate maintaining the same data physically in both postgres and MySQL, we can use mysql_fdw. This allows PostgreSQL to access MySQL tables and ... Read More

Feed: Planet MySQL; Author: YouTube Vitess; I'm just doing this for a hackathon to prove things out and see if it'll work for us sougou People have adopted more approaches than those mentioned in that write-up. We need to update it with the new strategies sougou Dual-writes seems to be a popular approach In that particular descrption, I think it meant mysql->mysql raj.veerappan what happens to the schema in that case? I guess I thought updates to the schema have to go through vtgate sougou not necessary even after you're fully migrated to vitess, you can deploy schema changes directly ... Read More