mysql


MSSQL

Database logs can be useful tools when analyzing database performance or troubleshooting issues.  You can enable logging slow queries or general database activity for a MySQL Cloud Databases instance by attaching a configuration...
0 Comments
Filed in: Cloud Databases
 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites

IIS and ASP.NET

The version of MySQL installed on Cloud Sites that use Windows technology is currently MySQL Connector Version 5.2.5.  If your .NET application requires a later version of MySQL, you can perform what's called a bin deploy,...
0 Comments
Filed in: Cloud Sites
 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites

MySQL

The version of MySQL installed on Cloud Sites that use Windows technology is currently MySQL Connector Version 5.2.5.  If your .NET application requires a later version of MySQL, you can perform what's called a bin deploy,...
0 Comments
Filed in: Cloud Sites
A MySQL server timeout can occur for many reasons, but happens most often when a command is sent to MySQL over a closed connection. The connection could have been closed by the MySQL server because of an idle-timeout; however, in...
0 Comments
Filed in: Cloud Servers
Manipulating a database server
Running a well-tuned and efficient database server takes a lot of knowledge and hard work. We're not going to help you do that here.
No, this is a quick and dirty list of common tasks, using the...
1 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Arch Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Gentoo Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Red Hat Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Fedora Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on CentOS Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
7 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Debian Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Ubuntu Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
0 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
2 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
0 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
0 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
5 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
1 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
3 Comments
Filed in: Cloud Servers
What is MySQL?
MySQL is a database server, software that stores and retrieves data for other applications. You might need a database that will work with an application you're developing, or you may just want a database so you can...
0 Comments
Filed in: Cloud Servers
Note: Rackspace Support cannot assist with master-master replication setups due to the complexity of configuration and likelihood of error.  As an alternative to direct MySQL master-master replication, consider either our Cloud...
2 Comments
Filed in: Cloud Servers
This article is about setting up MySQL Master-Slave database replication between two Cloud Servers. Master-Slave data replication allows for replicated data to be copied to multiple computers for backup and analysis by multiple...
1 Comments
Filed in: Cloud Servers

Contents
1 Abstract
2 Introduction
3 SQL Injection Examples
4 Cheat Sheet On SQL Injection Attacks Against MySQL Databases
5 SQL Injection by Exploiting the INFORMATION_SCHEMA
6 Preventing MySQL SQL Injections
7 Summary
8...
0 Comments
Filed in: Cloud Servers
Installing MySQL on Ubuntu Intrepid is very simple using the 'aptitude' package manager.
This article will go through the install process and also look at what other packages are need for MySQL to integrate with Ruby on Rails and...
0 Comments
Filed in: Cloud Servers
This tutorial will walk you through setting up a user on your MySQL server to connect remotely.
The following items are assumed:
You have access to login as the 'root' MySQL user

Contents
1 Getting your IP address
2 Granting...
11 Comments
Filed in: Cloud Servers
This article will walk you through creating/editing columns in tables. It will also walk you through adding rows to your tables.

Contents
1 Preparation
2 Log in
3 Add a column
4 Inserting a record
5 Selecting a record
6 Update a...
0 Comments
Filed in: Cloud Servers
This article will teach you how to create and delete tables in your MySQL server.

Contents
1 Preparation
2 Log in
3 Which database?
4 Create a table
5 Show
6 Rename
7 Drop


Preparation
If you deleted 'mytestdb' then please see...
1 Comments
Filed in: Cloud Servers
Creating users for MySQL runs along the same lines as adding users on the Cloud Server itself - you create a user with a password and assign permissions to different databases as needed.
As with the other MySQL commands, you will...
3 Comments
Filed in: Cloud Servers
The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.
Losing one can be a difficult issue to...
13 Comments
Filed in: Cloud Servers
MySQL replication enables one database server (we'll call it the Master server) to be replicated to one or more database servers (we'll call those the Slave servers). With MySQL, replication is asynchronous. This means your Slave...
4 Comments
Filed in: Cloud Servers

Microsoft .NET

The version of MySQL installed on Cloud Sites that use Windows technology is currently MySQL Connector Version 5.2.5.  If your .NET application requires a later version of MySQL, you can perform what's called a bin deploy,...
0 Comments
Filed in: Cloud Sites

Server Management

You can set the server time zone for a Cloud Databases instance so that it is persistent by using the configuration groups feature of Cloud Databases. You can use either the Cloud Databases API or the trove command line tool to...
0 Comments
Filed in: Cloud Databases

Windows Server 2012

Follow the procedure below to set up MySQL on Windows Server 2008R2 and 2012 with the Microsoft Web Platform Installer or WebPI. 
Installing MS WebPI
The Microsoft Web Platform Installer makes it simple to install a variety of...
0 Comments
Filed in: Cloud Servers

Databases

Note: To complete this process, you will need both a cloud server and a cloud database.
Use the following steps to connect to Cloud Databases by using MySQL Workbench.
Go to http://www.mysql.com/products/workbench/ and install...
0 Comments
Filed in: Cloud Databases

FTP

Now available in Cloud Sites - MySQL 5.1!  
Read on to learn the process of migrating your current Cloud Sites running MySQL 5.0 to begin running on a MySQL 5.1 database.  
Migrating your sites to a newer version of MySQL will...
2 Comments
Filed in: Cloud Sites
 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites

Linux and PHP

Now available in Cloud Sites - MySQL 5.1!  
Read on to learn the process of migrating your current Cloud Sites running MySQL 5.0 to begin running on a MySQL 5.1 database.  
Migrating your sites to a newer version of MySQL will...
2 Comments
Filed in: Cloud Sites
 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites

Linux MySQL

Now available in Cloud Sites - MySQL 5.1!  
Read on to learn the process of migrating your current Cloud Sites running MySQL 5.0 to begin running on a MySQL 5.1 database.  
Migrating your sites to a newer version of MySQL will...
2 Comments
Filed in: Cloud Sites
 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites
Cloud Sites will be retiring MySQL 4 soon in favor of MySQL 5. Any sites using MySQL 4 after November 1, 2011, will be automatically migrated to MySQL 5.
Migrating affected sites between MySQL versions will of necessity involve...
0 Comments
Filed in: Cloud Sites

Contents
1 Abstract
2 Introduction
3 SQL Injection Examples
4 Cheat Sheet On SQL Injection Attacks Against MySQL Databases
5 SQL Injection by Exploiting the INFORMATION_SCHEMA
6 Preventing MySQL SQL Injections
7 Summary
8...
0 Comments
Filed in: Cloud Servers

Backing Up Your MySQL Database
To manage your MySQL database, you'll first need to login to the online manager (phpMyAdmin).
After you are logged into the online manager, click on a database or table in the left frame as shown...
2 Comments
Filed in: Cloud Sites
Importance of using Indexes in your MySQL database:
Indexes help the system to access data fast and provide an ordering on the rows of a table as well as help enforce uniqueness of the values in a table. A lot of performance...
0 Comments
Filed in: Cloud Sites
Note: This article is written for our Cloud Sites Control Panel. You can get to it from the Cloud Control Panel by clicking your name in the upper-right corner and selecting Cloud Sites Control Panel.
Now that you've successfully...
2 Comments
Filed in: Cloud Sites

High Availability - HA

Note: Rackspace Support cannot assist with master-master replication setups due to the complexity of configuration and likelihood of error.  As an alternative to direct MySQL master-master replication, consider either our Cloud...
2 Comments
Filed in: Cloud Servers

Security


Contents
1 Abstract
2 Introduction
3 SQL Injection Examples
4 Cheat Sheet On SQL Injection Attacks Against MySQL Databases
5 SQL Injection by Exploiting the INFORMATION_SCHEMA
6 Preventing MySQL SQL Injections
7 Summary
8...
0 Comments
Filed in: Cloud Servers

Security Tools


Contents
1 Abstract
2 Introduction
3 SQL Injection Examples
4 Cheat Sheet On SQL Injection Attacks Against MySQL Databases
5 SQL Injection by Exploiting the INFORMATION_SCHEMA
6 Preventing MySQL SQL Injections
7 Summary
8...
0 Comments
Filed in: Cloud Servers

Ruby on Rails

Installing MySQL on Ubuntu Intrepid is very simple using the 'aptitude' package manager.
This article will go through the install process and also look at what other packages are need for MySQL to integrate with Ruby on Rails and...
0 Comments
Filed in: Cloud Servers

Other Mail Servers

Following from the previous article, we now have our firewall opening the correct ports.
Now we can start adding domains and users to the MySQL 'mail' database.

Contents
1 Overview
2 Domains
3 Users
4 Reload Postfix
5 Test
6...
17 Comments
Filed in: Cloud Servers

Performance

Importance of using Indexes in your MySQL database:
Indexes help the system to access data fast and provide an ordering on the rows of a table as well as help enforce uniqueness of the values in a table. A lot of performance...
0 Comments
Filed in: Cloud Sites

Uncategorized

NOTE: This article is written for our Classic Cloud Control Panel. You can access this interface from the New Cloud Control Panel by clicking your username in the upper-right of the control panel and selecting "First-Generation...
2 Comments
Filed in: Cloud Sites