Database

OCIO Web Hosting offers fast and free database services for use with your website.  Features include:

  • High-speed hardware and optimal tuning for large scale applications
  • Disaster recovery (DR) via full nightly backups
  • High-availability (HA) via redundant servers with full bidirectional replication
  • Latest stable software versions with many optional features enabled

All of this is handled transparently in the background so that you only need to connect to it as you would a simple, single-server configuration.

Connection Info

Type: MySQL
Host: webdb1.service.ohio-state.edu
Port: 3306

The database name, user, and password will have been provided to you by 8help when they created them.  Contact 8help if you have lost or forgetten your credentials.  Please note however that database logins are one-way encrypted (hashed) and existing values cannot be retrieved – only reset to new ones.

Logical Backups

Logical backups refer to backups needed for changes such as upgrading your CMS.  The CMS's commonly recommend that you backup your database prior to initiating your upgrade.  This can be accomplished via:

  1. ssh to the server (webssh.osu.edu) and run the mysqldump from the command line.  This makes it convenient to leave a server-side backup for instance to your /usr/local/webs/<your-site>/tmp/ directory.
  2. use SQL workbench to connect directly to the database (webdb1.service.ohio-state.edu) from your workstation to create a "local"/workstation backup 
  3. go to webdb.osu.edu and leverage phpMyAdmin to backup the database

For larger databases, option 1 is recommended.

NOTE:  Option 1 and 2 require that you connect from the OSU network or VPN to the OSU network.  Anyone with a name.n may do this.  (See: http://go.osu.edu/vpnsetup )

Encryption

The database servers support encrypted connections.  The CA they use is below or can be downloaded from here.  While not mandatory, if you would like a client cert signed then please send us a CSR and, after verifying that it is in fact from the customer specified, we will do so using that same CA.

-----BEGIN CERTIFICATE-----
MIIGETCCA/mgAwIBAgIBATANBgkqhkiG9w0BAQUFADCBoTELMAkGA1UEBhMCVVMx
DTALBgNVBAgTBE9oaW8xETAPBgNVBAcTCENvbHVtYnVzMSIwIAYDVQQKExlUaGUg
T2hpbyBTdGF0ZSBVbml2ZXJzaXR5MRgwFgYDVQQLEw9PQ0lPIE1pZGRsZXdhcmUx
EDAOBgNVBAMMB09DSU9fQ0ExIDAeBgkqhkiG9w0BCQEWEWhpY2tzLjM2N0Bvc3Uu
ZWR1MB4XDTE0MTAxNDAwMDAwMFoXDTI0MTAxMzIzNTk1OVowgaExCzAJBgNVBAYT
AlVTMQ0wCwYDVQQIEwRPaGlvMREwDwYDVQQHEwhDb2x1bWJ1czEiMCAGA1UEChMZ
VGhlIE9oaW8gU3RhdGUgVW5pdmVyc2l0eTEYMBYGA1UECxMPT0NJTyBNaWRkbGV3
YXJlMRAwDgYDVQQDDAdPQ0lPX0NBMSAwHgYJKoZIhvcNAQkBFhFoaWNrcy4zNjdA
b3N1LmVkdTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBALXNkCxQe9Dr
j/Vy9jDXTCYoynp4n7NnNxfGmPj8HlbA8P9LVhDqQC4POubgoiuG1zuHWl9BMJvw
OwQjH0JS/q4Iznepu6CENuG+wEqc+m5Z53R5yjzF7zJECkVFaceZ9QCzmlqwtpnY
Zdp+c+d8EFfgcU9qZJyNz5rNMM3oSQwtTY/SMIlik+OTbpVIxHh8QOEN6CWlIjNs
DXXs7+/2l3Vawz+4NSdelixIfRNkrxmYpQHwag1TeCJ12OwlO/dsN/TTSd0x7RRN
Q7hkOSkdOqnK0SVv3qC6m4NETudOARiCgyvIVLyyFH1ICLUwlkFUaLDhL9iqgzW7
E/sgUuO4q5Ts8YEy8Nl2KxD/SS7Gk+6zIyjnmwznKSYThumft0q8Aam/PmQKNHa4
wwdTQtHoPh6/rONIu/9stPjgEuktkpq2vsCYFdgJaWicQKOkMssIMy1dJfERW0TT
yFveLmgIH4abyTzx4rdkVbSGflz31xKg3gItJtZcH7g7/fJsyjKHpJsQfQG57S2D
CsRb/tzjxk+tazbgiL/mLrEEoVeDBc+q5zx4m4eMQg1iuqSVnHNeUqZJR9kO7vwx
LJy8OnDWHBthXPne09Budfc5CnWRWl2DfnxvOuTDXDhJUGgLmRH1lSbDMYwHOAyw
wH8B36N5ofb7B1w82aZApxvwktFDVh0TAgMBAAGjUjBQMA8GA1UdEwEB/wQFMAMB
Af8wHQYDVR0OBBYEFO46f70FzymeA/kAK1EIGHNtC4YtMAsGA1UdDwQEAwIBBjAR
BglghkgBhvhCAQEEBAMCAAcwDQYJKoZIhvcNAQEFBQADggIBAIxmpisYkIlKlQaD
RF1ToL/FKrUQ6fLlkUVUALDBgYbqkZxOQeGYlbAhK3k26an81mJur/RT9FYrtuEx
Oq96j7caOVDay2bn6XRobR0qNHQhrztXOqwBbnpUAImD2lAqGg6BXkdXBRGmw9pj
knECNidPACcRV4/l2sAjFjfhsfW/zMOkn/k8opiXIqLAYvLviUtVt6qWQjEA2Jwd
GEdw9bPOAz/WrtddsACerBKFT2qw0KS61ElbP8QcUD56/Lav/lkfokW2hNHa4O8R
zJZ6LLojoZcbx76Dkoa0YYnPseWExNlwYPifxrBVB1Asi52lERIBoWFCG4cgh0bb
mk3PMgZUwe5bMiVPr68Z/SZhqKCdU5T3rb3k2pyp32Mm9xWCDyzQ9vfxYjGaDl/l
em/FZitUYXb8V4FMWCf4knapmG3EqzWi4EYDKpcXyTi+XZ1HObIvD7EAiCLIcrzo
OLuXl6Dxk2MUfyhAObBFRfIY45IAwdLBOdLdCb4YT3hPd5LcujDvbf6fyevkZX/e
ATrM4zbNm/FVMsRx1nncKV9dZ8mQY8aNVZ7xux+VC9lZXJn34TPYFYv348D1TWcs
2i23TmYChPhzpnzOMf/lFT8X9XYb/P79R65tagO04vmYpvzrFc6FR8bWX51pvpCe
1/bqbwmGc7lEqfv5vnlFJYgJKTKD
-----END CERTIFICATE-----

Need More Information?

Is OSU Web Hosting right for you? Check your eligibility.

More questions? Check the support section or email 8help@osu.edu.

Ready to get started? Request hosting now!

Looking for a specific website? Check out our A - Z website list.

Sitemap