Let's Learn

12/13/2021

06/14/2018

How to run and use MYSQL from docker

First download your docker version such Docker for Linux, Mac, Windows

Note:- now make sure with - docker-machine ls if you do not see default Machine than use localhost insted of vm IP.

After installation Run MySQL

docker run --name container_NAME -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=DB_Name -p 3306:3306 -d mysql

Or use Dockerfile to create on

FROM ubuntu:latest

MAINTAINER Pankaj Sonani

# Install latest updates
RUN apt-get update
RUN apt-get upgrade -y

# Install mysql client and server
RUN DEBIAN_FRONTEND=noninteractive apt-get -y install mysql-client mysql-server curl

# Enable remote access (default is localhost only, we change this
# otherwise our database would not be reachable from outside the container)
RUN sed -i -e"s/^bind-address\s*=\s*127.0.0.1/bind-address = 0.0.0.0/" /etc/mysql/my.cnf

# Install database
ADD ./database.sql /var/db/database.sql

# Set Standard settings
ENV user student
ENV password secret
ENV url file:/var/db/database.sql
ENV right READ

# Install starting script
ADD ./start-database.sh /usr/local/bin/start-database.sh
RUN chmod +x /usr/local/bin/start-database.sh

EXPOSE 3306

CMD ["/usr/local/bin/start-database.sh"]

06/14/2018

If you need to run MySQL on the Rackspace Cloud, you have two fundamental choices: run MySQL on a Cloud Server, or run MySQL as a Cloud Database instance. This naturally raises a few questions: What are the features and benefits of each? Which performs better? Which will be more cost effective? As with every application, the answer is ”it depends;” however, the information below should help you make the right choice based on your needs.

So, which should you choose?

For lighter workloads and smaller database sizes, my suggestion would be to choose your platform based upon features instead of performance. With Cloud Databases, you don’t have to configure or patch the server. You have the convenience of a control panel interface, and three copies of the database are maintained automatically. This does not, however, protect you from accidentally dropping a table, so you should also perform a scheduled dump to disk from a Cloud Server client as illustrated here:

How–To Home Cloud Databases Introduction FAQ All Articles Have Feedback? We love customer feedback. Help us improve our products and service by leaving your comments. Edit This Article Export Data from MySQL Last updated on: 2018-04-18 Authored by: Rackspace Support To export your MySQL database, ...

08/16/2016

Java with JDBC

07/16/2016

Hi All I found very good resource to boost your Database skill.

Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA team

Ref Link - https://www.udemy.com/oracledba/learn/v4/overview

Learn to become an Oracle Database Administrator in a month. It is one of the stable and 'high in demand' IT jobs.