Tag Archives: Database

Hello, layman here. Having MariaDB database (v. 10.6.18) on a shared hosting.
If my new hosting provider has no MariaDB but MySQL and I will be importing using PHPMyAdmin, how to spot the issues?

https://blogs.oracle.com/mysql/post/how-to-migrate-from-mariadb-to-mysql-80 says:
“Before migration (from MariaDB to MySQL), you will need to convert data in other storage engines to InnoDB”

List storage engines (SQL tab of the PHPMyAdmin):

SELECT COUNT(*) as '# TABLES', 
  CONCAT(ROUND(sum(data_length) / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
  CONCAT(ROUND(sum(index_length) / ( 1024 * 1024 * 1024 ), 2), 'G') INDEXES,
  CONCAT(sum(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2)), 'G') 'TOTAL SIZE', ENGINE 
FROM information_schema.TABLES
WHERE TABLE_SCHEMA 
 ...

In the steps above we have created a database and table that we will use to connect using Go Lang. The next step is to create a service and configure it to connect to the database that was created previously. Here are the steps:

1. First initiate our project using the following command:

go mod init [nama project]
# example
go mod init test-connection-db

2. Because here I am using MySQL as the database, here we need to add the MySQL driver package.

go get github.com/go-sql-driver/mysql

3. Next, we setup the database connection by creating a new file called connection/database.go. Paste the following code :

package connection
import (
"database/sql"
"time"
_ "github.com/go-sql-driver/mysql"
)
func GetConnection() *sql.DB {
// username = root
// password = admin
// host = 127.0.0.1
// db name =...

LOS ANGELES, Nov. 02, 2022 (GLOBE NEWSWIRE) — Kinsta, a hosting provider that offers managed WordPress hosting powered by Google Cloud Platform and trusted by 55,000+ users and 100,000 live customer projects, has just launched Application Hosting and Database Hosting. The addition of these two services to its Managed WordPress product ushers in a new era for Kinsta as a Cloud Platform, enabling developers and businesses to run powerful applications, websites, databases, and services with more flexibility than ever.

With their new platform as a service model, Kinsta customers can run their applications with the most popular programming languages and frameworks, including Node.js, PHP, Python, Go, Ruby, Java, and Scala by setting up a container image automatically or use their…

PALO ALTO, Calif., March 23, 2021 /PRNewswire/ — ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for Oracle Cloud Infrastructure (OCI) through their fully managed database hosting plans. In addition to their AWS, Azure, Google Cloud (GCP) and DigitalOcean hosting solutions, ScaleGrid now offers OCI hosting for MySQL, PostgreSQL, Redis™ and MongoDB® database.

Oracle Cloud is a relatively new cloud computing service offered by Oracle Corporation, the company behind the Oracle commercial database and open source MySQL database, that was made available in 2016 to put Oracle on the map against global competitors AWS and Azure. OCI compute costs are extremely competitively priced, allowing ScaleGrid to offer database hosting on OCI savings of…