Browsing articles tagged with "rds - Admins Goodies"
Aug 23, 2012
tom

Installing language pack (MUI) on remote desktop services windows server 2008

I’m experimenting with the remote desktop services role (terminal server) on server 2008 and I’m not entirely sure if the installation of a language pack should be done in “install mode”. Is it a “best practice” to use “install mode” for ALL installations once the RDS role is active or should I be selective depending on what is installed, e.g. language pack? Asked by yonatan Anything that installs that makes changes to the HKCU registry [...]

Continue Reading »
Jun 7, 2012
tom

RDS slave (read replica) not replication

It appears overnight our Master RDS mysql server went offline for 3-4 minutes. When it came back online the replication was broken. On the slave, issuing SHOW SLAVE STATUS\G; “Got fatal error 1236 from master when reading data from binary log: ‘Client requested master to start replication from impossible position’” In AWS monitoring, slave lag shows “-1.0″. Is there a way to get the slave replication restarted, or should I just create a new slave? [...]

Continue Reading »
Apr 16, 2012
tom

How do you recover you RDS master user username?

Resetting the RDS master user’s password is simple enough, but how do you find your master users username? Asked by mkirk The master user name can be recovered with the rds-describe-db-instances command. Answered by Jan Fabry Check more discussion of this question. Bookmark on Delicious Digg this post Recommend on Facebook share via Reddit Share with Stumblers Tweet about it Print for later Bookmark in Browser Tell a friend

Continue Reading »
Mar 21, 2012
tom

RemoteApp .rdp embed creds?

Windows 2008 R2 server running Remote Desktop Services (what we used to call Terminal Services back in the olden days). This server is the entry point into a hosted application — you could call it Software as a Service I suppose. We have 3rd party clients connecting to use it. Using RemoteApp Manager to build RemoteApp .rdp shortcuts to distribute to client workstations. These workstations are not in the same domain as the RDS server. [...]

Continue Reading »
Feb 9, 2012
tom

Amazon RDS to EC2 replication [closed]

Possible Duplicate: Is it possible to use an EC2 RDS MySQL instance as a slave to an external master? My read-intensive application needs to scale horizontally. It will be deployed by various clients using Amazon EC2. My initial thought is that a basic setup will utilize one RDS instance and one EC2 instance. The EC2 (c1.medium) instance will run a webserver and a local MySQL read replica of the RDS server. The application is configured [...]

Continue Reading »
Dec 8, 2011
tom

How do I quickly create new instances of complex MySQL database?

I’m managing an enterprise web application that uses Amazon’s RDS as our database server. Our architecture is such that when a user signs up for a new account we create a brand new database for them in RDS. The database has around 63 tables, most of which have indexes, and almost all have foreign key constraints. Currently we’re creating each new database by executing a large set of sql statements. This takes on average 57 [...]

Continue Reading »
Sep 24, 2011
tom

Amazon RDS connection not working

I’m developing a Silverlight application that uses a service hosted through an ASP.NET application to communicate with my database. The web site is not hosted on Amazon AWS, but on our own servers using IIS, we’re only using Amazon RDS for the database hosting. When I test the application locally (via visual studio) I am able to connect to the database just fine, and all calls to the database work perfectly. Also, MySQL Workbench connects [...]

Continue Reading »
Aug 20, 2011
tom

Amazon RDS instance stopped responding

We’ve been running a large RDS instance in production for over year without a single moment of downtime. Recently, with a bigger budget and higher stakes, we decided to convert it to a multi-AZ instance, to improve reliability and redundancy of our data. Since then (about two weeks ago), we’ve had two serious failures of our instance which required rebooting. There is nothing in the ‘recent DB events’. There were two DB connection spikes recorded [...]

Continue Reading »
Aug 10, 2011
tom

Speed up RDS printing

We’ve recently moved our clients from a Server 2003 terminal server using ThinPrint .print to Windows Server 2008 R2 RDS via a RDS Gateway using Easy Print. We’ve got some clients in Indonesia on crappy ISDN links who are saying that printing is now taking a lot, lot longer over RDS than it used to over ThinPrint. I’m guessing that ThinPrint somehow spools to a buffer, compresses it, transfers it, and then then prints it, [...]

Continue Reading »