Re: [Savannah-hackers-public] SQL Database Upgrade Plan

2024-07-14 Thread Bob Proulx
The database migration has been completed. internal2 is now carrying the full work load. The database on internal1 has been turned off and disabled to prevent accidentally creating a "split-brain" database. All database table engines were migrated from MyIASM to InnnoDB. All charsets were migrat

Re: [Savannah-hackers-public] SQL Database Upgrade Plan

2024-07-11 Thread Bob Proulx
Ineiev wrote: > Bob Proulx wrote: > > I would like to upgrade the Savannah SQL database. ... > > Sounds great. I will proceed with the plan then. :-) Bob

Re: [Savannah-hackers-public] SQL Database Upgrade Plan

2024-07-10 Thread Ineiev
On Wed, Jul 10, 2024 at 10:42:53PM -0600, Bob Proulx wrote: > > I would like to upgrade the Savannah SQL database. Currently due to > the long history and legacy many of the database tables are of of > engine type MyISAM and of various legacy charset types. That reflects > the current defaults w

[Savannah-hackers-public] SQL Database Upgrade Plan

2024-07-10 Thread Bob Proulx
Ineiev, I would like to upgrade the Savannah SQL database. Currently due to the long history and legacy many of the database tables are of of engine type MyISAM and of various legacy charset types. That reflects the current defaults when those tables were created. If we were doing things today