mariaDB

[ultimate_heading main_heading=”mariaDB” main_heading_color=”#ffffff” sub_heading_color=”#ffffff” alignment=”left” main_heading_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ main_heading_style=”font-weight:500;” main_heading_font_size=”desktop:50px;” main_heading_line_height=”desktop:60px;” sub_heading_font_family=”font_family:Roboto|font_call:Roboto|variant:300″ sub_heading_style=”font-weight:300;” sub_heading_font_size=”desktop:24px;” sub_heading_line_height=”desktop:28px;”]Relational Database Management System[/ultimate_heading]

[ultimate_heading main_heading=”Description” main_heading_color=”#000000″ sub_heading_color=”#000000″ alignment=”left” main_heading_font_size=”desktop:28px;” main_heading_line_height=”desktop:40px;” sub_heading_font_size=”desktop:20px;” sub_heading_line_height=”desktop:22px;” sub_heading_font_family=”font_family:Roboto|font_call:Roboto|variant:300″ sub_heading_style=”font-weight:300;”]maraiDB is a relational database management system (RDBMS) which has more than 11 million installations. mariaDB is a fast, stable, robust, easy to use, and true multi-user, multi-threaded SQL database server.[/ultimate_heading][ultimate_heading main_heading=”Included in this Appliance” main_heading_color=”#000000″ sub_heading_color=”#000000″ alignment=”left” main_heading_font_size=”desktop:28px;” main_heading_line_height=”desktop:40px;” sub_heading_font_family=”font_family:Roboto|font_call:Roboto|variant:300″ sub_heading_style=”font-weight:300;” sub_heading_font_size=”desktop:16px;” sub_heading_line_height=”desktop:18px;”]This appliance includes all standard features and on top of that:

• MariaDB
• Web Control Panel
• Adminer administration frontend for MySQL (listening on port 12322 – uses SSL).
• MySQL webmin module.
• MySQL is configured to listen on port 3306 TCP on all interfaces by default.
• For convenience MySQL is configured to accept connections from all hosts by default. In a production environment it is recommended to limit incoming connections to specific hosts:

  UPDATE `mysql`.`user` SET `Host` = 'hostname'
  WHERE CONVERT( `user`.`Host` USING utf8 ) = '%' AND
  CONVERT( `user`.`User` USING utf8 ) = 'adminer' LIMIT 1 ;
  

Note: MySQL can be further tweaked to optimize performance.[/ultimate_heading][ultimate_heading main_heading=”Usage details & Logging in for Administration” main_heading_color=”#000000″ sub_heading_color=”#000000″ alignment=”left” main_heading_font_size=”desktop:28px;” main_heading_line_height=”desktop:40px;” sub_heading_font_family=”font_family:Roboto|font_call:Roboto|variant:300″ sub_heading_style=”font-weight:300;” sub_heading_font_size=”desktop:16px;” sub_heading_line_height=”desktop:18px;”]No default passwords: For security reasons there are no default passwords. All passwords are set at system initialization time. Ignore SSL browser warning: browsers don’t like self-signed SSL certificates, but this is the only kind that can be generated automatically. If you have a domain configured, then via Confconsole Advanced menu, you can generate free Let’s Encypt SSL/TLS certificates. Web – point your browser at either:

1. http://12.34.56.789/ – not encrypted so no browser warning
2. https://12.34.56.789/ – encrypted with self-signed SSL certificate

Note: some appliances auto direct http to https. Username for database administration:

1. Adminer; login as MySQL username adminer:https://12.34.56.789:12322/ – Adminer database management web app
2. MySQL command line tool; log in as root (no password required):

   $ mysql --user root
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   mysql>
   

Username for OS system administration: Login as root

1. Point your browser to:
   • https://12.34.56.789:12321/ – System control panel
   • https://12.34.56.789:12320/ – Web based command line terminal
2. Login with SSH client:

   ssh [email protected]
   

* Replace 12.34.56.789 with a valid IP or hostname.[/ultimate_heading]

[ultimate_heading main_heading=”Create your mariaDB Appliance” main_heading_color=”#ffffff” sub_heading_color=”#ffffff” alignment=”left”]Deploys instantly. 2 month free with annual plans.[/ultimate_heading][ultimate_carousel slides_on_desk=”4″ slides_on_mob=”1″ autoplay=”off” arrow_color=”#ffffff” arrow_size=”36″ dots_color=”#ffffff”][ultimate_pricing design_style=”design05″ color_scheme=”custom” color_bg_main=”#ffffff” color_txt_main=”#000000″ color_bg_highlight=”#4eac47″ package_heading=”Basic” package_sub_heading=”Perfect to start with” package_price=”AED 24.90″ package_unit=”per month” package_btn_text=”Deploy now” price_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ price_font_style=”font-weight:500;” price_font_size=”desktop:26px;” price_line_height=”desktop:28px;”]1 vCPU 1 GB RAM 25GB Disk 1TB Traffic[/ultimate_pricing][ultimate_pricing design_style=”design05″ color_scheme=”custom” color_bg_main=”#ffffff” color_txt_main=”#000000″ color_bg_highlight=”#4eac47″ package_heading=”Standard” package_sub_heading=”Great entry Performance” package_price=”AED 49.90″ package_unit=”per month” package_btn_text=”Deploy now” price_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ price_font_style=”font-weight:500;” price_font_size=”desktop:26px;” price_line_height=”desktop:28px;”]1 vCPU 2 GB RAM 25GB Disk 1TB Traffic[/ultimate_pricing][ultimate_pricing design_style=”design05″ color_scheme=”custom” color_bg_main=”#ffffff” color_txt_main=”#000000″ color_bg_highlight=”#4eac47″ package_heading=”Economy – RAM” package_sub_heading=”Memory optimized Performance” package_price=”AED 79.90″ package_unit=”per month” package_btn_text=”Deploy now” price_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ price_font_style=”font-weight:500;” price_font_size=”desktop:26px;” price_line_height=”desktop:28px;”]1 vCPU 3 GB RAM 40GB Disk 1TB Traffic[/ultimate_pricing][ultimate_pricing design_style=”design05″ color_scheme=”custom” color_bg_main=”#ffffff” color_txt_main=”#000000″ color_bg_highlight=”#4eac47″ package_heading=”Economy – Balanced” package_sub_heading=”Balanced Performance” package_price=”AED 79.90″ package_unit=”per month” package_btn_text=”Deploy now” price_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ price_font_style=”font-weight:500;” price_font_size=”desktop:26px;” price_line_height=”desktop:28px;”]2 vCPU 2 GB RAM 40GB Disk 1TB Traffic[/ultimate_pricing][ultimate_pricing design_style=”design05″ color_scheme=”custom” color_bg_main=”#ffffff” color_txt_main=”#000000″ color_bg_highlight=”#4eac47″ package_heading=”Economy – CPU” package_sub_heading=”CPU optimized Performance” package_price=”AED 79.90″ package_unit=”per month” package_btn_text=”Deploy now” price_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ price_font_style=”font-weight:500;” price_font_size=”desktop:26px;” price_line_height=”desktop:28px;”]3 vCPU 1 GB RAM 40GB Disk 1TB Traffic[/ultimate_pricing][ultimate_pricing design_style=”design05″ color_scheme=”custom” color_bg_main=”#ffffff” color_txt_main=”#000000″ color_bg_highlight=”#4eac47″ package_heading=”Premium” package_sub_heading=”For medium sized deployments” package_price=”AED 129.90″ package_unit=”per month” package_btn_text=”Deploy now” price_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ price_font_style=”font-weight:500;” price_font_size=”desktop:26px;” price_line_height=”desktop:28px;”]2 vCPU 4 GB RAM 60GB Disk 1TB Traffic[/ultimate_pricing][ultimate_pricing design_style=”design05″ color_scheme=”custom” color_bg_main=”#ffffff” color_txt_main=”#000000″ color_bg_highlight=”#4eac47″ package_heading=”Premium Plus” package_sub_heading=”Larger Deployments” package_price=”AED 249.90″ package_unit=”per month” package_btn_text=”Deploy now” price_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ price_font_style=”font-weight:500;” price_font_size=”desktop:26px;” price_line_height=”desktop:28px;”]4 vCPU 8 GB RAM 120GB Disk 1TB Traffic[/ultimate_pricing][ultimate_pricing design_style=”design05″ color_scheme=”custom” color_bg_main=”#ffffff” color_txt_main=”#000000″ color_bg_highlight=”#4eac47″ package_heading=”Enterprise” package_sub_heading=”Enterprise Grade Performance” package_price=”AED 649.90″ package_unit=”per month” package_btn_text=”Deploy now” price_font_family=”font_family:Roboto|font_call:Roboto|variant:500″ price_font_style=”font-weight:500;” price_font_size=”desktop:26px;” price_line_height=”desktop:28px;”]6 vCPU 16 GB RAM 250GB Disk 1TB Traffic[/ultimate_pricing][/ultimate_carousel]