Why You Should Use Kloudbean for MySQL Database:
Kloudbean provides an effortless way to launch and manage a MySQL database, offering an easy-to-use interface and minimal setup time. The databases are finely tuned for top performance, ensuring smooth operations. Security is top-notch, with granular access controls, while automated backups give users confidence in data protection and recovery. Kloudbean's real-time replication feature offers powerful failover and scaling solutions, making it the ideal choice for businesses looking for a reliable, high-performance database hosting solution.
Now, let's go ahead and see a demo of how we can launch a MySQL database in real-time on Kloudbean.
Step 1: Accessing DBS section from dashboard.
From the dashboard we can go to DBS (Database System) section by a simple click on Managed Database to view existing databases. Clicking on it should take us to databases section.
In database section, we currently do not have any database. In order to launch a new database, Click on Launch Database button.
With this a new database launch panel should open and asking for the selection of required database along with other database basic configurations.
Step 2: Launching new MySQL database
In our case we are going to launch MySQL database in this tutorial, so let's go ahead and select MySQL from the database options.
Once database is selected, we will see all the database version including most recent one is available in the dropdown of field Database Version. If we have a requirement of any specific database version, we can select that particular version or we can select most latest one.
Along with database version, we have to add or select following important detail as well.
Database Name: This is going to be name of our database and the database that will be created as default in our MySQL engine.
Database User: This is going to be the administrator user of the database, which is going to have maximum privileges.
Server Location: This is the physical location of the database server, try to select the location that is closest to the application server.
Server Size: Depending on the workload and application size, choose server size which better fits the requirement. For best performance, try to choose Dedicated servers, as their hardware are not shared and provide maximum performance.
After selecting all these fields, Click on LAUNCH DATABASE button to proceed to payment and then database will be launched.
Launching new database takes approximately 4 to 5 minutes to fully create and ready to use. Once data creation is complete, we can access database detail by clicking on the database that is just created, in this tutorial we created Masterlabs database.
Once we click on database, it will take us to database detail section, where we will find following useful information, that is must required in order to access database or connect database with the application.
Host: This is database host name, a unique url for the database, to access it over the internet. Instead of host we can optionally use IP Address as well.
Database Name: This is the same name that we provide while creating this database, a default database is created with the same name.
Master User: This user has administrator privileges over the database.
Public Access: This field represent our current settings for the database, as of now our database is not accessible from anywhere, until to manage or update it's access from Firewall section. currently public access is completely disabled.
Step 3: Allowing database Public access
If we want to access database from out local machine by using any tool, we have to enable public, however enabling public access is not recommended at all, but in some cases where for purpose we can enable public access and disable it immediately after making changes through public access from local machine.
To enable public access. Go to Firewall tab and select the option "Allow database public access" and hit Submit button.
This should turn on database public access.
Step 4: Accessing database using MySQL Workbench
Once database public access in enabled, we can access it now from local machine.
Go to MySQL Workbench and click on little plus (+) icon to create a new connection.
It will open a prompt, asking for database host and access credentials.
Copy and paste these information from Access tab as shown above.
- Copy Host from Kloudbean Access tab and paste here in Hostname field.
- Copy Master User from Kloudbean Access tab and paster here in Username field.
- Port is going to be the default one, which is 3306.
- Paste Database Name in Default Schema field.
Click on Test Connection to check if connection is working.
It will ask for database password.
Copy Database Password from Kloudbean Access tab and paste it here.
Once you hit OK, connection should be added successfully.
We can see a new connection is added in Workbench dashboard.
Double click on this, should take us inside the database.
Go ahead and double click on this newly created connection.
Our database should be connected and ready to run any query. Here we can see connection is successful and database masterlabs is available.
Allowing database access from specific IP Address.
Previously we saw how we can enable database public access, but this is not recommended as allowing public access can open database for incoming traffic and intruders can try to gain your database access, hence in this step we are going to see how to allow access only from particular IP addresses from where application is going to access it.
Go to Firewall section and this time choose option ;
"Only allow following IP address to access database".
Add the IP address from where you want to allow access, we can add multiple IP Addresses as per demand. Once added, click on Submit button to whitelist these IP addresses.
As the mentioned IP address has been whitelisted, now we should be good to access database from this particular server. As a demo purpose I'm going to use mysql client from shell command to access database through terminal.
Accessing database through mysql client.
Once we enter this command with correct host and user, It will ask for password. Paste password from Kloudbean Access tab and hit Enter. It should let us access the database.
mysql -h masterlabs-us-southeast-13563.kloudbeansite.com -u serviceuser -p
That's all for launching and accessing MySQL database using Kloudbean Managed and highly optimized database.
Conclusion
Kloudbean makes launching and managing MySQL databases fast, easy, and secure, freeing you from the complexities of database administration. With just a few clicks, your MySQL database is ready to provide optimized performance and scalability for your applications. Start launching your managed MySQL database on Kloudbean today and experience seamless database management.
If you encounter any issues while setting up or managing your MySQL database on Kloudbean, our expert support team is available 24/7 to assist you.