Migration to External database
Answered
We are default HSQL database that comes along with Teamcity, getting below warning. We upgraded from TC 8 to 9.1.1, Would like to know
Maximum level of Warning, upto what size this can be safely used. Can this be increased.
Which database can be setup quickly and easily. Please provide steps for external database migration.
Is it possible to increase the size of internal database, getting warning from around 175 MB.
Warning -
"The server currently uses the internal database whose size has grown over the warning level and is already 224 MB. To achieve better performance and reliability, switching to a standalone database is strongly recommended."
Request your help in finding out solution.
Thank you
Please sign in to leave a comment.
https://confluence.jetbrains.com/display/TCD9/Migrating+to+an+External+Database
Hello Prashanth,
We strongly recommend using an external database as a back-end TeamCity database in a production environment. Please migrate to external database. Please review the list of supported databases, and see how to Set up an External Database and Migrate to an External Database.
Teamcity is using mysql, which is a external database. Could you please help on how to resolve the reported error.
[root@csgteamcity ~]# ps -ef | grep mysql
root 19483 19367 0 16:37 pts/0 00:00:00 grep mysql
root 26699 1 0 2015 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 26791 26699 0 2015 ? 00:30:37 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
Thank you.
Prashanth,
Sorry, but I don't understand what issue is affecting you at the moment. Could you please describe the issue in detail?
Hi Alina, Thanks for getting back. While editing the build configurations, we are getting this message. Would like to know how to resolve this error. Please provide info.
Warning -
"The server currently uses the internal database whose size has grown over the warning level and is already 224 MB. To achieve better performance and reliability, switching to a standalone database is strongly recommended.
Thank you.
Could you please attach screenshot of Administration > General Settings page and teamcity-server.log file?
Please let me know how to upload log file & which external DB can be setup quickly, we are running production environments.
Thank you.
Your TeamCity server uses internal HSQL database. You should migrate to an external database.
Please review the list of supported databases, see the notes on choosing external database and select one. In house, we use MySQL. Then set up the external database as described here and migrate TeamCity data from HSQL to the new database.
If you face any difficulties while migration, please do not hesitate to ask.