In MySQL, schema and database are essentially synonymous so not like Oracle and I believe SQL Server. Nevertheless, the MySQL server can have multiple database/schema that are designed just like jmc said.

I have essentially identical schema/database for each client on our webserver. If I had a need I could do joins in queries. I have never tried cascading deletes across schemas, but you could certainly test it easily enough.