Nikhil Bhaskar- May 4, 2022
How to Install MySQL 5.7 on Ubuntu 20.04 LTS
Installing MySQL 5.7 on Ubuntu 20.04 Install the required packages. apt-get update apt-get install wget Download and install the MySQL repository package. mkdir /downloads cd /downloads wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb dpkg -i mysql-apt-config_0.8.12-1_all.deb Select the option UBUNTU BIONIC. On the MySQL Server and Cluster screen, select the option MYSQL-5.7. Verify the configuration summary and click on the …
Priya- May 30, 2021
How to Create Relational Database Service(RDS) on Amazon Web Service(AWS).
Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. RDS is a Database as a Service (DBaaS) that automatically configures and maintains your …
Read more “How to Create Relational Database Service(RDS) on Amazon Web Service(AWS).”
- Nikhil Bhaskar
- May 18, 2021
Enable MySQL slow Query Logs in Linux
The slow query log feature is turned off by default in MySQL, so in order to turn this feature on, we need to set the slow_query_log parameter to ON Enter the MySQL shell and run the following command: set global slow_query_log = ‘ON’; Enable any other desired options. Here are some common examples: Log details for queries expected to …
Andreas Bartel- May 14, 2021
How to Create SQL Server on Google Cloud Platform.
SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Login to google cloud platform …
Read more “How to Create SQL Server on Google Cloud Platform.”
- Andreas Bartel
- May 13, 2021
How to Create Mysql Database on Google Cloud platfrom.
Cloud SQL for MySQL is a fully-managed database service that helps you set up, maintain, manage, and administer your MySQL relational databases on Google Cloud Platform. Login to google cloud platform portal. Click on SQL. Click on Create Instance. Select MySQL. Then,click on choose MySQL. Provide the instance name …
Read more “How to Create Mysql Database on Google Cloud platfrom.”