Tag Info

New answers tagged

-4

Excellent stuff. Another search of this site and I'm helped with my query too! I found some cool stuff on another site too which may help others. Cheers guys.


1

PostgreSQL creates subdirectories named for the PostgreSQL version within each tablespace. So AFAIK pg_upgrade doesn't need to be told to take special action for the tablespaces. It will use the same tablespaces as the original database, but won't conflict because of the use of different subdirectories within the tablespace root. The caveat is that if you ...


0

Keith Murphy (co-author of the MySQL Administrator's Bible) quoted here doesn't appear to think that's very good idea - straight copying of binaries. I know that the quotation is quite old, but I, for one, would be very reticent to do something like that. If I were you, I'd try the option at the beginning of the quote - pipe over a dump - I know that you ...


0

I think your plan is largely sound, and is how I handled a similar upgarde (albeit 5.0 > 5.5). What I did was to take a Dump from the Master in the quiet hours like you said, and then set up a new Slave on one of the new 2008r2 boxes. This allows you time to 'play' with the new 5.6 database so you can tweak the config, and make sure the data replicates ...


0

Open up an Command Line Window as Administrator. Then, follow these steps STEP 01 : Shutdown MySQL net stop mysql STEP 02 : Get the MySQL 5.5 Data into the MySQL 5.6 Data Folder cd "C:\ProgramData\MySQL\MySQL Server 5.6" move data data_empty mkdir data cd "C:\ProgramData\MySQL\MySQL Server 5.6\data" xcopy /s "C:\ProgramData\MySQL\MySQL Server ...


0

All details are here: http://docs.mongodb.org/manual/release-notes/2.6-upgrade/ Answer 1: All metadata will get updated. I suggest to execute the mongos --upgrade using an extra mongos Answer 2: You don't have any downtime from the config servers since mongos have the require cached information and balancer is disable Answer 3: There is no other way. You ...



Top 50 recent answers are included