Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
1
vote
1 answer

Running MySql replication between datacenters

I run my website from EC2. Due to AWS outages, I am contemplating replicating my setup on Rackspace and switch over from DNS in case of an outage. I am looking to learn ways to replicate my MySql database across these data centers. Can someone…
Quintin Par
  • 4,373
  • 11
  • 49
  • 72
1
vote
2 answers

SQL Server variable size and increase it

It is not clear to me how a varchar(max) is declared or used in an SQL Server e.g. 2005 Is a variable declared as varchar(300000) for example considered as a varchar(max)? E.g. I am seeing in a DB in a table a variable is declared as…
user76678
  • 349
  • 3
  • 5
  • 16
1
vote
3 answers

What database backup utility should I use?

Can anyone recommend a database backup utility, free or paid? Ideally it will backup MSSQL & MySQL, but MSSQL only will suffice allow backup of single tables encrypt backups Many thanks
Mr. Flibble
  • 723
  • 3
  • 13
  • 23
1
vote
1 answer

Does MS SQL 2005 encryption protect data in the case of physical server access?

I am looking into MS SQL 2005 encryption (not 2008, so TDE is out), and I believe I understand the concept of how a column is encrypted. The OS uses the service credentials to encrypt the service master key, which is used to encrypt the database…
Paul Kroon
  • 2,250
  • 1
  • 16
  • 20
1
vote
5 answers

Moving MySQL Data from 1 RDS server to another

How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another? An interruption of up to 20 mins is acceptable, although not preferred. My current plan is to use Sequel Pro to perform an Export, and then…
iqq
  • 11
  • 1
  • 2
1
vote
1 answer

clustering MS SQL 2008

Possible Duplicate: Sql server active/passive vs active/active clustering I have a Project in DBMS just I need something like a BIG TITLES of What TO DO. Here a brief way about the Project: Install 3 WIN2K8 R2 one of them domain controller…
Ibrahim
  • 11
  • 1
1
vote
1 answer

Mysql slow query log issue...?

Analyzing the slow query log of my mysql database server, i found an interesting query taking more time and making issues in performance of my application.Please help me to find out the issue ? # Query_time: 481 Lock_time: 0 Rows_sent: 25571220 …
Jayakrishnan T
  • 298
  • 2
  • 8
  • 22
1
vote
6 answers

Should a Database admin need to know all the DB systems out there?

What's the requirement? Where's the boundary? Is there any?
Sajal Dutta
  • 613
  • 5
  • 18
1
vote
3 answers

What's the best tool for managing database evolution/versioning?

We need a tool for dealing with database evolution/versioning. And we need the best! :) Can you expert guys help us to find a great tool that has these features? Conceptual Model: The tool must work with a conceptual model so that the working…
andrerpena
  • 345
  • 2
  • 3
  • 11
1
vote
1 answer

Oracle EE 11.2g: how to generate fresh new redo logs

In the company I work for we are heavy users of VMware machines. Almost all our projects are developed inside a virtual environment up to the point where we have to deploy them into a production system. While in development, some colleagues of mine…
Aikanaro
  • 11
  • 2
1
vote
1 answer

What's the best way to split client sites in a PostgreSQL installation?

I need to host several client sites using one PostgreSQL installation. What's the best way to split them -- by schema or by instance? The factors would be what makes admin easier (especially backup/restore of individual sites), performance of the…
Jason
  • 13
  • 2
1
vote
2 answers

How to do MySQL Maintenance especially after disk is full

I have a quite large mysql database (InnoDB) running on ubuntu server virtual machine. Recently due to my fault the hard drive became full (on the physical machine) and the server got stuck and users could not work. I had to delete some files from…
aviv
  • 167
  • 1
  • 1
  • 9
1
vote
2 answers

Linux: How to rename old mysqld when upgrading MySQL?

I'm upgrading MySQL from MySQL 5.0 to Percona Server 5.1. I'm planning to just use yum remove and yum install to do the upgrade. However, I read in the documentation that it's a good idea to rename the old mysqld to mysqld-5.0. And if the upgrade…
Continuation
  • 3,080
  • 5
  • 30
  • 38
1
vote
1 answer

Cannot open DTS packages in SQL 2008 x64

We are deploying a new MS SQL 2008 R2 x64 server running on Win 2008 R2 x64. We need to open DTS packages but receive the error: "SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL…
charnley
  • 577
  • 3
  • 14
1
vote
2 answers

SQL Server Replication Backup

We have a new system that runs on SQL Server 2008 r2 64-bit. There is a primary on-line transactional processing (OLTP) database that accepts a high volume of updates from several thousand Point of Sale systems at stores around the country. In order…
tr0users
  • 413
  • 3
  • 11
  • 16
1 2 3
…
19 20