Tag: mysql client

Feed: Planet MySQL; Author: PlanetScale; Today, we are excited to share that connection strings are available to all PlanetScale users.As a company that obsesses over making databases more accessible to developers, you might have struggled with why PlanetScale didn’t have a way to connect to your database with connection strings. And we heard you! You can now use the tools you're familiar with to connect to PlanetScale databases, whether that’s with Rails, Python, Prisma, Laravel, or any other MySQL client. Connection strings also enable you to connect to other serverless computing platforms like AWS Lambda or Vercel.Within PlanetScale, you can ... Read More

Feed: Planet MySQL; Author: Saroj Tripathy; In this post, we will see how to setup MySQL NDB Cluster from a docker image. I assume that the reader has some basic understanding of docker and its terminology.Steps to install MySQL NDB Cluster:Let's create a MySQL NDB Cluster with the following environment:MySQL NDB Cluster version (Latest GA version)1 Management Node4 Data Nodes1 Mysqld ServerConfiguration slots for upto 4 additional API nodes Note: Docker software must be installed and running on the same host where we are planning to install MySQL NDB Cluster. Also make sure we have enough resources allocated to docker so ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . mysql 명령줄 클라이언트에 대하여 mysql (from MariaDB 10.4.6, also called mariadb) is a simple SQL shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively, query results are presented in an ASCII-table format. When used non-interactively (for example, as a filter), the result is presented in tab-separated format. The output format can be changed using command options. mysql (MariaDB 10.4.6부터는 mariadb라고도 불립니다.)은 간단한 SQL 셸입니다.(GNU readline 기능 포함) 대화형 및 비 대화형 사용을 지원합니다. 대화형으로 사용될 경우 쿼리 결과는 ASCII-테이블 형식으로 표시됩니다. 비 대화형으로 사용될 경우(예시 : 필터로 ... Read More

Feed: Planet MySQL; Author: Ronald Bradford; This week I was evaluating AWS QLDB. Specifically the verifiable history of changes to determine how to simplify present processes that perform auditing via CDC. This is not the first time I have looked at QLDB so there was nothing that new to learn. What I found was that creating a workable solution with an existing application is hard. Even harder is creating an example to publish in this blog (and the purpose of this post). First some background. Using MySQL as the source of information, how can you leverage QLDB? It’s easy to ... Read More

Feed: Planet MySQL; Author: Alena Subotina; In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we consider each method in detail. Connecting to MySQL Using the MySQL Command-Line ClientConnecting to MySQL Using dbForge Studio for MySQL Connecting to MySQL Using MySQL Workbench Connecting to MySQL Using the MySQL Command-Line Client In the first article of our series, we provided a detailed walkthrough outlining the aspects of how to install ... Read More

Feed: Planet MySQL; Author: Andrew Grimo; MySQL-Shell has had a set of “Util” object functions for almost a year as of this post. It is this added functionality that negates any reason someone would still need to use the old mysqldump client. It (mysqldump) helped the MySQL Community for a long, long time. It also introduced a large amount of garbage and messiness in with those bloated data files, as it really belongs to an older era. We can now move on ahead without it. This process of “moving ahead” is what I will demonstrate in this blog post. Note: ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain the MySQL shell commands “show” and “watch”. Both commands are very useful to monitor the MySQL process. It provides more insights into the foreground and background threads as well.  Overview “show” and “watch” are the MySQL shell commands, which can be executed using the Javascript (JS), Python (Py), and SQL interfaces. Both commands are providing the same information, but the difference is you can refresh the results when using the command “watch”. The ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; This post was written by: Nicolas De Rico: Oracle Cloud Solutions Engineer - MySQL Sergio J Castro: Oracle Cloud Solutions Engineer - Networking   From RDS to MDS   When an application reaches the maximum capabilities offered by Amazon Web Services (AWS) RDS, it is often recommended to migrate to the AWS Aurora service.   However, Aurora is based on an older version of MySQL.  Aurora still does not support MySQL 8.0, which was released in April 2018.  Therefore, it may be difficult to port applications to Aurora, and later, out of Aurora because of its ... Read More

Feed: AWS Public Sector Blog. Author: Luis Baeza. The United Nations Educational, Scientific and Cultural Organization (UNESCO) estimated in 2019 that over 12 million people took part of some kind of online learning. Last year, education institutions quickly implemented online learning tools in response to social distance measures adopted worldwide during the COVID-19 pandemic. One of the most popular tools in the education sector is Moodle with 253 million users from 241 countries. Moodle is an online learning, open source platform designed to create customized learning environments through a simple interface, with drag and drop features. Whether there is a ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users,MySQL Shell 8.0.23 is a maintenance release of MySQL Shell 8.0 Series (acomponent of the MySQL Server). The MySQL Shell is provided underOracle’s dual-license.MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and5.7. Please upgrade to MySQL Shell 8.0.23.MySQL Shell is an interactive JavaScript, Python and SQL consoleinterface, supporting development and administration for the MySQLServer. It provides APIs implemented in JavaScript and Python thatenable you to work with MySQL InnoDB cluster and use MySQL as a documentstore.The AdminAPI enables you to work with MySQL InnoDB cluster and InnoDBReplicaSet, providing integrated ... Read More