Comments (8)
mfekadu
commented on September 16, 2024
Discuss && consider updating the MySQL setup docs
notes from MySQL setup docs in Wiki
- MySQL is taught to Cal Poly Computer Science students in CSC 365
- MySQL is reportedly used by large software companies, which suggests it is reliable, scalable, and maintainable
- MySQL's relational model of storing data allows it to represent the relations between relevant objects. See the database schema
(e.g., Dr. Khosmood's entry in the Professors table might have a relation to many entries in the Courses table and vice-versa. This is known as a many-to-many relation.)
from api.
mfekadu
commented on September 16, 2024
Set up snapshots on GCP to promote #reliability
https://cloud.google.com/compute/docs/disks/create-snapshots
from api.
snekiam
commented on September 16, 2024
Recap of what got us here:
Our instances on GCP had 'test' in their names, and we didn't setup snapshots. While cleaning up some instances in our GCloud account, our 'test' instances were removed, since there was confusion about which instances were actually being used. Since we had no snapshots, our database was gone.
We should setup our infrastructure so if an instance does get deleted, it does not cause data loss, and only causes us to need to recreate the instance and restore a backup.
from api.
mfekadu
commented on September 16, 2024
Run through the MySQL setup documentation to deploy the MySQL server.
We are now considering CloudSQL instead of the Compute Engine way of managing MySQL as seen in the MySQL wiki doc
from api.
snekiam
commented on September 16, 2024
Info on cloud sql: https://stackoverflow.com/a/34030484/13291759
from api.
mfekadu
commented on September 16, 2024
good reasons for CloudSQL
utf8mb4supports emojis😄 - @Jason-Ku
from api.
snekiam
commented on September 16, 2024
How far did we get last week?
from api.
snekiam
commented on September 16, 2024
The database is restored! We're working on geting the API back up now. GCP seems to be running backups now automatically.
from api.
Related Issues (20)
- Server 500s after running for a period of time. HOT 3
- 500 Error when asking a question about course prerequisites HOT 2
- 500 Error when asking a question about office hours HOT 4
- session.close should happen in __del__
- 500 error when asking questions about a club HOT 1
- asking for "Help" results in an unhelpful IndexError HOT 1
- /new_data/feedback TypeError: the JSON object must be str, bytes or bytearray, not dict
- /ask/ sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back HOT 5
- When the NLP model doesn't find variables in the question, It throws error HOT 1
- ValueError: query data dimension must match training data dimension HOT 2
- Formatting Refactor Discussion HOT 3
- Route to retrieve unvalidated QA data
- MySql sessions dying on GCP HOT 4
- Function to log errors and details to a new table
- Generic Error handling HOT 2
- SSL Certificates not renewing on GCP correctly HOT 1
- Create a new MySQL transaction after the transaction has been rolled back HOT 1
- Broken MySQL Sessions HOT 1
- Empty answers for some questions HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from api.