Tag Info

New answers tagged

0

Wrong design. When you need one more phrase, you have to ALTER TABLE, which is a costly operation. Instead... Build a new, 3-column, table PhraseGroups with PRIMARY KEY(languageid, phrasegroup). It will have L*P rows, where L = number of languages and P = number of phrasegroups. phrasegroup would be VARCHAR(44) and contain 'global' or 'forum' or ...


0

You show "create table" with MyISAM engine but the error comes from InnoDB so either you changed it or RDS did. From manual: "Tables created in older versions of MySQL use the Antelope file format, which supports only ROW_FORMAT=REDUNDANT and ROW_FORMAT=COMPACT. In these formats, MySQL stores the first 768 bytes of BLOB, VARCHAR, and TEXT columns ...


1

You can't download a snapshot from RDS you have to use a tool like pg_dump This has already been answered multiple times on regular Stack Overflow: http://stackoverflow.com/questions/14916899/download-rds-snapshot


1

If your first test showed a problem, assume that there is a problem! Problems don't just disappear on production, even if you have the best possible theory for their existence, you still need to test. BCP copy should be using row-level locks by default. Which should escalate to page-level locks due to the size of your data. If despite these locks, you are ...


1

You can't add your own extensions to RDS, at least not ones that require superuser rights (like anything with C code). This is one of the downsides you accept in exchange for convenient management. If the extension only includes simple plpgsql and sql functions you can add the functions manually. That is not possible with anything requiring superuser ...


0

Currently there are a few available extensions in Amazon RDS -- detailed in the "Database Engine Features" chapter. You can issue the following command to get the available extensions supported: SHOW rds.extensions;


0

Suppose I have a replication pattern of a single write DB and multiple read DB replication slaves - I do not have to have GUID's as my unique IDs fields. Is that a correct assumption? Correct. As Basil Bourque wrote it doesn't matter what you kind of IDs you use if you have a single master source of data. If I have multiple DB instances where ...


1

Last month, I answered this question : Synchronizing a RDS instance with another RDS instance From researching and answering that post, I recently learned that you can set read_only off on a MySQL RDS Slave. What can this mean for you ? A very unique opportunity. What opportunity ? CONVERT ALL YOUR MyISAM TABLES TO InnoDB !!! Once you have made the RDS ...


0

Not sure if you just want to create a read replica clicks away from you? If not then I guess you need to restore from a dbsnapshot. You can: stop slave. note show slave status. create db snapshot. start slave on first slave. use dbsnapshot to create new rds instance. use co-ordinates to replicate from external master. Also if not and you're looking to ...


1

Yes, it is safe. Vacuum full will recreate the tables as new objects and only when they're done they will be put to use. If you cancel it, the new files not yet put to use will be removed and old ones will be kept. Of course if you would cancel it by killing the process handling the vacuum there would be files left, but still the database would be intact.


1

Use this version of NW instead. Its very light (2.6 MB in disk) and you can download the scripted version. Should be just fine.


0

It is a socket file used for inter-process communication, you have to stop the local MySQL server and make sure the mysql.sock doesn't exist. Then you have to re-create the socket file to send the connection to the correct destination (in your case, it is Amazon RDS). There are many ways to create a socket file, for example you can use socat, and the ...



Top 50 recent answers are included